General Journal - Test (2): Wrong Amount

knm

I'm running NAV 2009 R2 RTC, and have question about how "General Journal - Test Report" calcualtetes the value for total of AmountLCY.

When there is an entry of separate Journal Entries of Account No. and Balance Account No., then the report will calculate the correct Total Amount, BUT, when the entry is made within a single line (i.e. using the Balance Account No.) the Total Amount is not calculated properly.

For example, if I have the entry of Line Entry with $100.00, then the report will calculate the SUM of AmountLCY as $200.00 instead of showing $100.00. And I think this is supposed to be $100.00.
Or am I missing some basics here?

Please let me know.

Kenji

mohana_cse06

I hope, this can help you
http://www.mibuso.com/forum/viewtopic.php?f=32&t=46012&hilit=general+journal+test+report

knm

Thank you for the response.

I've reviewed the post before and it seems to be an issue related to "showing dimension" where as my issue is related to using the Balance Account No. or not.

Nonetheless, I tried the code mentioned in the post, but it didn't change my result whatsoever.

Please let me know if there are any other solutions available.

Thank you.

Kenji

knm

Nobody experienced this issue before?
Just curious, because I'm getting this issue on my fresh Demo install of NAV 2009 R2.

Andy_Smith

I'm getting this same result. Were you ever able to resolve this issue?

knm

I ended up contacting MS about this issue and they confirmed that this was a bug on the report coding (specific to RTC).
I can't recall for sure, but the fix that they have provided is to update the "DimensionLoop" and "ErrorLoop", so that following balances are reset in OnPreDataItem(), just for RTC.

So something like.

IF ISSERVICETIER THEN BEGIN
AmountLCY := 0;
BalanceLCY := 0;
DrAmt := 0;
CrAmt := 0;
END;

Since I couldn't find a page for Application Hotfix, I'd strongly recommend you contact MS about this.