Does anyone know of a report that will give me the COGS of an item that will show me the Item Charges assigned along with the material cost ? We assign landed costs in the Item Charge assignment that gets added to the unit cost. We want to know those charges that are included in the inventory valuation at any given time as well as those item charges that are included in the unit cost of items sold in any given month (or time period).
Ben,
There is no standard report that will accomplish this. You could use Jet Reports to read the Value Entries and capture the Direct Cost and Charge(Item) cost. You can always validate that your Charge(Item) is included in the Unit Cost by looking at the Value Entries for the Posted Purchase Invoice .
Hope this helps.
Thanks,
Steve
Ben,
I have similar challenge what did you did at the end?