Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Receipt In PO is missing

Posted on by 137

I am in urgent need of help, I have a purchase order in which one of the line items says it's been received but it has not impacted the Inventory. and when I am looking for the Receipt it says we cannot open it "because it has been removed" and when I Reconcile the PO documents I am getting an error message for that Item number as " Adjusted qty uncommitted in the base from 50 to 0" 

Not sure what this error is about.

Note: 50 is the qty we have received for that item number.

Any help will be appreciated as without fixing this We will not be able to Invoice.

Thank you 

Categories:
  • RE: Receipt In PO is missing

    Hi,

    It sounds like something might have happened during the posting of the Receipt. I agree that you may need to create a case to look at the details of the data to determine what the status is of the receipt.  If you don't have access to someone you could move your data into a TEST company and give this a try. 

    1st - Move the data into a TEST company if you can.  If not make a backup of the LIVE database. 

    2nd - Run checklinks on the Purchasing worktable (File > Maintenance > Checkclinks > Purchasing > Insert Purchasing Transaction and Purchasing History).  These two are for Purchase Order processing. Let me know if you get anything on the report regarding that PO and or receipt.

    3rd - I'm not sure where you were looking when what window you were in when you were trying to open the receipt and received the error "Because it has been removed"   Was this in the Receivings Transaction Entry window?  Or an Inquiry window?   Please explain.

    If it's urgent that you get an invoice out, you can ALWAYs enter a manual invoice in Payables and adjust the Accrued Purchases & Accounts payables account just like you would have had it been an invoice in Purchase Order processing.  Then we can deal with the rest of the PO line later.

    NOTE: The only issue is IF there is a cost is different between the original shipment receipt and the invoice and how you typically account for that. 

    • If you typically just hit a PPV account, no big deal.  You can adjust that later in GL. 
    • If you typically revalue your inventory, you could adjust cost the layer in the Adjust cost utility window for that receipt if we find it. (Or may have to manually enter it anyway)

    Depending on what we find with the Receipt will determine what to do with the rest of the steps.  It might be to just close the lines on the PO or close the whole PO itself and adjust Inventory manually.  Hard to say.  Let me know what happens with checklinks and also where you see the receipt and where you received that error and I'll do what I can to help.

    Thanks for using Communities,

    Angela Ebensteiner

    Microsoft Support

  • Michael O'Donnell Profile Picture
    Michael O'Donnell 355 on at
    RE: Receipt In PO is missing

    Since reconcile did not fix the problem, you will need to have your GP support person look at the SQL tables to see what is going on behind the scenes.

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans