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
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
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!!!
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.
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.
Share
Report
All responses (
Answers (
