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 / Finance | Project Operations, Human Resources, ... / Purchasing Invoice Inq...
Finance | Project Operations, Human Resources, ...
Answered

Purchasing Invoice Inquiry Zoom

(0) ShareShare
ReportReport
Posted on by Community Member

Note in my print screen below that the Receipt for "Matched to Shipment" is missing.  I'm trying to determine why it's missing.

What is the database query that pulls in the data to the Purchasing Invoice Inquiry Zoom?

Which database table(s) is the "Matched to Shipment" Field pulling from?

As far as I can tell, the database records for these tables look good: 

   pop10500 - Receipt Line Quantities (line detail)

   pop30300 - Receipt History (header)

   pop30310 - Receipt Line History (line detail)

pastedimage1620059427953v6.png

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Verified answer
    Hokuminaria Profile Picture
    Hokuminaria 2,950 on at

    Hello Connexus Energy,

    Please see the answers to your questions below.

    1. What is the database query that pulls in the data to the Purchasing Invoice Inquiry Zoom?

      1. To build the data in this window, it uses a few calls and multiple tables. I included the DexSQL.log of this process so you can review the calls for this window.

    Purchase-Invoice-Inquiry-Zoom-Log_2E00_.txt

    1. Which database table(s) is the "Matched to Shipment" Field pulling from?

      1. This is from the POP10600. The field it pulls from is the POPRCTNM.

    I hope this helps!

    Thank you!

    Brandon Jarrett | Microsoft Support Engineer.

  • Community Member Profile Picture
    Community Member on at

    Bingo!  This is what I needed Brandon.  I was able to resolve my issue.  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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 592 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 305 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans