How NetSuite Prioritizes Transactions for Average Cost on the Same Day

The discrepancy in average cost values often arises because NetSuite prioritizes certain transaction types over others when they occur on the same day. For instance, Vendor Bills and Purchase Receipts typically have a higher processing priority than Transfer Orders and Item Receipts.NetSuite processes transactions affecting average cost on the same date according to a specific, observed priority order. While a comprehensive official list may not be explicitly detailed, the following sequence is generally applied:

1. Inventory adjustment worksheets (First-in-day)

2. Purchase transactions (e.g., purchase receipts, vendor bills, and certain related adjustments)

3. Assembly builds, component builds, transfers and transfer orders (including fulfillments and receipts)

4. Vendor return fulfillments

5. Sale transactions (e.g., sales order fulfillments, invoices, cash sales, and certain related inventory adjustments)

6. Return transactions (credit memos and RMA receipts)

7. Inventory adjustment worksheets (Last-in-day)Understanding this transaction priority is crucial for accurate average cost calculation and inventory valuation, especially during testing or when multiple inventory movements are recorded on the same day.