ANS-1540 · INVENTORY & ITEM MANAGEMENT
How NetSuite Manages Cost Variances Between Item Receipts and Vendor Bills
NetSuite records inventory cost based on the Item Receipt, with any discrepancies from the Vendor Bill posted to a variance account.
Short answer
In NetSuite, the Item Receipt value dictates the inventory cost. Any difference between the Item Receipt and the Vendor Bill is automatically directed to a variance account. Users can manually adjust the Item Receipt, leverage the "Match Bill to Receipt" feature for automated variance calculation, or deploy a script to align the Item Receipt with the Vendor Bill.
Scenario
A common challenge arises when the value recorded on an Item Receipt does not precisely match the value on its corresponding Vendor Bill. This discrepancy raises questions about which transaction's value determines the final inventory cost and how NetSuite accounts for the difference, impacting Cost of Goods Sold (COGS) and financial reporting.
Solution
In NetSuite, the cost that will be associated with an inventory item is determined by the value recorded on the Item Receipt. This is because the Item Receipt is the transaction that directly impacts inventory. When the value on the Vendor Bill differs from the Item Receipt, the resulting difference is automatically posted to a variance account.
To manage these discrepancies, NetSuite offers several approaches:
- Manual Adjustment: The value of the Item Receipt can be changed before the Vendor Bill is saved to ensure the costs align.
- Match Bill to Receipt Feature: Users can utilize the "Match bill to receipt" feature, which automatically calculates and accounts for the variance between the Item Receipt and the Vendor Bill.
- Scripted Correction: For automated resolution, a script can be developed and implemented to adjust the Item Receipt, matching its value to that of the Vendor Bill, thereby resolving the cost discrepancy.
Expert NetSuite Support
Need help with this NetSuite issue?
Inventory & Item Management consulting and configuration support