Enter Data
The data as shown in the T-Accounting needs to be entered into the system. Of course the end goal is to have a systematic extraction of data from the ECC system to BPC for any transactional data in the format required. Here we have several basic requirements for the input of data. Again input of data can also be accomplished by automation processes. This tips document shows all data entered through input templates.
In this first input template we add all the intercompany transaction data in Local Currency and show the end results in EUR. C1000 is a EUR currency entity and C2000 is a British Pound entity.
Figure 7. The initial Intercompany Input Template and data in EUR
Next we enter data for the external sales from C2000 to external customers in Local Currency and show the results in EUR. Here notice the intercompany member is I_NONE indicating this is not an intercompany transaction. There is no elimination for this set of numbers.
Figure 8. Input Template for Non Intercompany External Sales in EUR
The thinking difficulty begins with the intercompany inventory process. To begin, a solid design of the ECC financials system should accommodate in some way the idea of intercompany inventory. Here, however, notice that we must use the FLOW dimension to segregate various values that we will use in our profit in inventory elimination adjustments at month end. In this graphic is shown the amount of cumulative inventory transferred to the buyer company by the intercompany sale and the ending balance of inventory using the FLOW dimension. The data here can be loaded from the primary financial application using a proper design.
Figure 9. Input Template for Intercompany Inventory with Flow in EUR
Figure 10. All Data with All Interco/I_NONE and Flow in EUR
No comments:
Post a Comment