General Journal - Test (2): Wrong Amount

knm
knm Member Posts: 170
edited 2012-10-25 in NAV Three Tier
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

Comments

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

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • knm
    knm Member Posts: 170
    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
    knm Member Posts: 170
    Nobody experienced this issue before?
    Just curious, because I'm getting this issue on my fresh Demo install of NAV 2009 R2.
  • Andy_Smith
    Andy_Smith Member Posts: 31
    I'm getting this same result. Were you ever able to resolve this issue?
  • knm
    knm Member Posts: 170
    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.

Categories