We have three types of inventory:

1 - Stocked Items: These get shipped from overseas in bulk, and are sold across multiple SO's

2- JIT Items: These are PO's that are raised specifically for the source SO

3 - Manufactured Items: These are manufactured using part stocked items/part JIT & subcontracted items (upholstered component valued at original value + PO value)

These components get sold as end products via KIT's (list of components sent out in a box, presented as one item), Manufactured products (transforming components into single item), and just as themselves when it's an end product brought straight from our suppliers.

We want to be able to trace the cost released back to the origin PO / IN Transfer so that we can see how the costs go from beginning to end.

In my head, the best report for this should be in the stock valuation layer, as it'll show all the components either going into the MO that is then released to the P&L, it'll show the components going out with the KIT, and it will also show the individual components going out unmodified.

Could someone help me put together a report template that would give me the information I need, the main field I'm desperate for is the link between the OUT transfer and the original IN transfer it's pulling the stock from, per component.