EP lookup error

SDauren

Hi, everybody.
I have a problem with Employee Portal, when I want to lookup locationlist on salescard header, i receive an error like this "Navision error (10500): A ')' is missing in TableView. ORDER(Ascending) WHERE(Use As In-Transit=CONST("No"))", how to correct this error?
Please, Help me. Thanks in advance for everybody.

i4tost

In codeunit 6828 you should create a new function which will use a record which is a main for this report.
For example your report is based on table 18 (Customer). So you need to create function called CustomerBased and when you call report by using this function.
I hope it is clear

SDauren

i4tost wrote:

In codeunit 6828 you should create a new function which will use a record which is a main for this report.
For example your report is based on table 18 (Customer). So you need to create function called CustomerBased and when you call report by using this function.
I hope it is clear

Hi, thanks for replying but I'm asked about lookup button on the salesorder card.

i4tost

I believe that you have mismatch in setup means you wrote some value that is not correct. As i understood you try to link different tables.