Data Entry

Select Data Transfer and Processes > Entity Data Transfer > Trial Balance > Data Entry.

The Data Entry page has these tabs:

  • Income Statement
  • Assets
  • Liabilities
  • Add Intercompany

On the Income Statement, Assets, and Liabilities tabs, you can specify values for specific accounts in the Data Entry Manual column. If an account has intercompanies or schedule details, or both, you must click the details icon in a row with an account and specify the values for intercompanies or schedule details, or both.

Note: If an intercompany is the same as an entity, the values for this entity-intercompany relation are displayed only if they have been imported. If no data has been imported, you cannot specify values manually for this entity-intercompany relation.
Note: Specifying values for rule-calculated accounts and *_FX_Subgroup schedule details is disabled to maintain data integrity and prevent data inconsistencies, especially during OLAP synchronization. To identify *_FX_Subgroup schedule details, use the Group to Entity Detail (Business Modeling property) or G2C_* (DDETAIL OLAP property). Schedule details that are selected as Group to Entity Detail or G2C_* have Write access disabled. These rule-calculated accounts are available:
  • L110520: Profit (Loss) for the Period or Balance Sheet Profit/Loss
  • L110310: FXDiff Balance
  • L110320: FXDiff GuV
  • L110511: Carry Forward Entity, Carry Forward Group, Retained Earnings - Profit, or Retained Earnings - Loss

You can enable or disable immediate writeback of values to the database. Writeback is enabled by default and, when enabled, is indicated with a blue check mark. To disable writeback on the Income Statement, Assets, and Liabilities tabs, click Data > Immediate Writeback. If you disable writeback, the Save button is displayed in the toolbar to enable you to save the report to the database manually. When writeback is disabled and you click another tab or try to leave the report without saving it, you are warned with an appropriate notification.

Note: To delete a specified value from the database, press Ctrl + Del or specify #delete in an appropriate cell in the Data Entry Manual column.

On the Add Intercompany tab, you can select intercompanies for which to assign relations with the entity that you specified in the context pane.

You can specify data on the Data Entry page only if the page has a status of Open. Otherwise, the Data Entry report is read-only.

If the use of segments is enabled for an account, then data is written to the Unassigned element in segment dimensions. If the account uses only segment information, then data is written to the TSEGMC cube. If the account uses segment information and schedule information, then data is written to the TSEGMOVC cube.