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 :
Microsoft Dynamics GP (Archived)

How to close a PO after a shipment receipt failed to post properly.

(0) ShareShare
ReportReport
Posted on by 163

I have a client with a PO that they would like to close.  This PO has had 2 successful shipment receipts and 2 successful invoice receipts.  However, the bulk of the items show released status.  They were posting a shipment receipt for the remaining items and the workstation appeared to lose connection to the server.  This was a transaction level posting and there is no visible batch anywhere that is not posted.  The first item on the receipt shows a received status but the remainder are in released status.  The POP10300 and the POP10310 tables show nothing in therm for this receipt number.  You can see the receipt in PO Inquiry but there are no detail lines on the receipt.  There is a record in the POP30300 table for the receipt that is blank but there are no records in the POP30310 table for that receipt number.  The POP10500 table is populated with the proper number of records for this receipt, but only the first record has a posted status.  The remainder have an unposted status.  When trying to close the PO we receive the message that we can't close it because it has unposted receipts.  We have run checklinks on the Purchasing Transactions logical table and that did not help.  We ran the PO reconcile to print only and it returned nothing.  The client has already recreated the PO and received the shipment and the invoice.  So, they just need this PO to get closed.  They will have to do an inventory decrease adjustment on the one received item on that bad receipt and back out the GL entries that resulted from that receipt.   Any ideas on the best way to get rid of this PO?

*This post is locked for comments

I have the same question (0)
  • Shirley McCutcheon Profile Picture
    163 on at
    RE: How to close a PO after a shipment receipt failed to post properly.

    Thank you for taking the time to answer this.

  • Verified answer
    kdd281 Profile Picture
    469 on at
    RE: How to close a PO after a shipment receipt failed to post properly.

    We had a similar issue with a receiving transaction post and opened a call up with Microsoft. They suggested we back out the partial records out of the system and re-process the receiving but that might not be an option if the item you received already has been shipped and invoiced. It might be worth working with MS on this one since there are a few layers here. It sounds like you still have some transactions somewhere being referenced since you cannot close them out, we did not have that issue.

    Here is the process to clear out a Partial Transaction to re-receive the items if you want to go that route:

    Update pop10110 set polnesta=2 where ponumber='XXXXX'
    Delete pop30300 where poprctnm='XXXXX'
    Delete pop30310 where poprctnm='XXXXX'
    Delete pop30330 where poprctnm='XXXXX' 
    Delete pop30390 where poprctnm='XXXXX'

    Determine the inventory created by the PO. Do a manual adjustment to remove this inventory. Keep in mind some items also had serial or lot numbers.
    Select * from iv10200 where RCPTNMBR='XXXXX'

    Determine the amount the PO adjusted the GL. Do a manual reverse transaction to remove the amount.

    Select * from GL10000 where ORDOCNUM='XXXXX'
    Select * from GL20000 where ORDOCNUM='XXXXX'

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…

Abhilash Warrier – Community Spotlight

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

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans