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. This data displays in the Main tab worksheet under the label "Suspense". Since the 7 June 2022 release, you have the option to include unclassified data in budget workbooks based on non-financial row.

In budgets that are based on operational databases, and Database driver tabs. The unclassified data displays in the applicable tab under the label "###". The inclusion of the unclassified data in those workbooks and tabs is controlled by , you have the option to exclude the unclassified data by clearing (unchecking) the Include ### suspense items items… checkbox in the budget setting in the workbook setup and driver setup, and and by default:

  • This setting is enabled (checkbox is selected) for those workbooks and driver tabs created after 7 June 2022. If you do not want to include the unclassified items, clear the checkbox.

  • This setting is NOT enabled for those workbooks

    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 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