Microsoft Dynamics GP (Archived)

Payables Historical Aged Report shows credit balance, however Vendor Inquiry shows Zero Balance

(0) Share

Report

Posted on by Napolo

750

Payables Historical Aged Report shows credit balance, however Vendor Inquiry shows Zero Balance.

Aged Trial Balance is Zero

Vendor Inquiry shows all transactions as History without balances.

Historical Aged Trial Balance as of Today shows: Two invoices of $392 and Two credits of $784, with Total Credit remaining of $784.

Check Links Completed

Reconcile run Completed

Below I can see:
the Invoice APR 12 CRFC 013F created 4/30/12 for $392
the Credit APR 12 CRFC 013F CR created 5/8/12 for $784
I drilled down on the credit memo and see that the amount applied $784 is greater than the invoice original amount $392. This would make sense why we can see it on the TB.

How do I fix this?

6761.untitled.png

*This post is locked for comments

All responses (6)

Answers (1)

Napolo 750 on at

Like (0)

Report

RE: Payables Historical Aged Report shows credit balance, however Vendor Inquiry shows Zero Balance

Thank you!

I ran the below SQL command and it corrected the balances. I then had to process 1 credit and enter a JE to offset what i did earlier.

UPDATE dbo.PM20000

SET CURTRXAM = DOCAMNT

WHERE VCHRNMBR = '955466';

Thank you!
Verified answer

Tim W 2,925 on at

Like (0)

Report

RE: Payables Historical Aged Report shows credit balance, however Vendor Inquiry shows Zero Balance

Now..... we're having some fun (well not really :)).

Side question, 2012 is still an open year?

I would read it this way. You have two vouchers 465 and 466 which are both open and should have one of the two payments applied to them but.... likely the two payments have been applied from the standpoint of the payment document header in that if you opened the Apply Payables Documents window both would show a zero unapplied amount. The non aged TB just prints off the header fields, the aged does some math from the apply tables which is why it's different. I would guess the apply records don't exist for the two payments.

I would fix the apply amount on one of the two payments so that the 784.00 is unapplied then apply that one to the two open vouchers. Then void the second payment and delete that JE instead of post it. I would think all four documents sit in PM20000 but again just a guess.

If it was me (insert standard disclaimer here)

update pm20000 set CURTRXAM = DOCAMNT where <one of the payments>

Apply that payment to the two open vouchers

Void the other payment, delete the PMVVR transaction at the GL (unless you are really trying to reconcile 2012)
Napolo 750 on at

Like (0)

Report

RE: Payables Historical Aged Report shows credit balance, however Vendor Inquiry shows Zero Balance

I think I have been looking at this too long. Below are the different AR TB reports. I can see on each invoice that there is an unapplied balance that is higher, but I can't see if something was applied or written off. It is very bizarre.

Here is my HATB

Here is my ATB

Here is my Open Aged Trial Balance
Tim W 2,925 on at

Like (0)

Report

RE: Payables Historical Aged Report shows credit balance, however Vendor Inquiry shows Zero Balance

I would run the Aged Trial balance for just this vendor and see if you have any phantom apply records. What I've seen twice that I can recall is apply records from manual payments that were never posted and did not get cleaned up when the manual payment was deleted. Those sit in the PM10200 table.

They stayed 'applied' as far as the historical report goes. If that's the case when you run ATB for this vendor see if you have payments applied but not posted (they would have an asterisk) that should not be there. If not that you probably have a similar issue with apply records that are in the historical double.

When the ATB logic is executed (both AR and AP) it takes a document and re-adds the apply records that post prior to cut off date and subtracts that from the invoice. In both modules it does not stop at zero but keeps going. I see this more on the AR side (couple times a year) than the AP side (couple times ever)

Hope this helps

Tim
Napolo 750 on at

Like (0)

Report

RE: Payables Historical Aged Report shows credit balance, however Vendor Inquiry shows Zero Balance

I have voided both credits each for $784. It now shows the Invoices OPEN. Now the invoices are showing Original Amount as $392 and Unapplied Amount of $784.

Aged Trial Balance lists both invoices over 91 days for $392 each which is accurate.

I just noticed that there is a Writeoff Amount total of $1568, which I am assuming is part of the issue. Total Over 91 days is calculating $1568 which is the 784 x 2.

Not sure if AP tried to write this off years ago and it wasn't completed properly or it was done after credit was applied?

Currently AP vendor shows 2 invoices due for $392 and Trial Balance shows $1568 due.

Not sure what I should to do to correct this?
L Vail 65,271 on at

Like (0)

Report

RE: Payables Historical Aged Report shows credit balance, however Vendor Inquiry shows Zero Balance

Is the $784 a valid document amount? Can you void the transaction and re-enter it using the correct numbers? I couldn't help but notice that $784 is twice $392

Leslie