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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / I am doing an inquiry ...
Microsoft Dynamics GP (Archived)

I am doing an inquiry for an invoice and I am not finding it, I have a printed document, and the data is in the database. I need to know what went on with this document, I am using GP 10.

(0) ShareShare
ReportReport
Posted on by Rosemary Roopnarine 455

I am doing an inquiry for an invoice and I am not finding it, I have a printed document, and the data is in the database. I need to know what went on with this document, I am using GP 10.

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    Re: I am doing an inquiry for an invoice and I am not finding it, I have a printed document, and the data is in the database. I need to know what went on with this document, I am using GP 10.

    Are we talking an SOP invoice or just an AR invoice? I assume you are going under Inqury->Sales->Sales Docs or Inquiry->Sales->Transaction by Document. Have you tried running Check Links? If you go into SQL and look in the SOP30200 for Sales or RM20101 do you see it in there? Of course, you also need to check the RM Key Master table RM00401. Are you searching by document number or by date? Could there be a bad date?

  • Harry Saryan Profile Picture
    Harry Saryan 190 on at
    Re: I am doing an inquiry for an invoice and I am not finding it, I have a printed document, and the data is in the database. I need to know what went on with this document, I am using GP 10.

    One other way you can find that invoice, IF there are documents applied to that particular invoice, you can search for the 'Applied docs' then Select the applied Doc and click on Amount Remaining link.  And this way you can find your original invoice document number.

    .

     One other thing that could occur if you accidentally left spaces after the document number.

    The best way to find documents with spaces do this: For example if the document number is 'ABCDEF123  '  You can when do Transaction Inquiry by document and in the From Field: Enter 'A'  and in the To: Field enter 'AZ'    This will bring all documents starting with A.  Or if you want to narrow it down further you can enter 'ABCD' in the From field and 'ABCDZ' in the TO Field.  Note; the 'Z' letter at the end of the To Field.  

    L8r

    H

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September 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