Hi all,
I need to put a trigger on table PurchaseLine such that if a record/line item is inserted on Purchase order, the [Quantity (Base)]=Quantity. How do I achieve this in AL??. I don’t want to do it in sql.
Kindly assist.
Not sure why you want you want to do this modification, when you enter a quantity on the purchase line the Quantity (base) automatically gets updated and if you have any unit of measure then the Quantity base will convert accordingly and update by itself.