Aantar

Aantar Books

Sales Order Fulfillment Worksheet

See which open sales orders your stock on hand can fill — all, some or none — print pick lists, and invoice an order from one screen.

Where: Customers ▸ Sales Order Fulfillment Worksheet

The Sales Order Fulfillment Worksheet lists your open sales orders, oldest first, and tells you for each whether the stock on hand can fill all of it, some of it or none. Select an order to see its lines — what was ordered, what has been invoiced, what is still to fill, what you have on hand and what other open orders want of the same item. Tick orders to print their pick lists together, and invoice an order straight from here.

Opening the worksheet

Customers ▸ Sales Order Fulfillment Worksheet. It opens in a window of its own; Esc closes it and takes you back to where you opened it from. It needs permission for the Sales Orders list.

The toolbar

Control What it does
Customer Search for a customer to show only their orders.
Can fulfill All orders, or only those you can fill All of the order, Some of the order or None of the order.
Refresh Reloads the worksheet.
Print Pick List / Print (n) Pick Lists Prints a pick list for the selected order, or for every ticked order.
Create Invoice Invoices the selected order for what is still to fill.

The orders

Column What it shows
(tick box) Tick orders to print their pick lists together.
Date The order date.
Order The order number.
Customer Who ordered.
Location The location the order ships from.
Amount The order total.
To Fulfill Units still to be invoiced.
Can Fulfill All (green), Some (amber) or None (red): how much of what remains your stock on hand at the order's location covers.

Click an order to show its lines below. With none, No open sales orders. The worksheet shows the oldest 500 open orders; pick a customer to see the rest.

The selected order

Headed ORDER (number) — (customer):

Column What it shows
Item, SKU The item.
Ordered Quantity ordered.
Invoiced Quantity already invoiced.
To Fulfill Quantity still to go.
On Hand Stock at the order's location.
On Other SOs What your other open sales orders want of the same item — so you can see whether filling this order leaves others short.

Pick lists

A pick list is a printed PICK LIST for the warehouse, titled with the order number and date, with Item, SKU, Ordered, Invoiced, To Pick, On Hand and a Picked column to tick, and Picked by ___ Date ___ at the foot. Tick several orders to print all their pick lists in one go.

Invoicing from the worksheet

Select an order and click Create Invoice. Aantar Books puts the order's quantities still to fulfil on a new invoice at the agreed prices — Sales order (number) is on a new invoice — the quantities still to fulfil. Save it to fulfil the order. Adjust the quantities to what is going out and save the invoice. It is exactly the same as Convert in the Sales Orders list: the stock, tax and the order's progress update in the same way. If the order has been completed meanwhile, Aantar Books says it is no longer open.

Note: The worksheet shows open orders with Can Fulfill (All, Some, None), the selected order's details with quantity on hand and on other sales orders, pick lists, and Create Invoice.

Common problems

Problem What to do
An order shows None but you have stock. On hand is counted at the order's location. Transfer stock there, or change the line's location on the invoice.
An order is missing. It is completed, or it is beyond the oldest 500 — search for the customer.

Related articles

Something unclear or out of date? Write to support@aantar.com and name this page.