08.08 Accounts with No Actuals

08.08 Accounts with No Actuals

Planning reports build their rows from data that already exists: either actuals from the ERP or previously submitted plan figures. If an account, cost centre, or project has never had any transactions and has no prior plan figures, there will be no row in the report for it — and submission is not possible against a row that cannot be seen.

This is a common situation, particularly when planning new activities or cost centres that have not yet been used in the ERP.

Here is a video, or read below.

The solution: Add Missing Planning Rows

This feature is available in both Designer and the Excel Add-In:

Both open the same Add Missing Planning Rows dialog.

image

Using the dialog

  1. In the filter row, enter the account code for the row to be added. For example, type 4060 in the Account filter.

  2. If your report has multiple down-axis dimensions (which won't be the case for Account level planning), a filter field appears for each dimension. Every field must be filled with a single valid value.

  3. To add multiple rows at once, click Add Row as many times as needed and fill in each line.

  4. For large lists, use the Excel Template shortcut: click Excel Template to generate a workbook with the correct column layout. Fill in your account codes. Copy the range and click Paste from Excel to import all rows at once.

Formatting cells as text, or using a leading apostrophe on numeric codes, will prevent Excel converting codes such as 004 which might be a cost center coding to a 4 which is no longer a code recognised by your ERP.

  1. Click OK. FastClose validates each combination and, if valid, re-runs the report with the new empty rows visible and ready for data entry.

Hide Rows Without Values: If this setting is active on your report, FastClose will automatically turn it off when missing rows are added — otherwise the new empty rows would disappear immediately. You can re-enable the setting once you have submitted values to those rows.

Exercises

Now try the downloadable exercises below:

08.08 Planning Accounts with no Actuals - Exercises.pdf

Your feedback helps us do better, to fill in a short survey on this tutorial, click here.

Move on to 0809 - Reporting on the Plan

Powered By