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) / Goods Received Not Inv...
Microsoft Dynamics GP (Archived)

Goods Received Not Invoiced

(0) ShareShare
ReportReport
Posted on by Heather Roggeveen 9,150

Hi

I have an issue at one of my clients where this report just will not print.  Tried SQL logging and it doesn't seem to be doing anything. 

Ran it on my system and it seems to be mainly looking at POP10500 table.  So I had a look at this table to see if I could spot issues.

Seems like there are some transactions that just should not be there anymore (which makes me think that some of the data is stopping the report).

Here are some examples:

GRNI2.png

GRNI3.png

So I am seeing that the table shows no PO number - but when you drill into the Receipt in GP, there is a PO number - but not when you drill into the transaction.

I ran a check links on the test database, but nothing changed in this table.

My base understanding is that removing completed purchase orders should clear this table - as you can see from the above, this transaction is dated 2005 - in GP no open purchase orders exist prior to Jan 2013.  I had a number of data issues earlier in the year that I sorted for this site - looks like this is another area I need to tidy for them!

Cheers

Heather

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    I think, the table has updated with wrong values through back-end or any other application( maybe I am wrong).

    Have you check this receipt having PO number in POP10310( Receipt line table)?

    Also check(item number, qty & amount) for the po number showing in GP inquiry window is belongs to this particular receipt/invoice.

    If this PO is belong to this purchasing invoice, you need to update the po number through backend.

    Also check the ODBC whether you have connected appropriate SQL server with GP.

    Hope this helps!!!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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