Skip to main content

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?

 

 

Hi @lisa.gilesAB,

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 @AkilaR  thanks so much, I have made the changes and this now works as expected.

 

Thanks again :)

Reply


Terms & ConditionsCookie settings