Import: How do I create custom reports?

Prerequisite for configuring your own data extract or creating a subscription:

• You have the role I_CLIENTADMIN. If no user in your company has this role yet, please request it from AEB Support.

1. Go to Office > Master data > Data extract definitions.
2. Use the New button to create your own data extract. Alternatively, duplicate an existing data extract and amend the existing information.
3. Assign an Abbreviation and add a Description.
4. Select one of the following as the Start object:
   • Customs declaration
   • Summary declaration
   • IMPOST declaration
   • Assessment of duties and taxes
   • Log entry
5. Depending on the Start object selected, different extraction levels will be available.
6. Choose your required output format: CSV, JSON or XML.

Format options

If selecting the CSV or JSON format, switch to the CSV format options or JSON format options tab and amend the predefined information if necessary.

Configuring data via field selection

On the Field Selection tab, you can specify which data should be included in the data extract.

CSV format:

• Select a field in the right-hand pane, and use the left arrow button to add that field to your data extract. Use the up and down arrows to change the order of selected fields. All added fields are marked with a green tick. You can use the search field to find specific fields.
  
  Once you have added a field, you can customise the name on the left-hand side under Extracted column name. This will later appear as the column heading in your data extract.
  

JSON or XML format

• Use the Add or Add all buttons to add the fields you want to include in your data extract. The order and hierarchies will be retained.
  
  You can customize the label for the selected field using the Change JSON name or Change XML name button.