Re: [ubl-dev] LegalMonetaryTotal.LineExtensionAmount

where you can find the interpretation of each information requirement

See for instance:

Name			Sum of line amounts
Usage			Sum of line amounts in the document. An invoice must contain the sum of all line amounts. The amount must be exclusive of VAT but inclusive of allowances or charges applied to the lines as well as taxes, other than VAT.

Name			Document total without VAT
Usage			The "Sum of line amounts" plus "sum of allowances on document level" plus "sum of charges on document level". An invoice must contain the total amount of the invoice, including document level allowances and charges but exclusive of VAT.

Name			Invoice line net amount
Usage			Each line in an invoice must contain the total amount of the line. The amount is “net” without VAT, i.e. inclusive of line level allowances and charges as well as relevant taxes, except VAT which must be excluded from the amount.

And here you have the mapping to UBL 2.1

ftp://ftp.cen.eu/public/CWAs/BII2/CWA16562/BII-SyntaxBinding-BiiTrns10-Invoice-UBL-v2_0_0.pdf

1..1 Document totals

tir10-054 1..1 Sum of line amounts Invoice/cac:LegalMonetaryTotal/cbc:LineExtensionAmount

tir10-057 0..1 Sum of allowances on document level Invoice/cac:LegalMonetaryTotal/cbc:AllowanceTotalAmount

tir10-058 0..1 Sum of charges on document level Invoice/cac:LegalMonetaryTotal/cbc:ChargeTotalAmount

tir10-055 1..1 Document total without VAT Invoice/cac:LegalMonetaryTotal/cbc:TaxExclusiveAmount

tir10-065 1..1 Invoice line net amount Invoice/cac:InvoiceLine/cbc:LineExtensionAmount

I hope this helps

Regards

Oriol

El 16/10/2013, a las 18:58, Danny Gaethofs escribió:

Oriol,

Are you saying that the charges and allowences on document level are not included in the LineExtensionAmount on document level ?

Is it stated somewhere ?

Regards
Danny Gaethofs

On Wednesday, October 16, 2013 6:09 PM, Oriol Bausà Peris <oriol@invinet.org> wrote:

Dear Danny,

You are right. The LegalMonetaryTotal.LineExtensionAmount is the sum of LineExtensionAmounts at line level.

The Allowances and charges from the example are document level. They have the same value, 100, and that is why the TaxExclusiveAmount equals LineExtensionAmount. TaxExclusiveAmount = LineExtensionAmount + ChargeTotalAmount - AllowanceTotalAmount.

Best regards
Oriol Bausà

El 16/10/2013, a las 12:41, Danny Gaethofs escribió:

Dear all,

Am I right when I say that the LegalMonetaryTotal.LineExtensionAmount = SUM OF THE LINE AMOUNTS

(taken from PEPPOL BIS 4A Guideline)

LineExtensionAmount = Σ LineExtensionAmount (at line level)

The amount for each line is stated in the Line Extension Amount and is defined as: The total amount for the Invoice Line, including Allowance and Charges but net of taxes.

Allowances and charges on the line are added to the LineExtensionAmount

For the calculation of the LegalMonetaryTotal.LineExtensionAmount an example is given which does not correspond with the definitions.

Am I overlooking something OR is the example really wrong ?

How is ubl using the LineExtensionAmount ?

For the sample document above these are:

Variable in calculation

Sample amounts

Element

Sum of line amounts

+

1436.50

LineExtentionamount

Allowance/discounts on document level

-

100.00

Allowances(Total)

Charges on document level

+

100.00

Charges(Total)

Invoice total amount without VAT

=

1436.50

TaxExclusiveAmount

VAT total amount

+

292.20

TaxAmount

Rounding of Invoice total

+

0.30

PayableRoundingAmount

Invoice total with VAT (value of purchase)

=

1729.00

TaxInclusiveAmount

Paid amounts

-

1000.00

PrepaidAmount

Amount due for payment

=

729.00

Payable amount

kind regards

Danny Gaethofs

ubl-dev message