Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Unclassified data is also referred to as “###” or suspense items. For example, in a Sales database, you might have some sales that were not allocated against a sales rep. When this happens, the classification is missing from the data and the system assigns a “###” reference as the account code.

Image RemovedBudget workbooks based on a Financial database Image Added

All budgets and Database driver tabs include unclassified data by default. Since the 7 June 2022, new budget workbooks based on non-financial databases This data displays in the worksheet under the Suspense row.

In budgets that are based on operational databases, and Database driver tabs also include , you have the option to exclude the unclassified data by default. This data displays in the Main tab under the label "Suspense". Unclassified data does not display for any non-financial budget workbooks or Database clearing (unchecking) the Include ### suspense items… checkbox in the setup screen.

Info

This option is NOT enabled by default for budgets and driver tabs created before

the

7 June 2022

release

; this is to prevent any unexpected changes.

However, you have the option to include. Select

If you want to include the unclassified data, select the checkbox.

The following video demonstrates the use of the Include ### suspense items in the budget checkbox in the workbook setup, as demonstrated in the following video. The video setting and also shows you how to search for ### items in a budget worksheet and determine if these such items are included in a Database driver tab.

Html macro
<div class="wistia_responsive_padding" style="padding:56.25% 0 0 0;position:relative;"><div class="wistia_responsive_wrapper" style="height:100%;left:0;position:absolute;top:0;width:100%;"><iframe src="https://fast.wistia.net/embed/iframe/nlb0g9d8aw?seo=false&videoFoam=true" title="Include unclassified data in the budget Video" allow="autoplay; fullscreen" allowtransparency="true" frameborder="0" scrolling="no" class="wistia_embed" name="wistia_embed" msallowfullscreen width="100%" height="100%"></iframe></div></div>
<script src="https://fast.wistia.net/assets/external/E-v1.js" async></script>

Related pages

  • Edit a budget workbook setup

  • Add a Database driver tab