Skip to main content

Assigning Serial Numbers and Batch Numbers on Sales Orders or Sales Shipments

Heather avatar
Written by Heather
Updated over 2 months ago

This feature enables you to assign serial numbers and batch numbers to serialized products on Sales Orders or Sales Shipments. You can also assign selected serial and batch numbers to sales invoices. This is particularly useful when customers need a reference that they can use, i.e. for warranty purposes.


Serial Number

Serial Number Statuses

Serial Numbers have a status of AVAILABLE, UNAVAILABLE or DELETED.

A serial number is AVAILABLE until it is DISPATCHED. Therefore, a serial number can be assigned to more than one open Sales Order (i.e. not COMPLETED) or open Sales Shipment (i.e. not DISPATCHED).

Once a serial number has been DISPATCHED, its status will become UNAVAILABLE.

A serial number can be DELETED and will therefore no longer be available.

Assigning Serial Numbers on a Sales Order

If your business process requires serial numbers to be assigned at the Sales Order stage, clicking in the "Serial" column on the Sales Order Lines will show you:

  • which serial numbers are available

  • which serial numbers are available but have been assigned elsewhere, and,

  • if particular serial numbers on your order has already been dispatched

Scenario: Select Serial Numbers from a list showing those that are available and those that are assigned elsewhere

The following screenshot illustrates how serial numbers are presented on a Sales Order page if some of the serial numbers are assigned on other Sales Orders or Shipments.

Note the warning icon with the message “This serial number is already allocated elsewhere. Click this icon to run a report and obtain more information”. Click the warning icon to run the Serial Numbers Enquiry report to tell you where that serial number is currently being used.

Screenshot 2023-08-25 at 1.02.25 PM.png


If you choose to select a serial number that has been assigned elsewhere, the information message "One or more selected serial numbers are already allocated elsewhere." will display on your Sales Order:

Screenshot 2023-08-25 at 1.02.43 PM.png

Scenario: Select Serial Numbers for a Sales Order that has a partial shipment

The following screenshot illustrates how serial numbers are presented on a Sales Order if some of the serial numbers for this Sales Order have already been dispatched (partial shipment).

Screenshot 2023-08-25 at 1.10.22 PM.png

Scenario: Select Serial Numbers on multiple Sales Orders and COMPLETE one of the Sales Orders. If you have selected the same serial numbers on different Sales Orders and COMPLETED one of the Sales Orders, you will be warned on the open Sales Order with the message “One or more selected serial numbers are unavailable and need to be unassigned from the product.”

Screenshot 2023-08-25 at 1.04.01 PM.png

Selecting the serial column will present the serial numbers previously allocated to the Sales Order Line with an error alongside any serial numbers that are no longer available. The message “This serial number is unavailable and needs to be unassigned from the product. Click the icon to run a report and obtain more information.” will display. By clicking the message, you will be directed to the Serial Number Enquiry report.

Screenshot 2023-08-25 at 1.04.30 PM.png

Assigning Serial Numbers on a Sales Shipment

If your business process requires serial numbers to be assigned at the Sales Shipment stage, clicking in the "Serial" column on the Sales Shipment Lines will show you which serial numbers are available and which serial numbers have been assigned elsewhere.

Scenario: No Serial Numbers assigned on Sales Order

The following screenshot illustrates how serial numbers are presented on a Sales Shipment when no serial numbers have been assigned at the Sales Order stage.

Screenshot 2023-08-25 at 1.27.33 PM.png

If serial numbers have been assigned to other Sales Orders or Sales Shipments, the warning icon will display, and clicking the icon will run the Serial Number Enquiry report.

Scenario: Serial Numbers assigned on Sales Order

The following screenshot illustrates the Shipment option when serial numbers are selected at the Sales Order stage. Only those numbers previously selected are shown in the list with a tick alongside them:
​​

Screenshot 2023-08-25 at 1.31.21 PM.png

When it comes to the shipment, if, for any reason, one or more of the selected serial numbers are unavailable for shipping, select "All Available Serials", untick the previously selected serial numbers and choose the appropriate serial number(s) to ship.
​​

Screenshot 2023-08-25 at 1.27.33 PM.png

Scenario: Selecting Serial Numbers assigned elsewhere

There could be an occasion where you need to ship serial numbers that are already assigned elsewhere. Tick the serial numbers and ship them:

Screenshot 2023-08-25 at 1.28.59 PM.png

Assigning Serial Numbers on both a Sales Order and Sales Shipment

Scenario: Selecting Serial Numbers on a Sales Order and dispatching others on the Shipment

A Sales Order is created for 3 dining tables and the oldest 3 serial numbers selected.

When it comes to the shipment, one of the dining tables is damaged so that dining table’s serial number is unselected and a different serial number is selected to ship.

The result of this will be an overallocation of serial numbers on the Sales Order 4/3:

Screenshot 2023-08-25 at 1.34.07 PM.png

When the Shipment is dispatched, the Sales Order will still show the serial number that was originally selected:

Screenshot 2023-08-25 at 1.35.13 PM.png

Completing the Sales Order will unselect the un-shipped serial number:

Screenshot 2023-08-25 at 1.36.08 PM.png

Note: You can also manually deselect the serial number that was found to be damaged and save the Sales Order.


Batch Number

This feature is available if you have the Batch Tracked option activated on the Product.

