Example

You are the manager of the financial department and want to plan the payables for the coming fiscal year at period level. To plan the payables, you start the query and specify in the selection screen for the following selection criteria the values for which you want to plan the balances:

Once you have confirmed the selection criteria, a table is displayed with columns for the G/L accounts, the actual values for the balance carryforward of the previous year, the actual values of the previous year, the cumulative values of the previous year, the planned values of the balance carryforward of the coming financial year, the planned values of the coming year, the cumulative values of the coming year, and the differences. There is a column in the query for periods 1-12 for the year selected for both the actual and planned values. The cumulative values are calculated by adding the balance carryforward and the values for the periods. The fields in the plan columns are ready for input with the exception of the cumulative planned value. You can enter there your planned balances for the periods in the row for the corresponding G/L account.