Retrieval of country on sales and purchase order lines (EU Reporting)

Related topics

It is important to understand how From-country and To-country are set since they are used to retrieve the correct VAT handling code on order lines.

Retrieval of VAT handling code on sales order lines

From-country and To-country are used to retrieve the correct VAT handling code on the sales order line. The system retrieves the VAT handling code in the following order:

  • If the VAT based field on the Sales order line panel is set to YES, the system searches in the following order to find the correct VAT handling code:
    • the VAT handl code sales field in the Item file (Country/country VAT information panel) for the entered item. If nothing found
    • the Default prod sales field in the Country/country VAT table. If nothing found
    • the Default sales field in the DIS control file (the DMR90004 panel)
  • If the VAT based field on the Sales order line panel is set to NO, the system searches in the following order to find the correct VAT handling code:
    • the VAT free sales code field in the Item file (Country/country VAT information panel) for the entered item. If nothing found
    • the Default VAT free field in the Country/country VAT table. If nothing found
    • the Default VAT free field in the DIS control file (DMR90004 panel)

To find the VAT handling code from the Item file (Country/country VAT information panel) and the Country/country VAT table, the system needs to know from and to which country the items are delivered. See Retrieve the country on a sales order line (EU Reporting) for scenarios.

Retrieval of VAT handling code on purchase order lines

From-country and To-country are used to retrieve the correct VAT handling code on the purchase order line. The system retrieves the VAT handling code in the following order:

  • If the VAT based field on the Purchase order line panel is set to YES, the system searches in the following order to find the correct VAT handling code:
    • the VAT handl code purch field in the Item file (Country/country VAT information panel) for the entered item. If nothing found
    • the Default item purch field in the Country/country VAT table. If nothing found
    • the Default purchase field in the DIS control file
  • If the VAT based field on the Purchase order line panel is set to NO, the system searches in the following order to find the correct VAT handling code:
    • the VAT free purch code field in the Item file (Country/country VAT information panel) for the entered item. If nothing found
    • the Default VAT free field in the Country/country VAT table. If nothing found
    • the Default VAT free field in the DIS control file

To find the VAT handling code from the Item file (Country/country VAT information panel) and the Country/country VAT table, the system needs to know from and to which country the items are received. See Retrieve the country on a purchase order line (EU Reporting) for scenarios.

Related topics