In non-financial budget workbooks and Database driver tabs, you have the option to include unclassified data, 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.
By default, this unclassified data displays in new budget workbooks created after this feature was released on 7 June 2022. The unclassified Budget workbooks based on a Financial database include unclassified data by default. Since the 7 June 2022, new budget workbooks based on non-financial databases and Database driver tabs also include 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 driver tabs created before this feature was releasedthe 7 June 2022 release; this is to prevent any unexpected changes to a budget. However, you can include it in those existing workbookshave the option to include. Select the Include ### suspense items in the budget checkbox in the workbook setup, as demonstrated in the following video. The video also shows you how to search for ### items in a budget worksheet and determine if these 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> |