copy address

[Former Member]

Hi,

Is thr any way to copy the bill to address to ship to address, my customer feeling difficult to enter it 2 times... any ideas..

regards,

Vignesh

[Former Member]

Hi,

You can use a Formatted Search to do this.

Regards

[Former Member]

Hi,

Can u help in giving query for that...

regards,

Vignesh

[Former Member]

Hi,

This is an example and please read carefully:

1) You must ensure that they ALWAYS use the SAME address name for the Postal Address, because the query will retrieve the info, based on that name.

2) You will have to change the Address Name in the Query accordingly.

3) The query is written ONLY to retrieve the Street and you will have to customise this query for the other fields as well.

4) Remember they must FIRST add the Business Partner and find it again, before the Formatted Search will execute, because the information in the FS is retrieved from the SAP tables.

Please find the query below:

SELECT T0.[Street] AS 'Street'

FROM [dbo].[CRD1] T0

WHERE T0.[CardCode] = $[$5.0.0] AND T0.[Address] = 'POSTAL'

I hope it helps. If you need assistance, please ask again.

Kind regards

Carin