Scenario:
The user has a custom rebate process where certain customer/item combinations receive special pricing and special inventory costs. After an Item Fulfillment is shipped, an automated inventory adjustment moves inventory into a modified lot with a different cost to support commission calculations. The user wanted to confirm whether this process behaves differently depending on whether the item uses Lot Numbered Costing or Average Costing.
Solution:
This custom process can work reliably when the item uses the Lot Numbered costing method because the inventory cost is maintained and tracked at the individual lot level.
Under Lot Numbered Costing:
- Each lot carries its own distinct cost.
- Fulfillments and COGS calculations can reference the specific lot issued during fulfillment.
- The adjusted replacement lot with the special cost can therefore influence downstream commissionable cost calculations.
However, the same process is not reliable when the item uses Average Costing.
With Average Costing:
- Cost is maintained at the item/location level rather than the lot level.
- Creating a new lot with a different cost does not guarantee that future fulfillments, COGS postings, or commission calculations will use that adjusted cost.
- NetSuite recalculates and applies the blended average cost across inventory instead of honoring the specific lot-level adjustment.
As a result:
- The special cost logic may not consistently flow into commissions or profitability reporting when Average Costing is used.
- Lot-specific inventory adjustments are effectively diluted into the overall average inventory valuation.
For rebate or commission processes that rely on preserving a unique cost per inventory segment, Lot Numbered Costing is the more appropriate and reliable costing method.