Error: Sage MAS90 – Financial Trend Analysis 2-0 (MAS) Report Financial Trend Analysis 2-0 (MAS) the Date Lookup worksheet is displaying the incorrect years - 1900 & 1899

From Sage Intelligence Knowledgebase
Jump to: navigation, search

SYMPTOMS

The following is an example of an error that may occur:

  • The report does not display the correct year details.

CAUSE

The excel formula to return the current year is referencing the incorrect column on Sheet1

RESOLUTION/WORKAROUND

Download the latest template being:

  • Financial Reports 2-1 (MAS)

The changes made were as follows:

Amended the formulae in the “Year” column on the Date_Lup sheet to reference the correct column in Sheet1

APPLIES TO

  • Financial Trend Analysis 2-0 (MAS)