6 Replies Latest reply: Feb 29, 2012 1:41 PM by Florian Böckenholt RSS

Intrastat Upload Commodity Codes

Chris Kroos
Currently Being Moderated

Hi,

I want to download commodity codes into Intrastat. How can I do that?

 

I did the following steps.

1) I downloaded the commodity codes from http://www.destatis.de/jetspeed/portal/cms/Sites/destatis/Internet/DE/Content/Klassifikationen/Aussenhandel/Content75/sova__leitdatei,templateId=renderPrint.psml

 

2) I created from the file a csv and txt file.

3) I selected this file under the menu Administration -> Setup -> Intrastat -> Configuration Tool -> Commodity Code -> Upload Code

4) I got always the error message file is in wrong format.

 

What is the correct format and how should it look lite. I have to give our customer a step by step guide that that can do that themselves.

 

Thanks and Regards Chris

  • Re: Intrastat Upload Commodity Codes
    Mario Schoenberg
    Currently Being Moderated

    Hi Chris,

     

    Simplest way to find out seems to be:

     

    1) Navigate to Administration -> Setup -> Intrastat -> Configuration Tool -> Commodity Code

    2) If no code available yet, enter two or three Codes manually, otherwise jump to step 4)

    3) Save them

    4) Export into Excel

    5) Compare the just exported file with the file you downloaded and adapted

    6) Adapt the downloaded file further.

    7) Try to upload it again.

     

    Kind regards

    Mario

    • Re: Intrastat Upload Commodity Codes
      Chris Kroos
      Currently Being Moderated

      Hi Mario,

      thanks for the fast reply.

       

      Unfortunately I do not have an export functionality. The tasbar button Excel does not give me the correct columns format.

       

      Even the xls file or the txt file is wrong.

       

      The txt file was readable now.

       

      If I open the file with Excel and save it under Tab Stop delimited and Text MS-Dos the file is not readable anymore.

       

      Regards Chris

  • Re: Intrastat Upload Commodity Codes
    Chris Kroos
    Currently Being Moderated

    Hi Mario,

    unfortunately this does not solve my issue as well.

     

    I already read this information but it does not help me in two points:

    - How to save the file?

    - How should this file looks like?

     

    Thanks and Regards Chris

    • Re: Intrastat Upload Commodity Codes
      Jose Antonio Castillo
      Currently Being Moderated

      Please follow this steps:

       

      1) When you are in configuration tool (comodity code tab)  you press the button 'EXPORT to EXCEL'

      2) You save it any where

      (This file is saved as Txt unicode) and contains the existing commodity codes, if any, of this database

      3) Select this file and open with excel:

      4) Add new records

      (very important, you should not leave in any row any column empty)

      5) Save the file

      6) In Configuration tool, commodity codes, press the button UPLOAD CODE

      7) Browse to the file saved in step 5) and select it

       

      You will receive a message telling that X records where updated and Y records failed to update: You should not worry about the Y records , because that referes to the Headers and pre existing records.

       

       

      Jose Antonio Castillo

      SAP Business One Support

Actions