Skip to Content
0
Jul 13, 2018 at 12:41 PM

SAP B1 Intrastat - Commodity Codes

964 Views Last edit Jul 13, 2018 at 04:59 PM 2 rev

SAP B1 9.2

Update: Is it possible to import the commodity code for each stock item using DTW?

I used DTW to get the overall commodity codes imported.

****

I really need your help. I'm trying to import commodity codes into SAP B1.

I created a test code & exported it to get the file format.

But when I try import back into SAP it says the column 'code' is missing.

I'm using a csv file in this format

#,Code, Valid From, Valid To ,Description ,Supplementary Unit
1,83022000, 01.01.18, ,Test desc

Attached is the error when I try to import this record.

Can anyone advise how to import the commodity codes successfully?

Thanks, Eoin

com-codes.jpg

Attachments

com-codes.jpg (126.4 kB)