Set territory for busniess partner

[Former Member]

I am importing business partners using excel i.e

Administrator ->Data import/export - > Data Import -> Import from Excel -> BP

All the default fields are getting imported properly.I want to import territory of business partner.I added territory in the list of columns and imported it.But the code of business partner is getting replaced by terriotory.The terriotory field is blank and I can see territory name at code.

[former_member583013 · Accepted solution]

Dilip,

The Territory Field is not available for mapping in the Excel Import option you are trying. Only limited fields are exposed through this option for import.

You might have to import this data using DTW. DTW seem to be the only option in this case.

Please remember, when you do the field mapping in DTW, you will need to enter the <b>territryID</b> not the <b>Name</b>. Similar to Sales Person code.

territryID can be found in OTER table. Please query this table to get territryID.

Best wishes

Suda

[former_member186095]

How pity you are. Have you mapped the territory in the import from excel form ? in what row is the territory ?row A, B or what ?

That's why I suggest you to use DTW. Since I see there is no territory in the rows. It is more complete rather than the form. DTW is an addon. It is purposed to be used in the master data import. If SBO 2005A did not have territory, I think it will be as same as 2005B. try to read more carefully this thread :

Rgds,