I need the following configuration to apply for BC wave 2.
When sales reps are placing the orders. need to validate the Qty with inventory on hand by location. I know from the SO level we cant validate the Inventory. But need to apply this control. We required validation Specially on the sales order if the quantity is greater than the available inventory do not allow to create the sales order.
Please suggest logic and code …
Appreciate your early response.
You need to put this check in 2 places one for quantity and one for location in sales line table. Below is the code, figure out where exactly you can plug this code, you can also write a function and put a hook to call this code using the function.
if currfieldno = fieldno(quantity) then begin
If (type = type::item) and (“no.” <> ‘’) then begin
itemrec.setfilter(“location filter”,“location code”);
if itemrec.find(’-’) then begin
if quantity > itemrec.inventory then
error(‘There is not enough qty. on hand for this item and location’);