Overview

The Sales Order Inventory Movement (SIM) reserves available inventory for a specific Sales Order and records the corresponding Cost of Goods Sold and Inventory GL transactions at the item’s weighted-average unit cost. This article covers how to allocate inventory to a Sales Order and how to reverse that allocation. If your Sales Order is to be fulfilled via a Drop Ship Purchase Order, review Process a Drop Ship Purchase Order instead: you do not need to manually allocate inventory - receiving the Drop Ship PO automatically creates the Sales Order allocation.

In this article:

• Before You Begin
• Allocate Inventory to a Sales Order
  • Verify the Allocation
• Unallocate Inventory from a Sales Order
• Important Notes
• Related Articles

Before You Begin

Review the Create a Sales Order article before allocating inventory.

Allocate Inventory to a Sales Order

1. Navigate to Accounting Home > Create Entries > Orders > Sales Orders.
2. Select a list view other than Recently Viewed.
3. Select the Sales Order.
4. Click Allocate. The Allocate Sales Order screen displays a row for each Sales Order Line with the Product Name, Product Code, Quantity Ordered, Quantity Allocated, Quantity Needed, and any Comments. Available and committed inventory quantities are shown by Warehouse and Location.

5. To change the allocation date, click the Allocate Date field. This date sets the Movement Date on the Sales Order Inventory Movement record and the Date on the related GL transactions.
6. In the Allocate field for each row, enter the quantity to allocate from that Warehouse and Location. To fill all available quantities automatically, select Allocate All. If the product exists in multiple locations, the first location fills first; the system moves to the next location if inventory is insufficient. Review all populated quantities before saving.
7. Click Save (available at the top and bottom of the screen). A confirmation banner displays. The Quantity Allocated on each Sales Order Line updates, and the Inventory Quantity Available decreases for each allocated product.

Verify the Allocation

To confirm the allocation was recorded correctly, navigate to the Sales Order Line and click the Related tab. Click the SIM number to open the record. The SIM shows:

• The Quantity moved out of inventory and allocated to the Sales Order Line
• The Inventory Quantity Available record the quantity was moved from
• The weighted-average cost per unit used for the GL transactions. See Inventory Valuation - Weighted-Average Cost for more details.

To view the GL transactions, click the Related tab on the SIM record, then click View All in the Transactions section.

Unallocate Inventory from a Sales Order

To reverse an allocation, delete the SIM record created when inventory was allocated.

Warning: Deleted Inventory Movements are automatically removed from the Recycle Bin and cannot be recovered.

1. Navigate to the SIM record (for example, SIM-00013).
2. Click Delete. A confirmation panel displays.
3. Click Delete to confirm, or Cancel to return without deleting. A confirmation message displays and the Quantity Allocated on the Sales Order Line updates.

Important Notes

• If the Sales Order is to be fulfilled via a Drop Ship Purchase Order, manual allocation is not required. When a Drop Ship PO is received in full, inventory is automatically allocated to the Sales Order. For details, see Process a Drop Ship Purchase Order.
• Unallocation: A deleted Sales Order Inventory Movement is automatically removed from the Recycle Bin and cannot be recovered.
• Do not create or assign a user-defined posting status as a default status on any Inventory Movement object. This will interfere with the posting of Inventory Movement records.

Related Articles

• Create a Sales Order
• Inventory Valuation - Weighted-Average Cost
• Process a Drop Ship Purchase Order (Average Cost)

Return to top