We have been using B1 about 45 days now. We have 1 shipping warehouse, and 1 for returned items (plus some others). Anyway, our sales people have a bad habit of selling things that are not on the shelf, so I added the "In Stock" field to the sales order to show them what we actually can sell. Unfortunately, "In Stock" adds up everything in all the warehouses. Is there a way to only allow selling from 1 warehouse?
I thought of using a udf in the item row, and then copying the correct quantity into it. The problem I have there is I don't know how to access the itemcode for that particular row.
So, if anyone can give guidance on either of those, please do.
Thanks for any response,
Create a UDF in the marketing documents rows.
Link the query below to the field using formatted search.
Define auto refresh when item code changes , quantity or WH, depends on the order you enter the fields.
to link the query as formatted search place the cursor on the UDF and then press Shift +Alt +F2.
also make sure the WH code column is visible using the form setting icon - table format.
SELECT T0.OnHand FROM OITW T0 WHERE T0.ItemCode =$[http://$38.1.0|http://$38.1.0] and T0.WhsCode =$[http://$38.24.0|http://$38.24.0]