Is there a way using BAQ or other tools to provide cost of goods sold by supplier for entire year? The transactions related to MFG-CUS move WIP costs to COGS, it loose detail in COGS GL account. As the volumes are huge, it’s not feasible to do manual lookup.
An example cost transaction
PUR-MTL Jan 1 - 100 (put into WIP)
PUR-MTL Feb 1 - 200 (put into WIP)
PUR-MTL Mar 3 - 50 (put into WIP)
MFG-CUS Mar 15 - 350 (total costs of the job and move from WIP to COGS)
By looking up MFG-CUS, extract details prior transactions, by project, job and supplier.
Similarly, after customer shipment, there is late costs come in after, how to extract details?
PUR-MTL Apr 1 - 30
ADJ-PUR Apr 15 - 5
MFG-VAR - 35
I’m inclining to use PartTran as start.