Share This Post

NAV Updates

NAV Trade Report with Customers and Vendors

NAV Trade Report

In Microsoft Dynamics NAV Trade Report you must submit a periodic report of transactions with customers and vendors in certain countries/regions that the Italian government has identified in a blacklist.

The blacklist communication report must be submitted to the Italian Revenue Agency to help prevent VAT fraud. Transactions that are subject to blacklist reporting include the following:

  • Purchases of goods or services
  • Sales of goods or services

On a monthly or quarterly basis, you must generate the blacklist communication NAV Trade Report for transactions with countries/regions that have privileged taxation and send it to the Italian Revenue Agency.

The Italian Revenue Agency decides which countries/regions are included on the blacklist. You can view or change countries/regions on the blacklist by using the Countries/Regions window.

The periodic report includes only transactions that have an amount above a certain threshold. The threshold amount calculation is applied at the document level.

Before you can submit the periodic report, you must set up the Dynamics NAV Trade Report.

To update the relevant countries/regions

  1. Enter Countries/Regions, and then choose the related link.
  2. Choose the relevant country/region, and then select the Blacklisted check box.
  3. Enter the Foreign Country/Region Code for the blacklisted country/region.

For a list of relevant countries/regions and codes

To specify the current threshold amount

  1. Enter VAT Posting Setup, and then choose the related link.
  2. In the VAT Posting Setup window, choose the Blacklist Comm. Amount action.
  3. In the Blacklist Comm. Amounts window, fill in the fields as described in the following table.
     Field  Description
     Name  Specifies the name of the template, Blacklist.
     Description  Specifies a description of the template, Blacklist Communication.
     Form ID  Specifies the window where you set up the list of transactions for the blacklist communication, 12110.
     VAT Statement   Report ID  Specifies the report that prints the list of transactions for the blacklist communication, 12128.
     VAT Stat. Export   Report ID  Specifies the report that exports the list of transactions for the blacklist communication, 12129.
  4. Select the VAT Statement template, and then choose the Statement Names action. You can provide the template with a name and description. Otherwise, the template will have the name Default when you access it in the Blacklist Communication window.

Creating the List of Transactions

Depending on the size and type of company, you must generate and submit a NAV Trade Report of transactions with vendors in blacklisted countries/regions on a monthly or quarterly basis. A suggested mapping of transactions to Dynamics NAV accounts is provided in the following procedure, based on Spesometro 2013.

To set up the template to create the list of Blacklist transactions

  1. Enter Blacklist Communication, and then choose the related link.
  2. In the Name field, select the relevant VAT statement name.3. Fill in the lines with the relevant information as described in the following table.
     Field  Description  Data   Type
     Row No.  Specify a row number. To enable correct filtering, we recommend that you number rows as follows: 1001..1006, and so forth.  Code
     Description  Enter a description of the line. You can enter up to a maximum of 50 characters.

    The types of transactions that you are required to report include the sales and purchase of goods and services. These transactions can be taxable, non-taxable,   or exempt. Also subject to reporting are invoicing for transactions that are not subject to VAT.

    Finally, you must also include information for credit note transactions.

     Text
     Type  Specify the Type of the account that the blacklist report will include, for example,   VAT Entry Totaling.  Option
     Blacklist   Country/Region   Transaction  Select the check box to include information from VAT entries that originate with a   person or organization that has their residence in a blacklist country/region. In general, only select the checkbox when the Type of the line is VAT Entry Totaling.

    If the check box is not selected, Dynamics NAV only retrieves non-blacklist items.

     Boolean
     Gen. Posting   Type  Select a posting type. For the blacklist communication report, you can choose any   of the options, but typical choices are one of the following:

    Sale

    Purchase

    If you leave the field blank, Dynamics NAV will only return VAT Statement lines that have this field blank as well.

    If you choose the Type VAT Entry Totaling, then in this field, you can only choose among Purchase, Sale, and Settlement.

     Option
     EU Service  Specify whether the entry total represents sales of services to other EU   countries/regions.  Boolean
     Document Type  Specify a document type. You can choose any of the options, but typical choices   are one of the following:

    Invoice

    Credit Memo

    If you leave the field blank, then Dynamics NAV returns all document types.

     Option
     Refers To   Period  Specify what period the documents refer to. When you export data and you have not specified date, the setting in this field is ignored.

    If you have left this field blank, then Dynamics NAV returns those entries that have this field blank as well. In addition, it returns those entries that are without reverse sales for VAT Entry Totaling.

     Option
     VAT Bus.   Posting Group  Specify a VAT Business Posting Group. Fill in this field when the Type of the line is VAT Entry Totaling.

    If you leave this field blank, then Dynamics NAV returns entries with any specified group.

     Code
     VAT Prod.   Posting Group  Specify a VAT Product Posting Group. Fill in this field when the Type of the line is   VAT Entry Totaling.

    If you leave this field blank, then Dynamics NAV returns entries with any specified group.

     Code
     Amount Type  Specify the type of Amount that is being reported. Options include:

    Base

    Amount

    If you leave this field blank, then Dynamics NAV returns no information.

     Option
     Row Totaling  Specify which rows are to be totaled. For example, you can enter 1001..1006 to total those rows.  Text
     Round Factor  Specify a rounding factor that is used to round the VAT entry amounts.  Option
     Calculate with  Specify whether to calculate the amount with a sign or the opposite sign.  Option
     Print  Specify if you want to print information from the line.  Boolean
     Print with  Specify whether to include the sign of the amount when you print.  Option
     Blacklisted   Comm. Field  Specify the field that the VAT totaling should map to in the file to be exported.   Valid entries are limited to what is defined in the Spesometro 2013: BL003001 –   BL008002. Important: The Blacklisted Comm. field can contain only the currently required field names that are specified by Spesometro. If you specify another field name, Dynamics NAV account fields to the same Blacklist Comm.   Field value, the export of the data will be the sum of those lines. The printout will list each line.  Code
     New Page  Specify if you want to insert a new page after the line when you print the information.  Boolean

