SalesOrder.UpdateMaster() BPM not updating properly when quantity is changed on sales order

Epicor ERP 10
, ,
1

Hello everyone,

I’m seeing some odd behavior in a PreProcessing BPM on SalesOrder.MasterUpdate(). The BPM is intended to check the part on the sales order line and compare it to the Customer’s price list. I have added a UD field “MinimumOrderQty” to the PriceListParts table which is compared against the quantity of the sales order. If the quantity on the order is less than this “MinimumOrderQty” UD field, I display a form warning the user and giving them an opportunity to update the quantity. This is working exactly as intended when I update anything on the order line except OrderDtl.OrderQty.

When updating order quantity, SalesOrder.ChangeSellingQtyMaster gets called before MasterUpdate. I am wondering if this is somehow causing the new quantity grabbed from the BPM form to be overridden. However in the MasterUpdate calls following ChangeSellingQtyMaster, I can see the value I enter in the data form in the OrderDtl.OrderQty field. It just never writes that value to the database.

I have considered calling “Update” in Post-Processing and then refreshing the sales order entry screen, but this seems inefficient.

2

This is just a guess, but I’m wondering if it’s due to a mismatch between the OrderDtl.SellingQuantity field (the one that is actually bound to the UI) and the OrderDtl.OrderQty field that you’re updating from the BPM form input.

Maybe try calling the SalesOrder.ChangeSellingQtyMaster method itself in your BPM to change the qty, instead of going directly to the OrderDtl.OrderQty field.

1 Like
3

That was exactly it. Thank you Tom!

1 Like