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) / Purcase order receipt ...
Microsoft Dynamics GP (Archived)

Purcase order receipt details are missing

(0) ShareShare
ReportReport
Posted on by RRedman 565

We see vairly frequently a situation where a purchase order receipt is posted and appears to process correctly. The PO lines are updated correctly and the inventory is updated correctly. The inventory transactions are available in inquiry and smartlist views. However, when you do an inquiry on the PO receipt, the detail lines on the receipt are missing. The total dollars on the document are correct - all the header and footer information is correct. Only the inventory detail lines are missing. And just to be through, the lines are actually missing from the PO receipt SQL tables so it is not a view issue.

 Has anyone seen this behavior? Any idea what might cause it and is there a fix for it?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    Re: Purcase order receipt details are missing

    RRedman,
    What Microsoft Dynamics product line are you using? Looking forward to hearing from you.

  • RRedman Profile Picture
    RRedman 565 on at
    Re: Re: Purcase order receipt details are missing

    We're on Dynamics GP version 9, service pack 4.

  • Community Member Profile Picture
    Community Member on at
    Re: Purcase order receipt details are missing

    Thanks for letting me know. I have now moved this post to the Microsoft Dynamics GP forums. This will get your question in front of more Microsoft Dynamics GP users. If you have any questions please let me know.

  • RRedman Profile Picture
    RRedman 565 on at
    Re: Re: Purcase order receipt details are missing

    Thanks - I'm new to this forum so I'm learning.

  • Community Member Profile Picture
    Community Member on at
    Re: Purcase order receipt details are missing

    NP hopefully the community will be able to help you here.

  • RRedman Profile Picture
    RRedman 565 on at
    Re: Re: Purcase order receipt details are missing

    How do I see the Dynamics GP Forum specifically? I haven't gotten emails about any responses and would like to be able to search that area also.

  • Community Member Profile Picture
    Community Member on at
    Re: Purcase order receipt details are missing

    The Microsoft Dynamics GP forums are located here: http://community.dynamics.com/forums/32.aspx . You have a couple of options to navigate to the Microsoft Dynamics GP forums. Since this post is located in the GP forums you can go to the top of this page and in the cookie crumbs click Microsoft Dynamics GP. Here are the repo navigation steps from the community home page: Community home> Click on the Microsoft Dynamics GP community> click product forums or from the Community home you can click on forums link under the Microsoft Dynamics GP community.

    You should be receiving notifications every time there has been a response to post your active in or following. It looks like no one has responded besides me at this time. But if you received a e-mail from my last response everything is working as designed.

    To search the forums we currently only have one search option and that is located in the upper right chrome. This search currently searches across all blog all forums. We have a new search coming with our next release that will allow for you to only search forums or blog or people or everything. I hope this information helps let me know if you have any questions.

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,768 on at
    Re: Purcase order receipt details are missing

    This sounds pretty strange and is not a known issue that I have heard of before.  If something went wrong with posting these, I would expect that there would also be issues with the inventory quantities and PO's, but you're saying that's not the case. 

    Can you confirm that you can duplicate the issue on another computer while logged in as 'sa'?  (Or even better, directly on the SQL Server, if you have GP installed there?)  Also, if you have any customizations or modified forms, can you turn them off and test?

    If you can duplicate the issue, can you check the tables in SQL to see if the data is actually there?  POP30310 is the table that would have the line items for posted POP receipts.  I would also check the corresponding unposted table (POP10310) to make sure they are not there.

    You say you see this frequently, so some receipts are showing up correctly?  Is there any pattern you can identify as to what is different about the receipts that are showing up correctly vs. ones that are not?

  • Rafael Ruiz Profile Picture
    Rafael Ruiz 70 on at
    Re: Re: Purcase order receipt details are missing

    Hi Victoria, I have also seen this problem in my environment, I have Dynamics GP 10.0 with SP3, we could not replicate the error and we have not found the necessary conditions for this to happen. The Item lines disappear from POP10310 table, but these lines are not in the table POP30310, I have only the header in the table POP30300

  • RRedman Profile Picture
    RRedman 565 on at
    Re: Re: Re: Purcase order receipt details are missing

    It makes me feel better to know I'm not alone out there. And to be honest, I worked for 20+ years as a Great Plains Dynamics master certified consultant and I've seen it happen at other client sites occassionally. I always assumed that it was caused by an undisclosed posting glitch but I can say without qualification that a posting glitch is not happening here and we see it happening in 65 different databases.

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