Home Button  Buy Button 

Topic:   recieved qty > ordered qty

By: GuestPosted on: Nov 25 2019 at 08:22:28 AM
When purchasing components, sometimes the received quantity is more than the ordered quantity. When entering the received items on the goods in page, the on stock quantity is correctly handled, but the on order quantity becomes negative and the order is not closed beacuse received != ordered. In my opinion this logic should be changed to if received >= ordered then the order can be closed and the on-order quantity should not become negative, as placing an order for a negative quantity does not make much sense. Now we use the goods in procedure to equal the received items to the ordered so the purchse order is closed. After that we manually adjust the quantity for the extra items received.

By: JamesPosted on: Nov 26 2019 at 10:13:20 AM
Sorry. I can not agree. The order is incomplete and should remain in the list of incomplete orders until the received quantity is equal to the ordered quantity.

If my supplier sends too many then in most cases it's because I ignored or was unaware of his minimum order quantity. I can either accept (and pay for) the extras or I can reject the delivery. In any case I do not want the software to silently accept the delivery and close the order. So when I notice that too many have been supplied, and assuming I want to accept them, I will bring up the original purchase order and adjust the ordered quantity. I can then receive the quantity and the order closes itself.

But occasionally I do it the same way that you do. In any case it's something that must need manual action on my part not an automatic thing in the software.


By: GuestPosted on: Nov 27 2019 at 07:55:09 PM
Relating to Guests post we had someone accidentally receive more than on the PO and it I am also seeing the negative quantity on order. I am unsure how to correct this to remove the negative pending. Does anyone know how to fix so the negative disappears?

By: JasonPosted on: Nov 28 2019 at 07:35:17 AM
When you try to receive too many minimrp tells you that you are trying to receive too many. It asks you if you are sure that you want to do that.

But assuming you ignored that and actually did receive too many you can always go back and change the quantity received.

In the Purchasing menu you see a button labelled "GRNs". Click that and it brings up the list of recent deliveries that you have received.

GRN stands for GoodsReceivedNote/Number. You don't have to use GRN numbers but it's recomended that you do because it make it easier to find deliveries if you want to go back and change them.

Find the one you want to edit. Open it. Change/correct the quantity, Save.

That's all there is to it.

By: JasonPosted on: Nov 28 2019 at 07:39:39 AM
Or maybe you already tried that but found that the data quantities could not be edited. Be aware that when viewing an existing GRN the data is locked - can't be edited - to prevent accidental edits (ie the office cat walking on your keyboard) - Just click the PadLock button in the top right corner of the window to unlock.

By: GuestPosted on: Mar 15 2020 at 06:25:50 AM
I know this thread is a little old but just in case anyone else searches this topic - here's a the better solution.
Go to menu bar "Purchasing" > "List Purchase Orders". This brings up a list of 'open' orders. (orders not yet received or under/over received)

Click the order with the RIGHT mouse button and select the option to 'Close'.

That closes the order - moves it to the closed orders list and removes the negative quantity from the OnOrder column.

Reply - add a comment to this topic.

You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.

Topic:- recieved qty > ordered qty


Enter the numbers.

Your name here is optional