[sap-log-mm] Intercompany Inventory Value Tracking

Posted by Sap Land Thursday, 19 May 2011 06:21

Posted by Sean_XJ
on May 19 at 9:26 AM

Hello Experts,

Our client has two company one in USA and one in Canada, when there are goods moved between USA Company and Canadian Company they will use general Purchase/Sales Goods Issue/Goods Receipt and Billing/Invoice process, not using the SAP standard STO due to the legal limitation can not STO cross the board.

The scenario is they want to track back the Inventory Value which is the Value of the shipping COGS of the Sending Company for example :

1, Sending Company A shipping Material M0001 to the Receiving Company 100 LBS @0.5$ (MAP of Sending Company)
2, Receiving Company B Goods Receipt M0001, 100 LBS, Although MAP of M0001 on Company B could be @0.6$, they want to Track the Intercomany Value of M0001 as 100@0.5 => 50

The reason to track the original Intercompany Value is to recognize the remain inventory under receiving company and to make the adjustment for manual consolidation. (We are not using any consolidation module)

The issue is when there are STO among the Receiving Company Plants, it is hard to tranck the original IC Unit Price and Value because there are could be the External purchase of receiving company of the same Material.

Is there any one who had the same scenario of above and what could be the solution for it ? Any suggestion is welcome.

The system is ECC5.0, SD/MM/FI/CO, no consolidation module implemented.

XJ

__.____._