Data Import\Export

[#1]

Hi,

I am having an issue when using Data Import\Export - Import from Excel function.  I'm using this feature to import new items.  One of the import fields is 'Purchase Item [Yes/No]'.  The stock items are being created under the 'Item Master Data' but the 'Purchase Item' is not being ticked. In the excel sheet I have set the 'PurchaseItem' cell as tYES. On the other hand 'Stock Item' and 'Sales Item' are being ticked.

We are currently running on 8.82 PL08.

Feel free to send your suggestions.

Thanks!

[KennedyT21]

Hi ...

Does the Issue has been closed or Not. If closed Mark Correct or Helpful answer and close the Tread which might be very helpful to others.

Regards

Kennedy

[bcini]

No, the client would still like to use the Import and Export utility rather than DTW.  Did you managed to replicate the same issue Kennedy?

Thanks

[dagivar_lebesby]

Hello, this is an old post but I'm facing the same problem. Did you ever resolve this issue?

Thankful for any replies.

I can use DTW but it should work with import/export utility.

Regards

Dag-Ivar

[KennedyT21]

Hi Cini Bernard...

If you are using the DTW the you should Use tYES or  tNo but for Import and export Use Y or N

Regards

Kennedy

[bcini]

Hi Kennedy,

I'm using the Import\Export utility.  In the text file I have set the Purchase Item field as Y and still not being ticked in the Item Master Data.  Strangely enough the Stock Item and Sales Item are being ticked.

Feel free to send your feedback.

[KennedyT21]

Hi  Cini Bernard ...

Why dont you try with the DTW is simple and easy to import data

Regards

Kennedy

[kothandaraman_nagarajan]

Hi,

Use Y in that field.

Please refer below for further information.

The following fields for items can be imported into SAP Business One and can therefore be contained in the Microsoft Excel file:

Field Name	Max. Length	Data Type
Item No.	20	Alphanumeric
Item Description	100	Alphanumeric
Description in Foreign Lang.	100	Alphanumeric
Group (1)	20	Alphanumeric
Bar Code	16	Alphanumeric
Tax Definition	1	Y – Liable to pay tax N – Not liable to pay tax Entries must be upper case.
Price List Code (3)	6	Numeric
Price in the Price List	17	Numeric
Currency of the Price List	3	Alpha (in accordance with the defined currencies in SAP Business One)
Sales Account	15	Alphanumeric
Expense Account	15	Alphanumeric
Regular Vendor (4)	20	Alphanumeric
Vendor Catalog Number	17	Alphanumeric
Unit of Measure for Purchasing	5	Alphanumeric
Quantity per Purchase Unit	20	Numeric
Unit of Measure for Sales	5	Alphanumeric
Quantity per Sales Unit	20	Numeric
Target Warehouse Inventory in Purchasing Unit	20	Numeric
Minimum Warehouse Inventory	20	Numeric
Purchasing Item (5)	1	Y – Yes N – No Entries must be upper case.
Sales Item (5)	1	Y – Yes N – No Entries must be upper case.
Warehouse Item (5)	1	Y – Yes N – No Entries must be upper case.
Fixed Assets	1	Y – Yes N – No Entries must be upper case.
Brand (6)	30	Alphanumeric
Customs Group (7)	20	Alphanumeric
Sales Factor 1	20	Numeric
Sales Factor 2	20	Numeric
Sales Factor 3	20	Numeric
Sales Factor 4	20	Numeric
Purchasing Factor 1	20	Numeric
Purchasing Factor 2	20	Numeric
Purchasing Factor 3	20	Numeric
Purchasing Factor 4	20	Numeric

Additional fields are available for importing information on length, width, height, weight and volume. You can also import the packaging unit and the quantity per packaging unit for an item.

Re (1)

If the imported group has not been defined in the system yet, the system automatically creates a new group.

Re (2)

If items that are liable for tax are involved, the default tax groups for the items defined under G/L account determination are used.

Re (3)

The price list with this number must already exist in the system. Therefore, you may have to define the corresponding price list before the import.

Re (4)

If no master record for the imported regular vendor exists yet in the system, the system will automatically add it during the import.

Re (5)

If these fields do not contain entries during the import, the system automatically adds the master records as purchasing, sales, and warehouse items.

Re (6)

If the imported brand has not been defined in the system yet, the system automatically creates a new brand.

Re (7)

The customs groups specified for the import must be defined in SAP Business One before the import. If one of the customs groups in the Microsoft Excel table has not been defined in the system, you will not be able to import the data.