Hi:
We were trying to void an open invoice in the Void Open Payables Transactions window. When we close out of the window, however, the Posting Journal displays the following error:
"Total tax amounts in work file cannot exceed tax amount of open record."
Also, the void is not successful.
What is the remedy?
John
I don't know what you found, but I'd assume you can just update the tax work table to have the same tax amount as the posted document has. The error is not going to go away until the tax amount matches between the two tables. Be sure to try it in a test environment first.
Cheryl W
Microsoft Dynamics GP
Thank you, Cheryl! If the Tax Work file does in fact have more, what would be the necessary steps to eliminate this error?
John
It sounds like the Tax work file may have more taxes on it than the posted document has. Use these scripts to investigate the tax amounts in each table below: (modify the voucher number for your voucher number of the document you are trying to void. If they are the same, or the tax work file is not more than the other, then the error should go away)
--Tax Work file
select TAXAMNT, * from PM10500 where VCHRNMBR = 'VCH0000000000xxxx'
--Posted trx
select TAXAMNT, * from PM20000 where VCHRNMBR = 'VCH0000000000xxxx'
Hope that helps,
Cheryl W.
Microsoft Support
*Please mark the response that helps you as the 'answer' so others can benefit from this post.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148