ANVEDI Document Summary

This table can be used to store footer information, like the totals, of an EDI document. This is especially useful for the export of invoice data, as Microsoft Dynamics NAV 2017 does calculate the totals on the fly. Storing this data before exporting will help to simplify your export mappings.

The table name has changed in version 5.00 of the module. The table was previously named EDI Document Summary Line.

Fields

Document Type

This field is part of the foreign key to table EDI Document.

Document No.

This field is part of the foreign key to table EDI Document.

Document Version No.

This field is part of the foreign key to table EDI Document.

Document Line No.

This field is part of the foreign key to table EDI Document Line.

Type

This field is part of the primary key. You can use this field, as you like, but we suggest to use the values like described below.

Sum

This summary represents a total sum of the document. (The integer value of this option in the database is 0)

Vat Entry

This summary represents a sum grouped by the VAT %. (The integer value of this option in the database is 1)

Tax

This value represents a general tax, described by the Code field. (The integer value of this option in the database is 2)

Other

This line is used to sum any other information. (The integer value of this option in the database is 5)

VAT %

This field is part of the primary key. This is intended to be used in combination with the Type field option VAT. This way you can group the information on the VAT percentage.

Code

Part of the primary key. Can be used in any way you like to. The field length is 20.

VAT Base

VAT base amount.

VAT Amount

VAT amount.

Amount Including VAT

Total amount including VAT.

Line Amount