Share via


Invoice Date Field, VAT Report Line Table

Specifies the date of the original document that this line is based on.

The value of the field depends on the date that the underlying transaction occurred, and it determines whether the line is included in the VAT transactions report.

Additional Information

If the line is based on a posted invoice, the Invoice Date field is set to the posting date of the invoice.

If the line is based on a credit memo, then the invoice date depends on the Refers to Period field, and on whether the credit memo is applied to an invoice. The following table describes the scenarios for credit memos.

Scenario Impact

A credit memo is applied to a single invoice.

The Refers to Period field is set to Current Calendar Year.

The Invoice No. field will be set to the document number of the invoice.

The Invoice Date field will be set to the date that is specified in the Operation Occurred Date field.

Microsoft Dynamics NAV will deduct the credit memo amount from the amount of the original invoice. If the resulting amount is above the threshold, both the invoice and the credit memo will be included in the VAT transactions report. If the resulting amount is below the threshold, neither the invoice or the credit memo will be included in the VAT transactions report.

A credit memo is applied to multiple invoices, or it is not applied.

The Refers to Period field is set to Current Calendar Year.

The Invoice Date field will be set to the last day of the year that is specified in the Operation Occurred Date field. For example, if the Operation Occurred Date field is 11/15/12, the Invoice Date field will be set to 12/31/12.

Only the credit memo will be included in the VAT transactions report.

A credit memo is applied to multiple invoices, or it is not applied.

The Refers to Period field is set to Previous Calendar Year.

The Invoice Date field will be set to the last day of the year before the date that is specified in the Operation Occurred Date field. For example, if the Operation Occurred Date field is 11/15/12, the Invoice Date field will be set to 12/31/11.

Only the credit memo will be included in the VAT transactions report.

Tip

For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.

Parent Tables

Table Location
VAT Report Line Table General Ledger
VAT Report Line Table General Ledger

See Also

Tasks

How to: Create Electronic VAT Transactions Reports

Concepts

Italian VAT