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.
Budget workbooks based on a Financial database include unclassified data by default. This data displays in the Main tab 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 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 the Include ### suspense items in the budget setting in the workbook setup 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 and driver tabs created before 7 June 2022; this is to prevent any unexpected changes. If you want to include the unclassified items, 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.