Versions Compared

Key

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

You have the option to include unclassified data, Unclassified data is also referred to as “###” or suspense items, in your budget workbook. 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 RemovedBy default, this unclassified data does not display in your budget workbook. However, you can include it. Select Image Added

All budgets and Database driver tabs include unclassified data by default. This data displays in the worksheet under the Suspense row.

In budgets that are based on operational databases, and Database driver tabs, you have the option to exclude the unclassified data by 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 7 June 2022; this is to prevent any unexpected changes. 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 setting and also shows you how to search for ### items in a budget worksheet and determine if 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