How to Set Up Over Receive Purchase Orders in Business Central

by | Updated August 28, 2020 | Dynamics 365 Business Central

With the spring Release of Dynamics 365 Business Central, we now can Over Receive a Purchase Order. Why is this necessary you may ask? In some cases, a vendor may ship more or less than the purchase order calls for based on the weight of an item or a simple mistake. The vendor may offer you a discount to keep the additional items as it may be cheaper than paying the return shipment charge, or maybe it is the vendor’s policy as they cannot always ship exact amounts when items are hard to count. Or, it could be the case where your warehouse workers must be able to handle such receipts without going through a lengthy process of preparing and getting approval for a new purchase order.

Prior to this release, the solution was to call the Purchasing Agent and have them change the Quantity on the Purchase Order, and then we could receive the Purchase Order. Here’s how you can set up Over Receive Purchase Orders in D365 Business Central instead.

Follow these setup steps in Dynamics 365 Business Central for Over-receipts Codes

  1. Choose the icon, enter Over receipts, and then choose the related link.
  2. Select New
    1. Enter a Code
    2. Description
    3. Check the default box, if you would like this automatically apply when the over receipt is triggered at the Receiving process
    4. Enter a Tolerance Percentage
    5. Check the Approved required if that is your process

Over Receive

You then assign the code to the cards of relevant items and/or vendors.

How to Set Up and Assign an Over-Receipt Code to an Item

Note: The steps are similar for a vendor.

  1. Choose the icon, enter Items, and then choose the related link.
  2. Open the card for an item that you suspect may sometimes be delivered with a higher quantity than ordered.
  3. Go to the Inventory FastTab and Choose the look-up button in the Over-Receipt Code field.

Inventory

  1. If the code does not exist, Choose the New
  2. On the Over-Receipt Codespage, create one or more new lines that define different over-receive policies. Hover over a field to read a short description.

Over Receipt Codes

6. Select a line, and then choose the OK button.

7. The over-receipt code is assigned to the item. Any purchase order or warehouse receipt for the item now allows receiving more than the ordered quantity according to the specified over-receipt tolerance percentage.

I will explain below how the new features work and when they may be used.

Purchase Order

On purchase lines and warehouse receipt lines, the Over-Receipt Quantity field is used to record over-received quantities, meaning quantities that exceed the value in the Quantity field, the ordered quantity. When you handle an over-receipt, you can either increase the value in the Qty. to Receive field to the received quantity. The Over-Receipt Quantity field is then updated to show the excess quantity. Alternatively, you can enter the excess quantity in the Over-Receipt Quantity field. The Qty. to Receive field is then updated to show the ordered quantity plus the excess quantity. The following procedure described how to fill in the Qty. to Receive field.

  1. On a purchase order or a warehouse receipt document where the received quantity is higher than ordered, enter the received quantity in the  to Receive field.

Qty. to Receive

If the increase is within the tolerance specified by the assigned over-receipt code, the Over-Receipt Quantity field is updated to show the quantity by which the value in the Quantity field is exceeded.

Receipt Quantity

If the increase is above the specified tolerance, the over-receipt is not allowed. In that case, you can investigate if another over-receipt code exists that will allow it. Otherwise, only the ordered quantity can be received, and the excess quantity must be handled otherwise, for example, by returning it to the vendor.

Purchase Order

2. Post the receipt as you would for any other receipt.

Receipt

Navigate back to the Item Card and you can see that the qty Is now 21 in all journal entries and all Qty on Hand fields

Item CardItem Ledger Entries

Note – Business Central does not include functionality to automatically initiate the financial administration of over-receipts. You must manually handle this in agreement with the vendor, for example, by the vendor forwarding a new or updated invoice.

Related Posts

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events

february

03feb12:00 pm12:45 pmFour Keys to Choosing the Best ERP or CRM Solution: Part 2 – Platform

10feb12:00 pm12:45 pmFour Keys to Choosing the Best ERP or CRM Solution: Part 3 – Implementation Partner

11feb11:00 am12:00 pmConfab with Stoneridge - Livestream - Live Agents, Power Virtual Agents, Omnichannel – Oh My!

16feb12:00 pm12:45 pmFour Keys to Choosing the Best ERP or CRM Solution: Part 4 – Cost

24feb10:00 am11:00 am5 Campaigns Manufacturing Marketers Don’t Want to Miss

25feb11:00 am12:00 pmConfab with Stoneridge - Livestream - Surfing Through the Dynamics 365 Wave 1 2021 Release

march

03mar10:00 am10:30 amThe Modern Manufacturer - MRP vs. MPS – What, When and How

03mar2:00 pm2:30 pmLot Management Best Practices for Batch Manufacturers

10mar10:00 am10:30 amEnhancing the Customer Experience and Driving More Business with Dynamics 365 Customer Service

10mar2:00 pm2:30 pmThe Five Steps to Managing Sales Tax for Manufacturers

11mar11:00 am12:00 pmConfab with Stoneridge - Livestream - Power Apps Component Framework Power Hour

17mar10:00 am10:30 amThe Modern Manufacturer: Pro Tips for your Finance Team

24mar10:00 am10:30 amUnlock the Potential of Digital Marketing with Dynamics 365 Marketing

25mar11:00 am12:00 pmConfab with Stoneridge - Livestream - The Four Keys to Choosing the Best ERP or CRM Solution

31mar10:00 am10:30 amThe Modern Manufacturer: Keys to Reporting Success

31mar01aprTraining Class: Financial Reporting W/Account Schedules for Dynamics 365 Business Central

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X