Error: Myob Exonet – Financial Report Designer 2-5(ME62)

From Sage Intelligence Knowledgebase
Revision as of 06:01, 4 October 2011 by Tyrone (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

SYMPTOMS


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

Budget values for Income and Other Income are being displayed as negative values on the Income Statement.


CAUSE


The budget values are extracted correctly from the database but the switches used to handle sign control in the Report Designer do not allow for handling of actual/budget/prior separately. Therefore the switch is applied to the budget column as well where it is in fact not required.


RESOLUTION/WORKAROUND


Download the latest template being:

Financial Report Designer 2-6 (ME62)


The changes made were as follows:


1.Container: Management Pack Genie 2-2 (ME62) The excel budget expressions have all had the following code included at the end of the existing code:

(IF(OR(PrimaryGrouping="SALES",PrimaryGrouping="OTHER INCOME",PrimaryGrouping="CURRENT LIABILITIES",PrimaryGrouping="NON CURRENT LIABILITIES",PrimaryGrouping="MEMBERS FUNDS EQUITY"),-1,1))

As an example for BUDGET01, the new code would read:


IFERROR(VLOOKUP(Sheet1!ACCOUNTNO,Sheet3!RawData,16,FALSE),0) *(IF(OR(PrimaryGrouping="SALES",PrimaryGrouping="OTHER INCOME",PrimaryGrouping="CURRENT LIABILITIES",PrimaryGrouping="NON CURRENT LIABILITIES",PrimaryGrouping="MEMBERS FUNDS EQUITY"),-1,1))

NB: This container name has been renamed to Financial Reports Designer 2-3 (ME62)


REFERENCES


Financial Report Designer 2-5 (ME62)