SQL Query for SAP Business One Business Partner

[Former Member]

Hello All,

is there are a possibility to copy the Bill to addresses for the empty Ship to addresses of the Business Partners via SQL query?

thank you and best regards

Serkan

[former_member583013 · Accepted solution]

Unfortunately NO.

[Former Member · Accepted solution]

You can use DTW templates to do this.

[Former Member · Accepted solution]

i tried allready,

i have imported the customers with the BP template with the the invoice address.

and then i transport the Ship to addresses as update with the Shpping address file. But than the system cancell the bill to addresses and behält only the ship to addresses..??

[Former Member · Accepted solution]

It can be done through DTW. You have to assign the right value to the field Address Type. So that the Bill to address will not be touched.

Thanks,

Gordon