Data import for BP

[Former Member]

Hi,

i had tried to import data OF BP from txt file it showing error that invalid BP currency and BP type But i had given

BP Currency as INR and BPType as C

what is Problem?

Regards

Srinivas

[former_member187989]

jkaanthan at gmail dot com

[former_member187989]

Send me BP excel sheet to mail id

I'll test it & let you know about results.

What is your SAP B1 Version & patch level ?

Jeyakanthan

[former_member187989]

what is relation between import from excel & dtw ?

Jeyakanthan

[Former Member]

BP currency should be double checked to ensure it is INR.

Thanks,

Gordon

[former_member187989]

BP Type should be

C u2013 Customer S u2013 Vendor L u2013 Interested party

(The entries must be upper-case)

Check whether you correctly mapped columns in sap b1 with

datas in excel sheet.

Jeyakanthan

[Former Member]

BP CardType should be:

cCustomer The business partner is a customer.

cSupplier The business partner is a vendor.

cLid The business partner is a Lead.

[former_member583013]

The BP Type value should be

cCustomer

cSupplier

cLid

The best way to know some of these valid values would be to point your mouse on the Red triangle on the column header and you should be able to see the valid values.

The same information is also available in the SDK Help files

[Former Member]

Hi Sudha

Thnking for your replay

But again i Got Error

Error is

"Character number is greater than allowed [Business Partner - BP Type] , 'cCustomer'"

Regards

Srinivas

[former_member583013]

Could you paste a few rows of your data (only columns that have value)

Use the Code Tag so that you can maintain the alignment.

[Former Member]

Hi sudha

This is first row

BP Code BP Name BP Currency BP Type Group Code Bill-to Street Bill-to Block Bill-to Building/Floor/Room Bill-to Street No. Bill-to City Bill-to Zip Code Bill-to State Bill-to County Telephone 1 Mobile Phone Fax Number E-Mail Contact Person Telephone 2

1220000088 SIEMENSLIMITED INR cCustomer 100 SIEMENSLIMITED SATHAK CENTRE NO.4 MAHATMA GANDHI ROAD NUNGAMBAKKAM CHENNAI 600 034 TAMILNADU INDIA

Regards

Srinivas

[former_member583013]

Are the States defined in the System. You have TAMILNADU as a whole? Should it not be the Code for TamilNadu..something like TN

[Former Member]

HI,

But Error is showing at Bp TYpe and Bp Currency

Regards

Srinivas

[former_member583013]

If your Local Currency/System Currency is INR, you may leave the BP Currency column Blank.

Make sure the DTW version you are using is for the Patch level you are currently on.

Suda

[Former Member]

Hellow Sudha,

I am using Data Import Not DataTransferWizard

Regards

srinivas

[former_member583013]

DTW (Data Transfer Workbench) is what I would recommend to use for this. I am not sure about the Data Import

[Former Member]

Data Import from excel has lots of restrictions. Only simple dataset can be imported this way.

Thanks,

Gordon