Formatted search : link a field from item master date into invoice
i like to see from the item master data , the Purchasing UoM in the A/R Invoice as a table field.
I tried it in many ways, but it doesn't work. maybe the sql statement is wrong.
could somebody help me?
Ok. The field is actually BuyUnitMsr
SELECT T0.BuyUnitMsr FROM [dbo\].[OITM\] T0 WHERE T0.ItemCode=$\[$38.1.0]