how to upload "Pay to" address using DTW

[former_member207488]

hi all,

I have a doubt. Pls help me. Can any one tell me how to upload the pay to address using the DTW, because if we use the BP addresses template the ship to address is getting uploaded by default. how to upload the pay to address using DTW

regards,

Yeshwanth

[Former Member · Accepted solution]

Hi Yeshwanth,

Please check BP addresses template. There is an Address Type field which decide Bill-to or Ship-to. In your case, Bill-to should be read "Pay-to" because you are the Vendors' "Bill-to".

Thanks,

Gordon

[former_member207488 · Accepted solution]

hi Gordon Du

thanks for your idea.

please tell me what is the exact text to be filled in the address type field for the ship to and bill to addresses.

regards,

Yeshwanth

[Former Member · Accepted solution]

The field in Excel File is AddressType (Column F)

Valid values are:

bo_ShipTo

bo_BillTo

[Former Member · Accepted solution]

You can try:

Bill to - 'B'

Ship to - 'S' you don't need to fill it since it is default.

Thanks,