How To: Add the Country Specific VAT Number to a Customs Invoice

WARNING: Before making changes to ANY of your Basic Report templates it is advisable to take a backup.

Basic Reports is an Advanced User feature.


When using Country Specific VAT, the country specific VAT number entered against the country in the [ System Data | International | Countries ] screen can be shown in Customs Invoices. In this example the Country VAT Number will be added in the Notes section in the bottom left.

Note: there is a hierarchy for which code will be displayed on an invoice as follows with the Country Specific VAT reference overriding all others:

  1. Country Specific VAT reference
  2. Brand specific VAT reference
  3. Default VAT reference from System Values


  1. Follow the menu route [ System Operations | Basic Reports Setup ] to open the "Basic Reports Setup" dialog.
  2. From the dialog's [ Reports List ] tab, double-click on "Customs Invoice Report".
  3. Focus on the Brand and then click on the Basic Reports Design button button to edit the Customs Invoice's report template using Report Builder Designer.
    Note: you can save the current layout with a new name so that you don't affect the invoice layout as you are updating it. It also means that you have a backup. To do this select Save As... from the file menu.
  4. First you will need to make room for the additional fields in the Notes section.
  5. Click on the Calc Note field to select it. There should be eight circles, one at each corner and one in the middle of each side, these are the resizing handles.
    Calc Note field in Basic Reports
  6. Click on the circle in the middle of the bottom line and drag and drop it up to make space.
    Note: if you make a mistake, close everything without saving and start again.
  7. Click on the Label Button in the top left toolbar.
  8. Click in the Notes/Special Instructions Area below the Calc Note field and position and resize the Label using the handles (the circles at the sides and corners).
  9. Make sure this label field is selected and in the Text section on the left, enter the caption Country VAT Number.
    Basic Reports Label for Country VAT Number
  10. Click on the Basic Reports Memo button button on the top menu.
  11. Click in the Notes/Special Instructions Area to the right of your label and position and resize the DBMemo field using the handles.
  12. Make sure the DBMemo field is selected.
  13. In the top right select calc_vat_number from the dropdown list:
    Calc VAT Number from DBBase
  14. If you are happy with the layout, save what you have done by going to File -> Save.
  15. Test the layout and make any adjustments as required.

See Also

Did you find this article helpful?