The printed NAV Trade Report includes all transactions that meet threshold requirements. It does not include those transactions that do not.

To create and print the list of transactions

  1. Enter Blacklist Communication, and then choose the related link.
  2. In the Name field, select the relevant VAT statement name.
  3. Fill in the lines with the relevant information. See the procedure for setting up the Blacklist template.
  4. Choose Print action.
  5. Optionally, on the VAT Statement Line FastTab, set the relevant filters.
  6. On the Options FastTab, fill in the fields as described in the following table.
     Field  Description
     Starting   Date  Optional. Enter the start date for the blacklist report, which is based on the date that the operations occurred.
     Ending   Date  Enter the end date for the blacklist report.
     Include   VAT Entries  Specify if the list of transactions must include open or closed VAT entries or both open and closed VAT entries.
     Include   VAT   Entries  Specify if the list of transactions must include VAT entries that are in the specified VAT period or must also include VAT entries that are from previous periods.
     VAT Period  Enter the time that defines the VAT period for the blacklist report.
     Source Type  Optional. Enter the source type of blacklist transactions. The options include Customer and Vendor. If nothing is selected, both groups are included.
     Source No.  If you choose a Source Type, then enter the identification number of the source transaction. If nothing is entered, then all vendors or customers are included.
     Name  Read-only. Specifies the name of the organization.
  7. Choose the Print button to print the report, or choose the Preview button to view the results.

To preview and export the list of transactions

  1. Enter Blacklist Communication, and then choose the related link.
  2. In the Name field, select the relevant VAT statement name.
  3. Fill in the lines with the relevant information. See the procedure for setting up the Blacklist template.
  4. On the Navigate tab, choose the Preview action. You can review the information to make sure that your mappings have provided you with the information that you expected.
  5. Choose the OK button to close the window
  6. Choose the Export action.
  7. Optionally, on the VAT Statement Line FastTab, set the relevant filters.8. On the Options FastTab, fill in the fields as described in the following table.
     Field  Description
     Starting Date  Enter the start date for the blacklist report.
     Ending Date  Enter the end date for the blacklist report.
     Include VAT   Entries  Specify if the list of transactions must include open or closed VAT entries or both open and closed VAT entries.
     Include VAT   Entries  Specify if the list of transactions must include VAT entries that are in the specified VAT   period or must also include VAT entries that are from previous periods.
     VAT Period  Enter the time that defines the VAT period for the blacklist report.
     Communication   Type  Enter the communication type for the blacklist export. The options include, Corrective and Cancellation.

    If you enter Corrective, then a full report will be generated for the specified period, but you have the option to overwrite a previously submitted report.

    If you enter Cancellation, then you have to provide the values from the previously generated report and a new report will be generated.

    You enter information about the corrective or cancellation action in the Substitution   Data group. Fill in the following fields, using information that was provided by the   Italian Revenue Agency (IVA) in its communication with you when you originally submitted   your blacklist report:

    – Substitution Report No.
    – Substitution Doc. No.

     Period Type  Specify if the report is monthly or quarterly.

    9. Choose the OK button.

    You can now submit the list of NAV Trade Report transactions to the Italian Revenue Agency. If you have more than 1500 records, multiple files will be exported.

Share This Post

Leave a Reply

avatar
  Subscribe  
Notify of
Skip to toolbar