Hello experts,
Want to ask again, it is possible to get the value of ItemCode in RDR1 even if I'm just creating a new transaction?
Here's my query :
SELECT T0.[Price] / 1.12 as Price, T0.[ItemCode] FROM ITM1 T0 WHERE T0.[ItemCode] = --I want to get the ItemCode from ChooseFromList Here --AND T0.[PriceList] = 1
Thanks,