Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

VAT calculation in PL>Journals>Invoice Journal

Posted on by 287

Hi there

This week we come across a issue in AX2009

PL>Journals>Invoices> Invoice Journal.

User trying to post the Vendor Payment in Credit column, (till now VAT amount was calculated on net amount when full invoice total amount inserted in credit section of the Journal line), but now the VAT amount field is calculating on full invoice amount.

Can any one please help how to correct this issue. Further if possible let me know is there any chance of finding the culprit user who made the changes.

Thanks in Advance.

Regards

Venkat.

Categories:
  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: VAT calculation in PL>Journals>Invoice Journal

    Hello Venkat,

    Great that you found the solution.

    Would be great if you could mark the solution you found as verified so that other community members can easily find it in case they run into a similar problem.

    Many thanks and best regards,

    Ludwig

  • VENKAT6452 Profile Picture
    VENKAT6452 287 on at
    RE: VAT calculation in PL>Journals>Invoice Journal

    Hi Ludwig

    I could able to find out where the issue is.

    One of the user has done the amendments in the below path:

    VAT setups in GL>setup>VAT>VAT codes>in S code>inquiries>included in the VAT groups ( unticked).

    I changed the setup now and calculation working fine.

    Thanks

    Venkat.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: VAT calculation in PL>Journals>Invoice Journal

    Hello Venkat,

    It seems that you have some trouble with attaching things.

    Probably copy & paste does not work on your PC.

    Maybe try saving your screenshots and then attach it as follows

    1185.pl2.png

    1185.pl2.png

    Best regards,

    Ludwig

  • VENKAT6452 Profile Picture
    VENKAT6452 287 on at
    RE: VAT calculation in PL>Journals>Invoice Journal

    Thanks Ludwig

    Please find the screen shot of Invoice Journal line

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: VAT calculation in PL>Journals>Invoice Journal

    Hello Venkat,

    At the bottom of the text field is a link denominated 'use rich formatting'. This will open a enlarged screen where you have the chance to attach files, screenshot, etc.

    Best regards,

    Ludwig

  • VENKAT6452 Profile Picture
    VENKAT6452 287 on at
    RE: VAT calculation in PL>Journals>Invoice Journal

    Hi Ludwig

    It look OK with the calculated and actual sales tax fields and nothing was manually overwritten & also incl. sales tax parameter is ON.

    I tried to put the screen shots but nothing is getting copied in this reply fields.

    Please advise.

    Regards

    Venkat

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: VAT calculation in PL>Journals>Invoice Journal

    Hi Venkat,

    Can you check your journal and whether there is a difference in the calculated and actual sales tax field to verify that nobody was manually overwriting the calculated sales tax. Can you check in addition whether somebody disabled the amount icl sales tax parameter on the journal posted? Would be great if you could possibly post some screenshots that show the journal line with the wrong tax calculated and the journal settings.

    Ludwig

  • VENKAT6452 Profile Picture
    VENKAT6452 287 on at
    RE: VAT calculation in PL>Journals>Invoice Journal

    Thanks for your email Ludwig

    in Origin: Percentage of net amount

    in Marginal base: Net amount of invoice balance

    Method of calculation: whole amount.

    Same above settings are there for "S" standard rate in TEST system and in LIVE system.

    But its calculating correct VAT amount in TEST but not in LIVE.

    Please advise.

    Regards

    Venkat

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: VAT calculation in PL>Journals>Invoice Journal

    Hello Venkat,

    Please check General Ledger/Setup/Sales tax/ Sales tax codes and then in the calculation tab the setup that is made in the origin, marginal base and method of calculation fields.

    Best regards,

    Ludwig

  • VENKAT6452 Profile Picture
    VENKAT6452 287 on at
    RE: VAT calculation in PL>Journals>Invoice Journal

    Hi Ludwig

    In the Journal name set up "amount inc.VAT is ticked.

    Can you please guide me where to check the sales tax codes.

    Regards

    Venkat

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,339 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,177 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans