Account number not formatted correctly in all data sheets where account number is used

From Sage Intelligence Knowledgebase
Jump to: navigation, search

Products

Sage 50—Canadian Edition

Sage 50—U.S. Edition

Sage 100 Contractor

Sage 100

Sage 300

Sage Intelligence

Sage 500 ERP


Description

Account numbers not showing correctly in all hidden data sheets causing formulas to result in no amount


Account number format 1-.PNG


Cause

Excel is cutting off leading zeros or changing the number into a date.


Account number format 2-.PNG


Resolution

Follow the steps to resolve the issue;


1. Open Report Manager

2. Right click on the report in question and select design. This will open the template in design mode

3. Un-hide all hidden data sheets

4. Change the column format for account number to Text in each sheet

5. Save and close the template


Category

Reports


Entitlement

Sage 100 Contractor

Sage 100

Sage 300

Sage 500 ERP

Sage 50—Canadian Edition

Sage 50—U.S. Edition

Sage Intelligence


Sage KB ID

67025