Sage intelligence object reference not set to an instance of an object

SOLVED

Need assistance with our MAS Intelligence Report Designer reports all the sudden having the error “Object reference not set to an instance of an object.”?    Has anyone else started getting these recently?

Our report templates use a lot of single account numbers in the formulas so when I make those a range “xxxxx to xxxxx” they work.  I've checked to make sure we don't have any GL accounts with currency restriction codes other than 0,  that we don't have any Natural accounts without an actual GL account and no updates or changes have been applied to Windows or Excel.

Parents
  • +1
    verified answer

    Error: 'Object reference not set to an instance of an object' on the Report Designer Add-in report

    Created on 06 July 2021 | Last modified on 06 July 2021 Highlight Matches

    •  
    •  
    •  

    Cause

    A natural account number with no associated segmented accounts exists within the chart of accounts.

    Resolution

    1. Open the Excel sheet generated by Sage Intelligence
    2. Un-hide the Accounts sheet.
    3. Perform a search for a blank Segmented Account Number on the spreadsheet.
    4. Delete the Natural Account Number from Sage 500, General Ledger, Maintenance, Maintain GL Accounts, Maintain Natural Accounts.
    5. Repeat the process for additional blank Segmented Account Numbers.
Reply
  • +1
    verified answer

    Error: 'Object reference not set to an instance of an object' on the Report Designer Add-in report

    Created on 06 July 2021 | Last modified on 06 July 2021 Highlight Matches

    •  
    •  
    •  

    Cause

    A natural account number with no associated segmented accounts exists within the chart of accounts.

    Resolution

    1. Open the Excel sheet generated by Sage Intelligence
    2. Un-hide the Accounts sheet.
    3. Perform a search for a blank Segmented Account Number on the spreadsheet.
    4. Delete the Natural Account Number from Sage 500, General Ledger, Maintenance, Maintain GL Accounts, Maintain Natural Accounts.
    5. Repeat the process for additional blank Segmented Account Numbers.
Children
No Data