Defining Control Tables for Intercompany Profit - the Advanced Tab

You can use this tab to define advanced settings for reconciling intercompany profit.

You can define whether the reconciliation/elimination is calculated on a specific closing version. If you do not select anything, the reconciliation and elimination is calculated on every separate journal type and reported value (REPO).

You are also able to choose if the automatic elimination of internal profit itself is posted on a specific journal type. If you do not select anything, the posting is made on the original journal types, where the values are reported.

You can run the reconciliation on a counter dimension. This option is only valid for dimension 1 and has to be defined in the dimension structure. If you use counter dimensions, you can also define whether an adjustment dimension must be used for posting of the calculated internal profit. The posting takes place on the original dimension code if there is a total matching. This option is only valid for dimension 1 and the adjustment dimension must be defined in the dimension structure on each level.

Procedure

  1. After you save your selections on the Standard tab, click the Advanced tab.

    The same journal number as on the Standard tab is displayed automatically. The journal number is also the report number when you run the reconciliation report.

  2. Select a Closing Version that you want to eliminate on. If you leave this field blank, the elimination is performed by each separate journal type. If you enter a closing version here, it is used as default when the reconciliation and elimination is performed.
  3. Select a Journal Type that you want the elimination to be posted to when the journal type is different than the original journal type where the reported value is stored.
  4. Select Use Counter Dimension only to run the reconciliation of intercompany profits on counter dimensions without using adjustment dimensions. This reconciliation is only valid for dimension 1 and has to be defined in the account structure.
  5. Select Use Adjustment Dimension only if you want eliminations between dimensions to be automatically booked in an adjustment dimension if there is no extended dimension 1 code match. This is only valid for dimension 1 and has to be defined in the account structure. Note that adjustment dimensions must have been defined before using this functionality.
  6. Select both Use Counter Dimension and Use Adjustment Dimension to run the reconciliation of intercompany profits on counter dimensions in combination with using Adjustment Dimensions. This reconciliation is only valid for dimension 1 and has to be defined in the account structure. Eliminations and differences are only posted to the original dimension if the sales account dimension belongs to the same dimension group as the inventory account dimension. This reconciliation is only valid for dimension 1 and the adjustment dimension must be defined in the dimension structure on each dimension level in the data entry form. For more information, see Define Extended Dimension Structures - the Reorder Tab.
  7. Click Save.