Share
Report
5Hello,
I am creating a SQL trigger that will calculate the taxes for the SOP document total and overwrite the tax total that is calculated by totaling the SOP line item tax amounts in Dynamics GP. Based on my scenario, I welcome any suggestions or other solutions that I can use.
Scenario
In my scenario I have two taxes details that calculate tax at 5% each for a total tax amount of 10%. Along with other SOP lines items, there are four different line entries of $49.50 each, with the document total being $700. Tax on this document should be $70, but because of rounding with the two 5% taxes. The four line entries are calculating a tax of $4.96 each. This is resulting in a document tax total of $70.04.
Solution
I am thinking the SQL trigger should update the information on the Sales Tax Summary Entry form only. I will leave the Tax Details on each line item as they are. I am also going to update ‘Round’ field on the Tax Detail Maintenance form for one of the taxes to ‘Down to the Previous Currency Decimal Digit’. This will make it so that the overall tax total will be the same as the document total I will change, though the tax details amounts between the two totals will be off by pennies. Finally, there will be a SmartList for the AR accountant to review the information in-case they need to change anything.
Thank you for any additional insight you provide.
*This post is locked for comments
All responses (
Answers (
