You have the option to include unclassified data, 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.
By default, this unclassified data does not display in your budget workbook. However, you can include it. Select the Include ### suspense items in the budget checkbox in the workbook setup, as demonstrated in the following video. The video also shows 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> |