My aim here is to have a report that our internal product managers can monitor their respective suppliers and check Margin from the Income account Vs the COGS account.
E.g Entegris 40060 Vs 50060 for each inventory item in a 3 month period.
Rows of :
• inventory Items
Columns showing:
• Income account
• COGS Account
• % margin Income vs COGS
• Subsidiary sold in
Can somebody help please