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

Notifications

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) / Cannot find some payme...
Microsoft Dynamics GP (Archived)

Cannot find some payment transaction by Inquiry

(0) ShareShare
ReportReport
Posted on by Hayaty 730

Some payments were already aplied and we can see these transactionson AR Aged Trial Balance. However, we cannot find these payment transactions by Receivable Transaction Inquiry and Smart List, even I typed the document number in search box. Has anyone encountered the same situation? Does someone know how to resolve this issue? Please help!
Environment is GP10.0 sp1 and SQL2005.

*This post is locked for comments

I have the same question (0)
  • K Day Profile Picture
    K Day 7,365 on at

     I would look at one particular invoice that you can't find the payment for under inquiry by customer, then drill into it from there to see what if something actually shows up or if it throws an error or shows up blank. Off the top of my head, (on the payables side at least) this is done by clicking the "Unapplied Amount" hyperlink in that window.  I wouldn't be surprised if it showed a payment document but all the info was blank.

    I might also think to run Checklinks and Reconcile in the the sales module.  This goes through different tables to look for data integrity and if it finds a record that doesn't look right, it will attempt to rebuild that record based on information in some of the other tables.

  • Community Member Profile Picture
    Community Member on at

    Is your AR aged TB set to include unposted applied credit documents?

    Check to see if the payments are actually posted. As per other posts, look at the Debtors account (Enquiry >> Sales >> Transactions by customer). Search through the account for Work documents. Are any of these the missing payments?

    Best regards,

  • Hayaty Profile Picture
    Hayaty 730 on at

    Hello K Day,  Ian

    Thank you for your help. I did run Checklinks and Recoincile and checked the option for AR aged TB, but cannot find missing payment documents.
    However, I found the cause of this issue. The reason is that a macro for Multifacility module didn't work correctly.
    I did assign Facility ID to the payments by manually. They showed up by inquty and smartlist.
    I will check the macro which part didn't work. Thank you!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans