Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Under receiving on Pur...
Small and medium business | Business Central, N...
Answered

Under receiving on Purchase Orders

(0) ShareShare
ReportReport
Posted on by Azzure-IT-CSwann 45

Hello,

I am seeking advice on the correct process of closing a purchase order for which I originally requested a qty of 10 of a certain item but received 7. I assumed that there would be some sort of audit for this common process which, logically, would allow me to receive and post a purchase invoice for the 7 and mark the purchase order as 'do not expect the remaining qty', close it and allow a discrepancy report to be generated for my supplier evaluation.

The only thing I am see that I am able to do, is manually change the original qty on the PO, which is not very good as a process.

  • David Shaw_UK Profile Picture
    David Shaw_UK 6 on at
    Under receiving on Purchase Orders
    I am no accountant but I am a certified BC functional consultant,Here is the issue with this scenario:
    1) If you have made the prepayment in full for the invoice of 10 you will need to create a credit Purchase Credit Memo for the qty you never recieved as you would be receiving a credit memo from the supplier.
    2) You can use a G/L code to capture the credit amount without effecting Item ledger, however doing so gives such user access to the COA as they need at least Read Permission for G/L accounts to insert G/L lines.
    3) You can use Item lines instead of G/L, however this will trigger Item Ledger (negative adjustments).
    4) In my opinion, receiving what has been invoiced (full) then raising a credit memo with Item lines type, everything will balance. And you dont have to give such user access to COA.
    5) In short you do point 4, or you delete/archive order and raise credit memo with line type G/L.
    6) Be careful not to use point 4 Item type in credit memo as well as not recieving in full or your Item ledger will be less than your actual stock as the credit memo will reduce the already short stock.
  • Azzure-IT-CSwann Profile Picture
    Azzure-IT-CSwann 45 on at
    RE: Under receiving on Purchase Orders

    Hi All,

    Thank you for taking the time to help me out. Much appreciated.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Under receiving on Purchase Orders

    Happy New Year.  

    If you want to track a PO whereby you Originally Ordered 10, posted a Purchase Receipt of 7, and will NOT receive the remaining 3 and want to DELETE the Purchase Order document, I will give you 2 Options:

    1. If this occurs often and Users make changes a lot, I would go to Purchase & Payable Setup/Archiving Fast Tab and setup Archive Orders.

    pastedimage1609863508158v1.png

    2. You could manually Archive the Purchase Order, from the PO Document, by clicking Actions, on the Action bar, then Functions/Archive Document

    pastedimage1609863508158v2.png

    Hope this helps. Not that there is no functionality to auto-delete the PO when the remaining QTY is NOT to be received. I can tell you this has been requested by customers and an extension was written to add the feature.

    Thanks,

    Steve

  • Suggested answer
    Alessandro Vannini 1 Profile Picture
    Alessandro Vannini 1 on at
    RE: Under receiving on Purchase Orders

    Hello

    in the BC version we have added the capability to set over receipt quantity, but at the moment we are not allowing to reduce the quantity

    The workaround is the one you are using

  • Suggested answer
    MartinNL Profile Picture
    MartinNL 480 on at
    RE: Under receiving on Purchase Orders

    Hi,

    I'm sure there are many smart ways to achieve what you want and maybe even in more specific detail with development. But as a simple standard option, I would consider just archiving the PO before changing the quantity and posting. You can later review the PO archives for analysis and comments about your supplier evaluations.

    Regards,

    Martin

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans