Total tax amounts in work file cannot exceed tax amount of open record

(0) Share

Report

Posted on by john.ellis

3,480

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

Categories:

Financial Management

All responses (3)

Answers (0)

Cheryl Waswick on at

Like (0)

Report

RE: Total tax amounts in work file cannot exceed tax amount of open record

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
john.ellis 3,480 on at

Like (0)

Report

RE: Total tax amounts in work file cannot exceed tax amount of open record

Thank you, Cheryl! If the Tax Work file does in fact have more, what would be the necessary steps to eliminate this error?

John
Suggested answer

Cheryl Waswick on at

Like (0)

Report

RE: Total tax amounts in work file cannot exceed tax amount of open record

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.