Share
Report
121Currently I am calcualting the sales tax percentage by dividing the tax amount by the line total.
SELECT SOPNUMBER, ITEMNMBR, (TAXAMNT/XTNDPRCE)*100 TAXRATE FROM SOP30300
The problem is, the tax value will have been rounded to the nearest £0.01, which means the TAXRATE will be slightly inaccurate in most cases. Take the example below:
I sell 8 copies of a book for £1.52 each, resulting in an XTNDPRCE of £12.16. 20% VAT is applied to the, so the actual tax amount is £2.432. Dynamics will round this value to the nearest penny (this is the behaviour that I want), so a value of £2.43 will be calculated for the TAXAMNT.
In the example above, the actual tax is 19.984% and not the full 20% UK VAT rate (because the tax was rounded, some precision was forfeited), so when assigning a VAT code to the item, it is assigned a "mixed" code - A, however it should be assigned a "standard" code - S.
Is there a procedure or view that allows me to calculate the tax percentage (not overall tax value) of a line in an order, without having to reverse engineer it and end up with a precise, but incorrect, result?
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
