Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Taxes invoice journals

Posted on by 115

Hello,

I am doing an invoice journal, I capture the first invoice with its id and its taxes, I'm going to call it F1 for example with an amount of $100 and taxes of $16.

Secondly, I capture another invoice F2 with an amount of $200, and taxes of $32.

Finally I capture the third invoice, this is a tip that belongs to invoice one (F1), but it has a different account and  it doesn't have taxes, so I capture again F1 with an amount of $30 without taxes $0.

The total of this taxes it should be $48, but if I consult totals I get $64, aparently it is duplicating the taxes of F1 captured in first line.

If I consult the entry before I register the journal, the amount of the taxes is correct, if I register the journal and after that I review the entry is correct too, the problem is that when user consult totals apparently the calculation is wrong, so user is afreid of register the journal due to a bad tax calculation.

Does anyone has a similar problem? Any help?

  • Jorge Btc Profile Picture
    Jorge Btc 115 on at
    RE: Taxes invoice journals

    Thank you so much Ludwig.

    Best regards.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Taxes invoice journals

    Hi Jorge Betancourt,

    So, it is a display issue. That somehow a good news as the postings are ok.

    I checked on LCS but have not found a hotfix that matches exactly your issue.

    Having said that I blieve that you have two options to go forward.

    The first (and probably fastest) option is to grab a developer who helps you getting this fixed in the code.

    The second option is to open a MS support request and ask MS to fix it for you and all other AX users through a hotfix.

    The alternative would be to live with the issue but - as you mentioned - this does not seem to be an option for he users.

    Best regards,

    Ludwig

  • Jorge Btc Profile Picture
    Jorge Btc 115 on at
    RE: Taxes invoice journals

    Hi Ludwig,

    The user does this in order to identify each line with its voucher because we have a lot of vouchers in this journal.

    We have Microsoft Dynamics AX 2012 R3 CU9. I don't know if there is a hotfix to this issue.

    I already posted the journal in a test system and the entry is correct, apparently it is just the view, but this is confused to the user.

    Best regards.

    PJ.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Taxes invoice journals

    Hi Jorge Betancourt,

    I actually run into a similar issue than the one you describe above when I enter the invoice ID in all lines.

    However, after updating all dates - that is re-entering the date value it disappeared.

    By the way, why do you enter the invoice ID in all lines?

    You actually need it only in the line where you specify your vendor.

    What AX version do you run AX2012 R2/3 CU8/9/...?

    Have you already checked LCS for an available hotfix?

    ... and, what is more important, have you tried posting the voucher in a test/demo System?

    Best regards,

    Ludwig

  • Jorge Btc Profile Picture
    Jorge Btc 115 on at
    RE: Taxes invoice journals

    Hello Ludwig Reinhard,

    I already did that, I have the same configuration as you mentioned.

    0044.Example2.PNG

    I did the example again as yours, and I get the correct taxes calculation, I think this is because you didn't put the ID of the invoice. 

    0044.Example2.PNG

    This is the same example with id's, you can see how the amount of taxes calculation is different than the first one.

    Example3.PNG

    Please capture the same ID to your second and fourth line, and another ID to third line and check again.

    Would be great if you could check this and let me know.

    Thanks.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Taxes invoice journals

    Hello Jorge Btc,

    I tried to replicate your issue in a demo machine and was able to get things right.

    7823.tax.png

    Can you check your tax Setup?

    I believe that there must be something wrong with the calculation parameters setup in your tax codes.

    5460.tax2.png

    Would be great if you could check this and let us know.

    Many thanks,

    Ludwig

  • Jorge Btc Profile Picture
    Jorge Btc 115 on at
    RE: Taxes invoice journals

    Yes, first line includes sales tax Group & item sales tax Group but this is correct, and the calculation of taxes of this line is correct as you can see in the picture.

    If I remove  the item sales tax group and tax group for my third line the amount in totals is the same, it doesn't change. Only if I change de amount in first line the total tax amount changes but it is calculating wrong again.

    If I change the order of lines, I capture second line (F2), then first line (F1), and finally  third line (tip of F1) the taxes calculating is right.

    7318.TC.png

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Taxes invoice journals

    Hello Jorge Btc,

    Does the first line in your journal include a sales tax Group & item sales tax Group?

    If so, can you try to remove it?

    Can you also test if the total tax amount changes if you completely remove the item sales tax group and tax group for your third line?

    It seems that the total tax amount is not correctly updated. Yet, would be great if you could test whether the removal of the tax/item tax Groups changes anything.

    Many thanks,

    Ludwig

  • Jorge Btc Profile Picture
    Jorge Btc 115 on at
    RE: Taxes invoice journals

    Hi Ludwig,

    I already  removed the sales tax group, apparently It doesn't  calculate anything but if I consult totals I have a different amount.

    I added some pictures about the example.

  • Jorge Btc Profile Picture
    Jorge Btc 115 on at
    RE: Taxes invoice journals

    F1

    TOTALS.png

    F2.

    3386.F2.png

    F1 Without taxes

    F1WT.png

    Totals.

    TOTALS.png

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,632 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,528 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans