Skip to Content
0

How can i update mass customer's price list through import/export utility?

Mar 11 at 09:04 AM

41

avatar image
Former Member

How can i update mass customer's "price list" in business partner master data through import/export utility?

What are the mandatory fields to fill in import/export template?

I built template including:

BP Code BP Name BP Type Group Code Price List No.

but received error messages start with:

- hexadecimal character...

- index was outside the bounds of the array...

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Mar 24 at 12:26 AM
0

Create new excel sheet with two columns (BP Code and Price List No), make sure to use column labels exactly matching the table field name

The header row should be duplicated as following example:

CardCode PriceList CardCode PriceList C000005 1

Save excel as Text deliminted

Import the text through DTW

Share
10 |10000 characters needed characters left characters exceeded