PM apply details are mismatching.

(0) Share

Report

Posted on by Manikandan

2,845

I have created Payable invoice and posted last year. For auditing purpose I have checked that invoice and found that the applied amount($1200) is higher than the original invoice amount($950.00). I am confused how it is happened. Is there any reason for GP allowing to apply more than actual invoice amount? Please suggest me.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

soma 24,410 on at

Like (0)

Report

There are many reason may cause for this issue.

To resolve this, go to Payables Reconcile (Tools-->Utilities-->Purchasing-->Reconcile) and choose Vendors and click process to correct the issue.

Hope this helps!!!

Was this reply helpful? Yes No
Heather Roggeveen 9,146 on at

Like (0)

Report

There are any number of reasons for issues like this to crop up - interruptions during posting etc.

A couple of things to try - please ensure you have a recoverable backup:

- Payables Reconcile: Tools --> Utilities --> Payables --> Reconcile

If that doesn't work try running a check links on the Purchasing series.

If neither of these work, you may need some manual updates to happen in the tables to correct.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi Manikandan,

Did Somakarpagamoorthy Kanagasabapathy's answer resolve your issue? If yes, please mark your question as answered.

Thank you!

Leslie Vail

Was this reply helpful? Yes No
Manikandan 2,845 on at

Like (0)

Report

I have tried that, but it is not cleared, because that transaction was made at year(2013). The year end close process is already done for that year. So I don't know how to resolve that.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

I think Reconcile process consider/validate all the transactions for the selected range of Vendors in Reconcile window. Not think about year end close.

Have you tried to run the check links for Payables Transactions & Historical logical Files?

If the above not solved your problem, then you need to correct this issue via SQL update.

Hope this helps!!!

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

Also run the below query against your company database and attach the result to us.

SELECT * FROM PM30200 WHERE VCHRNMBR ='ENTER YOUR INVOICE VOUCHER NUMBER' AND DOCTYPE = 1

SELECT * FROM PM30300 WHERE APTVCHNM ='ENTER YOUR INVOICE VOUCHER NUMBER' AND APTODCTY = 1

SELECT * FROM PM10200 WHERE APTVCHNM ='ENTER YOUR INVOICE VOUCHER NUMBER' AND APTODCTY = 1

Was this reply helpful? Yes No