Importing Masters through SAP B1 Import Export Utility

[former_member407652]

Hi guys,

I am using Import and export utility to import BPs and Items. If anyone has used it please tell me if there any issues / future implications regarding it or it is just ok.

Thanks and regards

Pardeep

[former_member187989]

hi pradeep,

Only limited amount of columns(limited no. of data) can be

imported through the import from excel.

Date from excel should be mapped exactly with

as with columns and fields in Import from excel for both BP/Items.

Excise and other tax information in BP can't be uploaded

through import from excel,this can be possible in DTW.

Excisable,Material Type,Chapter ID and assesable value

can't be uploaded through import from excel,this is also not

possible in SAP B1.

You need to set warehouses manually if

"Auto add all warehouse to New Warehouses" is not ticked,this

is possible in DTW using template oWarehouses.

Considering above limitations you can better opt for DTW

to import datas to SAP B1.

Jeyakanthan

[former_member583013]

Pardeep,

The Data Import and Data Export options within SAP is just another way to import/export data.

There is going to be no Implecation or problems by importing data using this tool.

Good luck

Suda