PLD data base

[former_member522789]

Hello

I am with the Delivery note PLD and I want a field which is on ORDR or RDR1 and theses tables are not lpart of the table shown with the data base... how to get fields outside the list shown in the PLD for a specific doc?

Thank you

[Former Member · Accepted solution]

Hi

There's no direct relationship between those tables, the ORDR and RDR1 are not exposed to the Delivery document.

What you could do is (depending which information you need) is created an UDF (User Defined Field), create a query and assign a FMS (Formatted Search) to that UDF.

Doing that you will be later on able to get the UDF's fields in the PLD.

Paulo Calado

SAP Business One Forums Team

[Former Member]

Hi G. DELANOE,

As Paulo mentioned, in order to get fields outside the list shown in the PLD, you can use UDF and FMS.

Take your case for example. I assume that you need the information in the base Sales Order to be displayed in the certain Delivery. If it is the case, the base document information is stored in Delivery - Rows (DLN1 ) table -> Base Document Reference.

Please refer to the following detailed steps:

1. Create UDF on Marketing Documents - Rows

2. Link the following query to the UDF in Delivery, retrieving information from ORDR.

SELECT XXX FROM ORDR T0 WHERE T0.[DocNum] = $[dln1.baseref

You can change XXX to the field you want to retrieve.

3. Similarly, if you want the corresponding RDR1 information to be retrieved, you can INNER JOIN RDR1 with ORDR.

4. In that case, you should be able to display the UDF information in Delivery PLD.

Hope this helps.

Regards, Summer

SAP Business One Forums Team

Edited by: Summer Ding on May 27, 2008 8:26 AM