Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Purchase order Quantity vs Quantity received

Posted on by 28
Hi,
 
I have a questions regarding when I do a Purchase order, say for example 27 000 pieces of something.
 
Then, I get them (but just 26 000pieces) from the supplier, make a receipt, but we just receive like 26 000 pieces. I match the invoice etc. But, what do to with the remaining 1000 pieces on the purchase order? I will not get them from the supplier (no more receipt). I still want to close the purchase order etc, but I still got 1000st to recieve so to say.
 
When I do the receipt, I some how want to adjust the quantity to 26 000 instead of 27 000?
 
I hope you understand my somewhat, unclear problem.
 
Kind regards and thanks,
Tobias
Categories:
  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 4,894 Super User 2024 Season 2 on at
    Purchase order Quantity vs Quantity received
    Tobias,
     
    In this scenario the out-of-the-box solution, since no other receipts are coming, is to adjust the PO quantity down to match the receipts.  At this point your Quantity, Quantity Received, and Quantity Invoiced will all match, which will allow for the deletion of the Purchase Order.  There is a batch process to delete POs that meet this criteria and it can be setup to run as a Job Queue.
     
    Unfortunately, there is no standard under-receipt tolerance in Business Central.  You could write an Extension similar to the Over Receipt Code functionality, where if the Quantity Received is within a given percentage of the line Quantity the system asks if you want to adjust the Order Quantity.  The code would then adjust the Quantity down to match the Quantity being Received so the Order closes upon posting the Invoice.
     
    Hope this helps.  If so, please mark this as a solution so other forum Users can find the information easier.
     
    Best Regards,
    Ben Baxter
    Accent Software, Inc
  • Suggested answer
    Community member Profile Picture
    Community member 21 on at
    Purchase order Quantity vs Quantity received
    Hi,
     
    You won't be able to do this without development.  My suggestion would be as follows:
    1. Enter the quantity to receive in each line for the quantity delivered by the supplier.
    2. If the quantity to receive is not blank and is less than the outstanding quantity then you could have a new boolean on the purchase line to close the line. 
    3. This means that for any line that is ticked as closed the quantity would be updated to what has been received in total when the user posts the receipt.
     
    I don't believe there is anything standard to reduce the quantity without manual intervention or development required.
     
    Hope that helps,
    Shauna

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,219 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