Item Chage / COGS Breakdown in Dynamics

We’re currently utilizing the Lot# and Item Charge features in Dynamics. Our goal is to get the detail of the COGS. Identifying the Material Cost and the costs associated with each Item Charge.

Is there a way to achieve this detailed breakdown in Dynamics? I considered using Dimensions, but I’ve hit a roadblock. I would appreciate any suggestions or ideas on how to approach this.

Have you looked into the Value Entries table? This is where the direct material cost and the item charges are posted for the inbound entry. Unfortunately, the item charge itself does not flow to the outbound entry where it is identified as an item charge. You would need to drill back to the related inbound value entries.