Batch Number Statuses

Batch Numbers, like Serial Numbers, have statuses of AVAILABLE, UNAVAILABLE, or DELETED.

A batch number is AVAILABLE until all quantities are DISPATCHED. Those quantities that are available are labeled “UNALLOCATED” when selecting quantities on an order or shipment.

A batch number can be DELETED and will therefore no longer be available.

Assigning Batch Numbers on a Sales Order

Scenario: Batch Numbers assigned on Sales Order If only a single batch was selected, only that batch is displayed.

Scenario: Assigning Batch Numbers on a Sales Order that has a partial shipment

When assigning batch number quantities at the Sales Order stage, clicking in the "Batch" column on the Sales Order Lines will show you (where applicable):

  • which batch numbers are available

  • the unallocated quantities per batch

  • the quantities dispatched

  • the quantities assigned on the Sales Shipment

Screenshot 2023-08-25 at 1.51.45 PM.png

Assigning Batch Numbers on a Sales Shipment

Scenario: No Batch Numbers assigned on Sales Order

If no batch numbers are assigned via the Sales Order, all available batch numbers and available quantities are displayed on the Sales Shipment.

Assigning Batch Numbers on both a Sales Order and Sales Shipment

Scenario: Selecting Batch Numbers on a Sales Order and dispatching others.

In this example, 10 quantities were ordered and assigned over 3 different batch numbers at the Sales Order stage.

At the Shipment stage, a change is required and all 5 quantities are assigned from a single batch number, setting the other batch number to zero:

The Sales Shipment was DISPATCHED.

Returning to the Sales Order, there is now an over allocation of 7 quantities:

Click on the Batch column - you will see the previously assigned quantities from the other batches still present. If you COMPLETE the Sales Order, these quantities and batches will be deallocated from the Sales Order, since all 10 of the quantities have been shipped.
Or you can manually reset the quantities to zero.

The previously allocated quantities will be returned to the unallocated quantities.

BEFORE Completing:

After COMPLETING:


Troubleshooting Common Errors and Issues

Proper tracking and management of serial numbers are crucial for ensuring seamless operations in Unleashed Access. Below, we cover solutions to common errors involving serial number mismatches during stock procedures like creating credit notes and completing sales orders.

Error: "The serial number quantity and the credit quantity to be returned must match"

This error occurs when the serial number count does not align with the quantity being credited. To resolve this:

  1. Assign a valid serial number to the item being credited so that the serial number count matches the quantity to be returned.

  2. Save the order.

  3. Verify the serial number on the invoice and then on the credit note.

Error: "If serial numbers are selected, the serial number quantity and the invoice quantity must match"

This error might arise after a partial invoicing for a Sales Order. Fix it by following these steps:

  1. Open the Sales Order and navigate to the "Invoicing" tab.

  2. Open the existing Sales Invoice in "Parked" status.

  3. In the Sales Invoice, click on the serial number field.

  4. Untick the serial number selection and save the changes.

  5. Complete the Sales Invoice.

  6. Go back to the Sales Order and complete it. This clears serial number mismatches caused by a partial invoice.

If assigning the serial number alone does not resolve the issue, ship the remaining unit with the assigned serial number before processing the credit or return.

Scenario: Invoice created from Sales Order with serial numbers that were not dispatched

You have created a Sales Order and a Sales Invoice based on a selection of Serial Numbers. When it comes to the Shipment, a different set of Serial Numbers are dispatched.

The Sales Invoice selection will now show as follows but can still be edited and resent to your Customer:

Note that once you COMPLETE the Sales Order, the Invoice will tidy itself up and show only 3/3 of the Serial Numbers.

Scenario: 50% Partial Invoice created from Sales Order with 5 serial numbers that were subsequently dispatched

A 50% deposit is required prior to shipping 5 items. Once the deposit is received and the 5 items shipped, return to the Invoice and select the serial numbers.

Note: With partial invoicing, you will need to complete the invoicing of the batch quantities before you can COMPLETE the Sales Order.
​​

Scenario: Invoice created from Sales Order with batch numbers that were not dispatched

You have created a Sales Order and a Sales Invoice based on a Batch Number. When it comes to the Shipment, a different Batch Number was dispatched.

The Sales Invoice selection will now show as overallocated, but can be edited.

Note that once you COMPLETE the Sales Order, the Invoice will tidy itself up and show only the actual dispatched Batch Numbers.

Scenario: 50% Partial Invoice created from Sales Order with Batch Numbers that were subsequently dispatched

A 50% deposit is required prior to shipping 4 quantities of a Batch. A partial invoice is created for 2 quantities. A second invoice will need to be generated by selecting the remaining 2 quantities of that batch.

Best Practices

  • Double-check batch and serial number assignments before saving the transaction.

  • Ensure transaction quantities align with selected serial numbers during partial and full invoicing.

  • Regularly review and clean up serial number lists to prevent duplication or mismatches.


Frequently Asked Questions

What should I do if removing the serial number still does not resolve the issue?

Recheck all quantities and ensure all changes are saved before attempting the operation again. If issues persist, contact support for assistance.

Can I process a credit note without assigning serial numbers?

No, serial numbers are required for tracking returned items. Make sure to assign serial numbers that match the items being credited. By following these steps and adhering to best practices, you can effectively address and prevent common serial number mismatch errors in stock control operations.

Did this answer your question?