Error: ACCPAC – Management Pack Templates

From Sage Intelligence Knowledgebase
Jump to: navigation, search

Error: ACCPAC – Management Pack Templates

Symptoms

The following are examples of error messages that may occur:


  • Management Pack does not balance on data using foreign currency
  • Dashboards does not balance on data using foreign currency


Cause

This error occurs due to the fact that the original template did not include logic to deal with datasets containing Local and foreign currency data. The fix is to place an additional filter into all expressions referencing currency fields (i.e. [GLAFS].[NETPERD*] in all the Actual, Budget, last year and YTD related expressions)


Resolution/Workaround

Expressions - ACTUAL01


CASE WHEN [GLAFS].[FSCSDSG]='A' AND [GLAFS].[FSCSYR]='@GLYEAR@' THEN [GLAFS].[NETPERD1] ELSE 0 END

Needs to be changed to

CASE WHEN [GLAFS].[FSCSDSG]='A' AND [GLAFS].[CURNTYPE] = 'F' AND [GLAFS].[FSCSYR]='@GLYEAR@' THEN [GLAFS].[NETPERD1] ELSE 0 END


This will ensure that only the functional currency data is extracted


Applies to

  • ACCPAC 5.3
  • ACCPAC 5.4