Version Française disponible ici
Every time I’m facing the Deliver Remainder screen, I always ask myself what I should indicate in the quantity field and which button should I press. It’s not difficult to get it, but I know I will forget again next time and i twill probably make this clear for some of you as well so here I am writting.
Purpose
What is the Deliver Remainder form purpose ? It applies on purchase and sales order lines, and here I will focus on purchase order examples.
When you have ordered a certain quantity for a line, and you know for sure you won’t be deliver for all the quantity ordered, you can do two different actions if you want to close the line, meaning have it fully delivered and not waiting for a delivery that will never come.
- When running the product receipt, you can tick the Close line checkbox. Then if you’re receiving x % of the quantity ordered and you know you won’t receive what’s left you can process this. Take care of the underdelivery setup because you will need to have this setup at least to 1 – x if you want to close your transaction in that way.
- If you don’t know for sure when running the product receipt that you won’t receive anything else, you may not you the Close checkbox. But after waiting few days/weeks, you want to close the line anyway because you’re sure at that time that nothing will be received for that line. Then, you can use the Deliver Remainder functionality to close the line.
Scenario tested
Here is our simple example, and then I’ve declined all possibilities.
So I’m ordering for a quantity of 10 in ITEM-YR12.
Then I’m proceeding to a partial product receipt of 2.
What I can see in the transaction is that 8 are still ordered and the line is still Open.
If I want to close the line after doing the receipt, I will use the Deliver remainder option available under Update line.
Here, I’m facing the form, with two Deliver Remainder field (Purchase Quantity) and 3 buttons : OK, Cancel Quantity and Cancel.
So here is the behaviour of that form :
Cancel
Cancel is cancelling what you are trying to do right now. It’s a basic cancel button and you go back to the previous screen without any change.
Cancel quantity
Whatever you indicate in the Deliver remainder fields, it will always behave the same way : it will close the line. In more details, the 8 of my item ordered will be deleted, meaning the line will update to received.
OK
Here we have different cases : first if you’re updating the Purchase Quantity field to something, the Inventory Quantity will update automatically accordingly.
Updating the Purchase quantity
If I’m reducing the 8 to 3, and press OK, the system will wait for 3 items to be received (so the Ordered quantity has been reduced to 3).
If I’m reducting to 0, and press OK, the behaviour is the same than Cancel quantity button.
Updating the Inventory quantity
If I’m updating the Inventory quantity to 4, the Purchase quantity remains at 8. By looking at the transactions, the Ordered quantity has been reduced to 4. When running the product receipt, the default quantity to be received is displaying 8.
If I’m pressing OK on the Product Receipt form with 8, it will validate anyway only 4. This will work only if the Underdelivery is setup to 50 (for my case).
To conclude I can understand MSDyn365FO behave properly but I can’t see any business meaning for using only the Inventory quantity instead of Purchase quantity. If there is any, please share it in comments.
Bonus
It’s more relevant to distinguish the Purchase and Inventory quantity if it applies to item purchase and stored in different units. So here is one item purchase in EA and stocked in Bag (with a factor of 1 bag = 10 EA).
I’ve ordered 100 to my supplier and received already 40. Having a look at my transactions :
Then going to Deliver remainder, you notice the difference quite obvisouly. The behaviour doesn’t change according to the previous tests.
Cheers
Yohann ROLLAND
« I can’t see any business meaning for using only the Inventory quantity instead of Purchase quantity. If there is any, please share it in comments. »
A reason is sometimes unit conversions are not consistent. In tubulars (pipe), they are often stored in each (ea’s) and on average let’s say 1 ea = 20ft.
You may receive 3 pieces of pipe that are 20ft, 22ft, and 21ft. You would type 63ft and 3 inventory qty (ea). If you simply typed 3 for inventory qty and 60 ft, that wouldn’t be accurate
Thanks sharing this John Doe.
D365….. we « always » cancel remaining quantity for SO and PO. Is there a setting that automates the cancel remaining quantity versus manually having to touch the individual lines?