PLD "relate to" option

[Former Member]

Hi Expert,

I need to know how to use "relate to" on getting row data whereby I am making use of Basekey + BaseLine as the relate key in PLD.

Example:

I need to get the sale order date into the sales invoice printout wherey the sales invoice rows keep the basekey=docentry of DLN1 and baseline=linenum of DLN1. And I need to retrieve back RDR1 from DLN1 with the same way.

In SQL, I can make use of

select docdate from rdr1 where

convert(nvarchar(12),docentry) + convert(nvarchar(5),linenum) in

(select convert(nvarchar(12),baseentry)+convert(nvarchar,(5),baseline) from dln1

where convert(nvarchar(12),docentry) + convert(nvarchar(5),linenum) in

(select convert(nvarchar(12),baseentry)+convert(nvarchar(5),baseline)from inv1 where docentry = xxx)

)

Or is there anywhere shortcut way to directly get the info?

Thank you.

Regards,

Joan.

[Former Member · Accepted solution]

Hi John,

The "relate to" option on the PLD is not as strong as SQL query. It can only apply very simple direct link.

You would better to try some other tools like crystal report to manipulate data as you wish.

Thanks,

Gordon

[Former Member]

I think relate to can work in PLD, but if relateship is too many condition, it is very difficult to do that.

Give you a simple solution.

You can add a UDF and use FS to select the data.

Glen

[former_member187989]

hi joan lim,

What is process you follow to create sales invoice ?

Jeyakanthan