Distributing schedule details

  1. Select Data Transfer and Processes > Entity Data Transfer > Trial Balance > Data Entry Schedule Detail Distribution.
  2. Specify the context.
    The currency and level are specified automatically and cannot be changed. You can select main schedules when distributing schedule details.
  3. In the Difference to distribute column, the differences are highlighted with a Warning icon. To distribute the difference, specify the required amounts in the appropriate schedule detail columns until the difference is distributed completely and the warning icon changes to the Success icon.
    Note: 
    • If an account has intercompany information, you cannot specify any amounts in the main grid. Click the Folder icon that is displayed next to the account and distribute the differences by specifying the required amounts in the appropriate schedule detail columns for intercompanies.
    • The decimals are rounded up or down. You are not required to distribute the difference amount's decimals.
    • To delete a specified value from the database, press Ctrl + Del or specify #delete in an appropriate cell in a schedule detail column.
    For the TDETAIC (FinCon Entity Schedules) and TSEGMOVC (FinCon Entity Segments with Schedules) cubes, a cube rule named Translation Adjustment for detail to distribute is available. For each *_NA (*Difference to distribute) detail, the target: 
    [BPDCYCLE: 'SET_001', DCLEVEL: 'HB I', DDATA: 'Translation Adjustment', DDETAIL: '*_NA']
    is equal to the negative of the formula: 
    [DDATA: 'Translation Adjustment', DCLEVEL: 'HB I Manual Detail Distribution', DDETAIL: '*_CB']

    * can be replaced with A (Assets), B (Receivables), C (Payables), D (Accruals), or E (Equity).

  4. If the Immediate Writeback option is enabled, the schedule detail distribution is saved automatically. If the Immediate Writeback option is disabled, click Save.
  5. Return to the Landing Page.
  6. On the Entity tab, click the Check icon on the Trial Balance card and select Check Summary to verify if all the steps related to the distribution of schedule details are complete.
    Note: To have checks only for specific versions or periods, or both, you must create customized checks with limitations to specific versions or periods, or both.

    In case you require schedule details only for closing the year, we recommend these workarounds:

    • During the year, in Business Modeling, disable the standard checks regarding, for example, versions, periods, or entities.
    • Keep the standard checks always disabled and create customized checks with rules that use only period 12 in the target area.
Related topics