web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

VAT Payment not correct

(0) ShareShare
ReportReport
Posted on by 25

Dear Experts,

I was strange about VAT Payment in Ax 2012 R3.

As per the Trial Balance,

VAT Purchase Account: Debit Balance 352108

                                       Credit Balance -6616.86

                                Net Debit Balance 345591.14

VAT Sales Account: Credit Balance:  -485505.04

                                 Debit Balance:    Nil

                            Net Credit Balance: -485505.04

So, As per my knowledge Sales Tax Payment should be 140,013.90 (-485505.04+345591.14)

Expected Voucher details:

Dr VAT Sales Account         : 485505.04

Dr VAT Purchase Account   :     6616.86

Cr VAT Purchase Account   : -352108.00

Cr VAR Settlement Account: -140013.90 (VAT Payment)

But in AX 2012 R3, When VAT Payment is done, System posted 252,132.67 as sales Tax payment. I am strange to this behavior.

Below is the system posted Voucher.

Dr VAT-Sales Account        :480,491.30

Cr VAT Sales Account       :-396,171.18 (This is Posting every month with same amount)

Cr VAT Purchase Account :-336,452.79

Dr VAT Settlement Account: 252,132.67 (VAT Payment)

So, can you please let me know whether my view is correct or how the system posted this amount. 

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: VAT Payment not correct

    Moved to the Dynamics AX community forum

  • Ax 2012 R3 CU9 Profile Picture
    25 on at
    RE: VAT Payment not correct

    Hi Ludwig,

    Today i have updated my observation in the yesterday post (Original Query) with red highlighted line.

    Please help to clear this issue.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: VAT Payment not correct

    Hi,

    Are you on the latest AX2012 R3 version?

    I found a couple of hotfixes on LCS that seem to be related to specific issues with the sales tax payment calculation and posting for older AX2012 versions.

    If you run an older R3 version, have a look at those hotfixes first to identify whether MS already provided a solution to your problem.

    Best regards,

    Ludwig

  • Ax 2012 R3 CU9 Profile Picture
    25 on at
    RE: VAT Payment not correct

    Dear Ludwig,

    Our current version is R3 CU9. It works good till August 2019. It is happening from September 2019 on wards. As it works fine till August 2019, I don't think that it requires Hotfix.

    Here the strange is same amount is crediting to VAT Sales account while sales tax payment process.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: VAT Payment not correct

    Hi,

    If things worked fine till August then there must have been a change.

    Do you know if an update or code modification was made in September?

    Best regards,

    Ludwig

  • Ax 2012 R3 CU9 Profile Picture
    25 on at
    RE: VAT Payment not correct

    No. We didn't change the code.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: VAT Payment not correct

    Good Morning,

    Further above you mentioned that the red highlighted amount always posts every month, which sounds strange.

    I would recommend that you have a technical expert / developer taking a look at this.

    The math behind those calculations is not that difficult :-) as you exemplified above and I believe that there must be a bug or problem in the code.

    Best regards,

    Ludwig

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,933

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 793 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 537 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans