Hello @laurac,

In Acumatica, when using FIFO (First-In, First-Out) as the inventory valuation method and Batch control with expiry, the system calculates the cost based on the first receipted quantity. This behavior is expected, and your assumption is correct.

During the sales stage, when entering a sales order, the system doesn't allocate specific inventory items yet. Therefore, it doesn't have the information to pick up the exact cost associated with the specific items being sold. The cost calculation is based on the first receipted quantity to ensure the FIFO principle is followed.

However, it's important to note that when the order is shipped or invoiced, Acumatica will recalculate the costs based on the actual quantities being shipped or invoiced. At that point, the system will consider the specific items being sold and apply the appropriate costs based on the FIFO method.

In summary, during the sales order entry stage, Acumatica uses the cost of the first receipted quantity for inventory valuation when using FIFO with Batch control and expiry. The system will recalculate the costs based on the actual quantities being shipped or invoiced, ensuring accurate valuation according to the FIFO principle.

Regards.

Hello @laurac ,

In addition to the explanation Harshita provided, we could have many open sales orders containing the same FIFO item.  At the time of order entry, we don’t yet know which sales order might ship first. Therefore it is the IN Issues batch that updates Inventory costs later in the Sales Order process.

Laura