Rules

• Both periodic and year-to-date balance sheet data always reflect the periodic values stored in the database, with the exception of opening balance lines.
• Periodic profit/loss values always reflect the periodic values stored in the database. Year-to-date profit/loss values reflect the results of the conversion of the local reported periodic values in the database.
• If you save or submit a change to a year-to-date profit/loss value, one or more periodic values is automatically adjusted when the view is refreshed, even if those cells are locked for writeback in the view. If one or more of the affected periodic values are locked because they are outside the focus range, then the corresponding year-to-date value is adjusted instead (see the next section for examples of both scenarios).
• A reporting view only displays the year-to-date values that were generated by a consolidation (for both profit and loss and balance sheet data).
• Year-to-date values generated by a consolidation are never written to the opening period (P0). Only Start New Year populates P0 with year-to-date values.
• When the data is submitted, any empty cells are written to the database as null values. After the grid refreshes:
  • Null values in leading periods display as zeros in the year-to-date view and empty cells in the periodic view.
  • Null values in intermediate periods are treated as zeros during calculations. They display as year-to-date values in the year-to-date view and empty cells in the periodic view.
  • Null values in trailing periods display as empty cells.
• When period and year are on-grid dimensions in a data entry year-to-date view, any empty cells between periods with data are automatically populated with year-to-date data when the grid is refreshed. Empty cells that precede the first active period are populated with zeroes.