You’re offline. This is a read only version of the page.
Announcements
5
Hello,
I am trying to understand the behaviour of posted TAX in AX 2012 R3 RTM. Is there any papers that explain the difference between tax posting between general invoice on a purchase order or doing it through invoice register (which is how we do it).
Our Financial Controller, when investigating tax in the system using the "Posted Tax" form, thinks the way the system is doing it is wrong, because the purchase order should not enter the equation and that it should just be the invoice and voucher, so I wanted to explain to them what is going on.
Is this balancing out the purchase order and purchase invoice and then posting it to the voucher?
If you do a invoice on the purchase order without any register you get it like this (not the way we do it, but there is no voucher or purchase invoice classed in this posting).
Thank you.
Hello everyone, I agree with Dominic and the Financial controller.
just as recap we have 3 step of teeh Invoice register posting:
step 1: invoice register
AP XX
VAT XX
Transitory account XX
step 2: invoice approval (or invoice pool)
2.1 reverse the previous transaction
AP XX
VAT XX
Transitory account XX
2.2 post the final transaction
AP XX
VAT XX
Cost account XX
I think the main issue of the example reported by Dominic is that in the second step the system reverses and post again also the Vat posted and not just the "transitory" / "Pending" account.
In this way the vat is posted 3 times and even if the total is correct in the vat declaration and report of the main european countries it is not acceptable that for one vendor invoice there are 3 tax transactions posted.
Do you know if it is possible to avoid that in the second step the VAT is reversed and re-posted? the goal is to have only one (at the first step) vat transaction posted.
thank you in advance
Hi Ludwig,
Thank you for the links and info. I will share these, as it could be useful to implement within the system.
I will count that as answered now.
Thanks again.
Hi,
Please have a look at this site:
Also this tectalk is interesting
community.dynamics.com/.../finance-and-operations-uk-digital-tax-vat-declaration-in-dynamics-365
Its for AX2012 but the presenter made a talk also for AX2012 - probably search for it in the internet or reach out to him directly.
Best regards,
Ludwig
Hi Ludwig,
This is the area I was looking at (as I developer in AX 2012 R3 for our business), but was trying to understand these transactions. If the posted tax area isn't made for reporting on, then I guess the question is, what is the best report to use in AX 2012 R3 to calculate our VAT that we should be submitting to the HMRC?
Thanks again,
Hi Dominic,
I think we are back at our theoretical discussion :-)
The source field that you see in this form is from the tax trans table.
It is linked to the TaxModuletypeId extended data type, which is intern related to the TaxModuleType enum.
Below are the elements of this enum
This field is just used for classifying where the tax origins from. for example a purchase transaction, a project transaction, a retail transaction.
It does not say anything about the tax or whether the origin of the tax is a purchase order or sales order or whether it is taxable or not.
It just classifies the transaction.
In case you need more details, please grab a developer and debug the tax tables and how the tax information is linked to your voucher.
I would argue that this field is no a documentation of any VAT posting or submission it just refers to the point in the system where this documentation originates from.
Cheers,
Ludwig
Hi Dominic,
I think we are back at our theoretical discussion :-)
The source field that you see in this form is from the tax trans table.
It is linked to the TaxModuletypeId extended data type, which is intern related to the TaxModuleType enum.
Below are the elements of this enum
This field is just used for classifying where the tax origins from. for example a purchase transaction, a project transaction, a retail transaction.
It does not say anything about the tax or whether the origin of the tax is a purchase order or sales order or whether it is taxable or not.
It just classifies the transaction.
In case you need more details, please grab a developer and debug the tax tables and how the tax information is linked to your voucher.
I would argue that this field is no a documentation of any VAT posting or submission it just refers to the point in the system where this documentation originates from.
Cheers,
Ludwig
Hi Ludwig,
I am trying to get an understanding as to why the system behaviours in the way that it does in the "Posted VAT" section in the General Ledger.
If I use another example.
The Financial Controller would like to know what is the purpose of "Source - Purchase Order" because for VAT, the Purchase Invoice is the valid document for VAT. A purchase order isn't a valid documentation for VAT submission. Why does the system do it like this in "Posted VAT"? It seems to be sourcing the numbers from the Purchase Order, when the Purchase Invoice is the true value for VAT.
Thanks again for your time.
Hi Dominic,
I see. So, it looks like an auto-charge.
After all of that back and forth, can you once again highlight the issue / error that you see with the charge and the voucher?
I kind of lost track because we started with the invoice register / approval journals and ended up with charges and subledger forms.
Many thanks,
Ludwig
Hi Ludwig,
It comes in automatically, as that item is set to have a delivery charge due to the type it is. When the item is added to the open purchase order the charge comes with it in "Charges"
Kind regards,
How and where did you enter the 400 euros freight?
What was done to add it?
Have you confirmed the PO first and then added the freight and then confirmed the PO again?
#1
André Arnaud de Cal...
294,017
Super User 2025 Season 1
#2
Martin Dráb
232,852
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
