Finance | Project Operations, Human Resources, ...

Payables document posted but showing as open - missing details

(0) Share

Report

Posted on by codyto19992

Hello! Our accounting dept reached out regarding a possible duplicate transaction but we aren't too sure what's going on.

The vendor is showing an unapplied payment which should be zero:

When I go into the apply payables document. I can see the Open document for the vendor however there is no line items, I'm assuming there should be to make up the amount?

Only thing I can really think of is maybe the line items are posted but the header or whatever it's called for payables is still Open and needs to be processed into historical?

I tried running check links for the whole purchasing module but it didnt find anything related to this.

From searching around this is what I have been able to find in SQL.
When I look at SQL Table PM20000 - I can see the document.
When I look at SQL Table PM30300 - I see the 4 line items that make up the document amount.

Any help would be appreciated!

Categories:

Microsoft Dynamics GP

All responses (3)

Answers (0)

Cheryl Waswick on at

Like (0)

Report

RE: Payables document posted but showing as open - missing details

Hello, There are no line items in Payables, only POP documents. You will have to research if this is a duplicate payment or not. Review the records you found in the PM30300 table and see if they are applied to this particular payment. If not, then you void the payment if it is a duplicate. If it is the one applied to the records in history, and the apply records equal the full amount of this payment, then you can update the CURTRAMT on it in the PM20000 table and run check links again to move it to history. If you need help, please open a support case.

Thank you,

Cheryl W.

Microsoft Support
codyto19992 10 on at

Like (0)

Report

RE: Payables document posted but showing as open - missing details

Thank you for the suggestion but I did try that with all the purchasing tables with no errors. I just tried again with just the logical table and no errors found.

Thanks!
Suggested answer

Lisa at AonC.com 3,141 on at

Like (0)

Report

RE: Payables document posted but showing as open - missing details

Step 1 is to make certain you have a SQL backup.

Step 2 is to run Check Links on Payables Transaction Logical File.

You should get an error long that references the abandoned apply records being removed.

You may want to ask the user if they had any issues with the vendor/transaction and whether the transaction is now showing correctly in GP/Aging.