Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Invoice journal do not post VAT

Posted on by 1,351

Hi,

I have a problem with supplier invoice which is not posting VAT. There are other invoices posted against the same vendor, with the same information entered in the voucher and in one of them, of the many booked, just one is not posting VAT. I don't know what can be different in this invoice than in the others. Any ideas?? I'm in AX 2012 R3.

This is the screenshot for the correct VAT postings:

pastedimage1578588473062v1.png Even if they are at zero, which is correct, we still get lines generated in posted VAT, thus the transaction is included in the VAT reports.

pastedimage1578588511606v2.png Same vendor, same information entered on the invoice, no posted VAT.

Any ideas of where could I look to see what went wrong into the second screenshot?

Thanks!

  • CapsLock Profile Picture
    CapsLock 1,351 on at
    RE: Invoice journal do not post VAT

    Thanks for showing me the path in LCS.

    I can't replicate the issue. I've tried many times in a test environment and it's working just fine. I'm going to conclude that it was a glitch in the system and keep an eye in case it happens again.

    Thank you very much again to you all for you very valuable input.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Invoice journal do not post VAT

    Hi CapsLock,

    I tried this link and entered some search terms but did not find anything:

    fix.lcs.dynamics.com/.../Results

    Do you have a developer around or can you alternatively open a support case with MS (provided that the issue can be replicated)?

    Best regards,

    Ludwig

  • CapsLock Profile Picture
    CapsLock 1,351 on at
    RE: Invoice journal do not post VAT

    Hello Ludwig,

    It's AX 2012 R3. Do you have the menu path in LCS to check this kind of things? I've tried different options from the screenshot you see below but it all seems related to the customer that I've hidden with the white box.  Do you think that it may also be a glitch in the system? A one-off error??

    pastedimage1579606118072v1.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Invoice journal do not post VAT

    Hello CapsLock,

    What AX2012 version do you operate?

    Did you already check on LCS that there is no bug reported for this issue?

    Are you able to replicate this issue or was this only a one-time/random problem?

    Best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: Invoice journal do not post VAT

    Hi CapsLock,

    It is indeed a strange issue. If you have multiple transactions with this issue, try to see if you can find something similar. E.g. all on a certain date, the user who created/posted the transaction, etc. Then you might come closer to the culprit. I do agree that it would be very unlikely that someone is changing the setup on unexpected moments.

  • CapsLock Profile Picture
    CapsLock 1,351 on at
    RE: Invoice journal do not post VAT

    Hi,

    I tried to give the tax code a date range:

    pastedimage1578909820446v1.png

    And then posting a trasaction within that date range:

    pastedimage1578910345068v3.png It's ok

    And another transaction outside of the date range:

    pastedimage1578910164385v2.pngNo VAT transactions like in the one we are investigating.

    Even though we know that if we use the VAT code outside the date range the invoice still posts with no warning messages and no posted VAT, it seems a very unlikely explanation that someone had informed the date range, post an invoice outside it, and then delete the date range again. There has to be a different explanation for the case we are seeing?

  • CapsLock Profile Picture
    CapsLock 1,351 on at
    RE: Invoice journal do not post VAT

    Hi Andre. All transactions, the ones that generate VAT lines and the ones that do not, have the same combination:

    pastedimage1578907809508v1.png

    The resultant VAT code is included in both the VAT group DOM and item VAT group ZER-SRV.

  • CapsLock Profile Picture
    CapsLock 1,351 on at
    RE: Invoice journal do not post VAT

    No, in other invoice journals that use the same tax group and item tax group combination, also with a result of 0%, VAT lines with 0 amount are still created and the invoice shows in the tax reports as part of the total purchases even if exempt. Example:

    pastedimage1578907285477v1.png Even if zero a line for VAT is still generated.

    The transaction we are investigating, has the same resulting VAT code as the invoice above, per this combination:

    pastedimage1578907508192v2.png This is an screenshot from the journal lines, the lines have been posted with VAT group and item group. And still the VAT lines have not been generated:

    pastedimage1578907621254v3.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Invoice journal do not post VAT

    Hi CapsLock,

    Can you enter a from and to date in the sales tax value form and then try to post an identical transaction.

    As Andre mentioned we should get a tax trans transaction then.

    (It should actually work even without the from and to dates but not if you operate a very old AX2012 version).

    Best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: Invoice journal do not post VAT

    Hi CapsLock,

    Are both the Tax group and Tax Item group linked to your Sales tax code? If there is a zero percentage, it should still generate a sales tax transaction for reporting purposes. Where it is working, are you using the same tax groups or others?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans