How to insert data from base document into UDO Rows

[former_member183582]

Dear Experts:

I have a UDO which have two tables @OBCD (Header) and BCD1 (Row)

now @OBCD there is a based document selection of sales order number.

I want to add or insert all row numbers in BCD1 Table from sales order when user select the document number in header of UDO.

How can I achieve this scenario.

Thanks

[Former Member]

Hi Irfan,

You can achieve this by doing FMS and Inserting Sales Order Document no. Column on BCD1 Table.

On BCD1 Table you need to first Select the Sales Order no. and Related Item Code and Other fields of RDR1.

Thanx and Regds,

Dhanraj.

[former_member186605]

Irfan, Dhanraj,

Please be aware of the risks of such action, even if you're successful in execution.

Please see SAP note 896891 - Support Scope for SAP Business One - DB Integrity,

you'll loose support for this DB.

Best, Peter

[Former Member]

Hi Peter,

In above case we are just retrieving data.The Formatted search will have only "Select" Statement.

Haven't suggested any Update or Delete Statement.

Thanx and Regds,

Dhanraj Kotian.