Start a conversation

Fix qty on order/received when user receives more than ordered without updating entries first.

From RMS reseller forum:

We have seen no issues with running this in terms of current purchase orders or anything else, since this only affects the items that you receive more than you ordered (I.E., you order 10, you get 12 in the store and you receive 12 without editing the order quantity).

UPDATE PurchaseOrderEntry SET QuantityOrdered = QuantityReceivedToDate WHERE QuantityReceivedToDate > QuantityOrdered

 

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Dave J

  2. Posted
  3. Updated

Comments