Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Receipt missing PO Number

Posted on by Microsoft Employee

We currently have a PO from last year showing up on our Received Not Invoiced report. When looking into it I was able to determine that there isn't a PO Number attached to the receipt and the PO Line Number field is 0 in the POP10500 table. The quantity match for the receipt line in question is 0, with a value of 55 in the quantity shipped and quantity reserved fields.

I have ran Check Lists for Purchasing Transactions, which did not correct our issue. I'm assuming that we'll have to remove the Receipt and perform the 3-way match again? 

Any information on how to resolve this and get it off of our RNI report would be greatly appreciated.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Receipt missing PO Number

    If we have already 3-way matched. Would you suggest creating a new receipt for the line in question and matching the receipt with a dummy invoice? I've discussed with our accounting department and they don't see an issue with performing a return to correctly receive the line that was mistakenly received, but I'm not 100% sure how we should invoice it since it has already been invoiced.

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: Receipt missing PO Number

    This is quite common in GP..as Mario suggested..we try and fix with the return transaction and receive again. It usually fixes it...although you can run into issues when using lot or serial number tracking

  • Suggested answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Receipt missing PO Number

    It sounds like someone was in a hurry and entered a receipt without a PO in GP, which is entirely possible. To get rid of this, you will probably want to create a return transaction (Purchasing > Transactions > Returns Transaction Entry) of type Inventory. If you are still expecting an invoice, you can mark the Invoice Expected for Returned Goods checkmark. Then, you would simply select the item, and point to the receipt in question. Post the return to update inventory.

    I strongly suggest you take a copy of your production data and restore in a test environment. Complete the procedures above in test as this may have more implications than one. Since this receipt was entered last year, it means now that inventory will be off (or maybe not, depending on your expectations) by the value of the goods being returned. If you already sold or consumed the items received, it will also affect cost of good sold. So please discuss with your accounting team.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans