InvoiceLine calculation questions

[Jordi Bosom i Valmaña <jbosom@tradise.com>]

Hi,

We are trying to calculate the LegalTotal for an Invoice processing the 
information stored in AllowanceCharges, TaxTotal, BasePrice,... and 
while doing this work we have found this questions:

Question 1

The description for the LineExtensionAmount in the InvoiceLineType and 
LineItemType says the following: "the monetary amount that is the total 
for the line item, including any pricing variation (allowances, charges 
or discounts) but not adjusted by any payment settlement discount or 
taxation. (equals BasePrice multiplied by Quantity)".

The text inside parenthesis is not coherent with the description, we 
think the right text should say something like that: "equals BasePrice 
multiplied by Quantity plus Line-AllowanceCharges".


Question 2

Inside every AllowanceCharge in an InvoiceLine or LineItem we have found 
the tag SequenceNumeric that indicates: "identifies the sequence in 
which all allowances or charges are calculated when multiple components 
apply one on top of another. If all are applicable to the same base 
price, the indicator will always equal one."
Our question is described with this example.

If we have a sequence with the following AllowanceCharges:

AllowanceCharge A with SequenceNumeric 1
AllowanceCharge B with SequenceNumeric 1
AllowanceCharge C with SequenceNumeric 2
AllowanceCharge D with SequenceNumeric 1

We can calculate the Amounts for the AllowanceCharges in two ways:

Way 1
Amount for AllowanceCharge A is ->
   A' = (Quantity * BasePrice) * MultiplierFactorNumeric

Amount for AllowanceCharge B is ->
   B' = (Quantity * BasePrice) * MultiplierFactorNumeric

Amount for AllowanceCharge C is ->
   C' = ((Quantity * BasePrice) + B') * MultiplierFactorNumeric

Amount for AllowanceCharge D is ->
   D' = (Quantity * BasePrice) * MultiplierFactorNumeric



Way 2
Amount for AllowanceCharge A is ->
   A' = (Quantity * BasePrice) * MultiplierFactorNumeric

Amount for AllowanceCharge B is ->
   B' = (Quantity * BasePrice) * MultiplierFactorNumeric

/***
We can't still calculate the amount for AllowanceCharge C
***/

Amount for AllowanceCharge D is ->
   D' = (Quantity * BasePrice) * MultiplierFactorNumeric

/***
Now we can calculate Amount for AllowanceCharge with SequenceNumeric 2 ***/

Amount for AllowanceCharge C is ->
   C' = ((Quantity * BasePrice) + A' + B' + D')* MultiplierFactorNumeric


Which way is the right one? or Is there any other interpretation of 
SequenceNumeric?

Thanks for your attention.

Best regards,

Jordi Bosom and Carlos Lozano




-- 
Jordi Bosom i Valmaña
Tradise
mailto:jbosom@tradise.com

--Avís--

Aquest missatge electrònic es dirigeix només al seu destinatari. Pot 
contenir informació privilegiada o confidencial i/o dades de caràcter 
personal regulades per la Llei Orgànica de Protecció de Dades i la Llei 
de Serveis de la Societat de la Informació. Si Vostè no n'és el 
destinatari, ha de saber que la seva lectura, còpia i ús està prohibida. 
Li preguem que ens avisi immediatament per aquesta mateixa via i que 
procedeixi a la seva destrucció. Les opinions, conclusions i la resta de 
informació inclosa en aquest missatge, que no estiguin relacionades amb 
assumptes professionals de Tradise, no estan recolzades per l'empresa.



--Aviso--

Este mensaje se dirige exclusivamente a su destinatario y puede contener 
información privilegiada o confidencial y/o datos de carácter personal, 
cuya difusión está regulada por la Ley Orgánica de Protección de Datos y 
la Ley de Servicios de la Sociedad de la Información. Si usted no es el 
destinatario indicado (o el responsable de la entrega al mismo), no debe 
copiar o entregar este mensaje a terceros bajo ningún concepto. Si ha 
recibido este mensaje por error o lo ha conseguido por otros medios, le 
rogamos que nos lo comunique inmediatamente por esta misma vía y proceda 
a su eliminación irreversible. Las opiniones, conclusiones y demás 
información incluida en este mensaje que no estén relacionadas con 
asuntos profesionales de Tradise no están respaldadas por la empresa.



--Notice--

This e-mail message is solely intended for its addressee and may contain 
confidential information. If you are not the addressee of this e-mail 
you should know that it is forbidden to read it, copy or use it. Please, 
notify us of receipt immediately via e-mail and delete it. Opinions, and 
other informations included in this message not related with Tradise 
professional activity will not be endorsed.