I’m working on an Acumatica-based solution (via a vertical solution provider) for a fuels distribution business and am looking for guidance on how others are handling Weighted Average Cost (WAC) in scenarios where the true cost of inventory goes beyond just the base purchase price.
Business Context:
In our current system, WAC represents full landed cost, including:
- Supplier invoice cost (fuel)
- Vendor-charged taxes and regulatory fees
- Internal freight (marine, line haul, inter-terminal transfers)
- Allocations applied as fuel moves through the supply chain
This cost structure is critical for:
- Inventory valuation
- Margin reporting
- Financial/audit alignment
Challenge in Acumatica:
From what we’ve seen so far, WAC appears to only reflect the base item cost at receipt, and additional costs (freight, taxes, etc.) are not automatically incorporated into the inventory cost in a way that recalculates WAC.
Questions:
1. How are others incorporating additional landed costs (freight, fees, taxes) into WAC within Acumatica?
2. Are you using any of the following patterns:
- Landed cost transactions
- Allocation or adjustment entries
- Customizations or extensions
- External calculations (with re-import into inventory)
3. If landed costs are used:
- Are they applied at receipt only, or can they be applied during internal transfers as well?
4. How are you ensuring inventory valuation aligns with your GL without introducing manual adjustments?
5. Has anyone in fuel, energy, or multi-leg supply chains (where inventory moves several times before sale) solved this in a scalable way?
Goal:
We’re trying to determine whether:
- This can be handled natively,
- Requires a design pattern/workaround, or
- Needs a different approach to costing and reporting.
Any examples, patterns, or lessons learned would be extremely helpful.
