Import Customs Invoices (lpesp0230m000)

Use this session to import the data from the CSV file provided by the user. This CSV file is downloaded from the Spanish tax authority (AEAT) portal.

One customs invoice is created for each Customs ID document (DUA number) and the other properties. In case of duplicate invoices, the amount is combined and added to the single customs invoice.

Note: 
  • This session can be accessed only if the Spain check box is selected in the Implemented Software Components (tccom0100s000) session.
  • You can also access this session using the Import Customs Invoices option from the Actions menu in the Customs Invoices (lpesp0130m000) session.

Field Information

Financial Company

The code of the financial company in which customs invoice is created.

Note: This value must be of type Financial or Both.
Customs Business Partner

The code of the customs business partner for whom customs invoice is created.

Note: This value is defaulted from the Customs Business Partner field in the Spanish Parameters (lpesp0100m000) session.
Name

The name of the customs business partner.

Selection Range
Customs Reference ID

The From and To fields define a range of: unique reference IDs of the customs invoice.

Import File
Separator

The character that separates the columns of the CSV file. It is recommended to use a semicolon (;) as the delimiter, because the comma (,) can also be part of the data.

File on Server

If this check box is selected, you must specify a location on the server from where the CSV file is imported.

Import File

The name of the CSV file on the server to be imported.

Note: This field is enabled only if the File on Server check box is selected.
Options
Overwrite Existing Records

If this check box is selected, the existing customs invoice data is updated with the data that is imported in the new CSV file.