Config / Data/Buffer Tables / ANVEDI Document Summary

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 365 Business Central 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

This field can be used in any way. This is a Decimal field.

Inv. Disc. Base Amount

This field can be used in any way. This is a Decimal field.

Invoice Discount Amount

This field can be used in any way. This is a Decimal field.

Quantity

This field can be used in any way. This is a Decimal field.

Calculated VAT Amount

This field can be used in any way. This is a Decimal field.

VAT Difference

This field can be used in any way. This is a Decimal field.

Allowance Amount

This field can be used in any way. This is a Decimal field.

Charge Amount

This field can be used in any way. This is a Decimal field.

Charges/Discounts Amount

This field can be used in any way. This is a Decimal field.

Description

This field can be used in any way. This is a Text field of length 50.

Prepaid Amount

This field can be used in any way. This is a Decimal field.

Due Payable Amount

This field can be used in any way. This is a Decimal field.

Deprecated Fields

The following fields are removed in version 5.00 of the module and are not available anymore. If you want to update an existing system and you’re using the FOB-Version of the module, you can keep the old buffer tables. If you’re using the Extension you might want to add some of the fields back using a custom extension.

In new projects we recommend to use the EDI Adress/Contact and EDI Additional Information to store the information.

VAT Identifier

This field can be used in any way. This is a Code field of length 20.

VAT Calculation Type

This field can be used in any way. This is a Option field. The value does not affect any logic of the module.

Normal VAT

(The integer value of this option in the database is 0)

Reverse Charge VAT

(The integer value of this option in the database is 1)

Full VAT

(The integer value of this option in the database is 2)

Sales Tax

(The integer value of this option in the database is 3)

Use Tax

This field can be used in any way. This is a Boolean field.