web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / PM apply details are m...
Microsoft Dynamics GP (Archived)

PM apply details are mismatching.

(0) ShareShare
ReportReport
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

  • Suggested answer
    soma Profile Picture
    soma 24,416 on at

    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!!!

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,150 on at

    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.

  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi Manikandan,

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

    Thank you!

    Leslie Vail

  • Manikandan Profile Picture
    Manikandan 2,845 on at

    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.

  • soma Profile Picture
    soma 24,416 on at

    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!!!

  • soma Profile Picture
    soma 24,416 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans