I am trying to create a Custom Field to pull the destination warehouse from Purchase Order Lines into Incoming Dispatch Advice but I keep getting this:
So far I have create this and not sure what is incorrect and wondered if someone could help?
Best answer by AkilaR
View original
+11
Hi
You have incorrectly mapped the Variables in the where condition. The view's columns should be the filtering condition, and the variable should be the custom field creation window’s columns. So the select query should be corrected as
Order_No = :Source_ref1
Line_No = :Source_ref2
Release_No = :Source_ref3
Regards,
Akila
Hi
Thanks again :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
