Data Import Error

[Former Member]

Hello ,

When trying to Import item Data, and update the barcode I get the following error message:

Row Number 1: Cannot set accounts for this item; set the Item Level method in the 'Set G/L Accounts By' field [Items - Pref. Qty in Purchase Units]

I have a file with just 2 columns:

J099-01-0760 123456

J001-01-0001 123456-12345

Thanks

Max

[Former Member · Accepted solution]

Hi Max........

Try this.......

Select the Code Bars Columns, Right click and Change the Format Cell of CodeBars Column to Text and then save the template and run through DTW.

Hope this will solve the problem......

Regards,

Rahul

[Former Member]

Hi Max,

Which two columns are you using?

Thanks,

Gordon

[Former Member]

Hi Gordon,

Item No. and BarCode

Thanks

Max

[Former Member]

123456-12345 is a barcode?

Have you checked the data map before final DTW?

[Former Member]

Its failing even on the first row.

I am trying this through the SAP Data Import interface

[Former Member]

Try a valid barcode: EAN or UPC.