Fwd: [ubl-dev] UBL 2.0 Order document with discounts and VAT calculations

[Stephen D Green <stephen.green@documentengineeringservices.com>]

Just realised I didn't copy this to the list. (I think the 'charge'

needs some added identification as a delivery charge too.)

 

By the way, Kees, would it be appropriate in your scenario

to seek a common agreement between users of your documents

on the way you use UBL? It is usually advised to do this for

what we call the 'calculation model' of a document. See the

recent example I posted to ubl-comment showing how to do

so in technical jargon using XPath expressions and appropriate

markup like Test Assertion Markup Language (that's a plug!)

http://lists.oasis-open.org/archives/ubl-comment/201112/msg00000.html 

A bit of a complex way to do it and maybe using just the model

behind the markup here (try Test Assertions Model by OASIS'

TAG TC) and prose descriptions of calculation rules might better

suit your scenario (then individual developers can test some

other way such as using Schematron). 

Best regards

Steve
---
Stephen D Green

---------- Forwarded message ----------
From: Stephen D Green <stephen.green@documentengineeringservices.com>
Date: 15 December 2011 11:30
Subject: Re: [ubl-dev] UBL 2.0 Order document with discounts and VAT calculations
To: "Duvekot, Kees" <kduvekot@wehkamp.nl>

How about this?

 

 ...

<cac:TaxTotal>

<cbc:TaxAmount currencyID="EUR">10.00</cbc:TaxAmount>
<cac:TaxSubtotal>
<cbc:TaxableAmount currencyID="EUR">50.00</cbc:TaxableAmount>
<cbc:TaxAmount currencyID="EUR">10.00</cbc:TaxAmount>
<cac:TaxCategory>
<cbc:Percent>20</cbc:Percent>
<cac:TaxScheme>
<cbc:TaxTypeCode>Dom-H</cbc:TaxTypeCode>
</cac:TaxScheme>
</cac:TaxCategory>
</cac:TaxSubtotal>
</cac:TaxTotal>
<cac:AnticipatedMonetaryTotal>
<cbc:LineExtensionAmount currencyID="EUR">100.00</cbc:LineExtensionAmount>
<cbc:TaxExclusiveAmount currencyID="EUR">50.00</cbc:TaxExclusiveAmount>
<cbc:TaxInclusiveAmount currencyID="EUR">60.00</cbc:TaxInclusiveAmount>
<cbc:AllowanceTotalAmount currencyID="EUR">60.00</cbc:AllowanceTotalAmount>
<cbc:ChargeTotalAmount currencyID="EUR">10.00</cbc:ChargeTotalAmount>
<cbc:PayableAmount currencyID="GBP">60.00</cbc:PayableAmount>
</cac:AnticipatedMonetaryTotal>
<cac:OrderLine>
<cbc:Note>goods</cbc:Note>
<cac:LineItem>
<cbc:ID>1</cbc:ID>
<cbc:SalesOrderID>A</cbc:SalesOrderID>
<cbc:LineStatusCode>NoStatus</cbc:LineStatusCode>
<cbc:Quantity unitCode="KM">1</cbc:Quantity>
<cbc:LineExtensionAmount currencyID="EUR">100.00</cbc:LineExtensionAmount>
<cbc:TotalTaxAmount currencyID="EUR">8</cbc:TotalTaxAmount>
<cac:Price>
<cbc:PriceAmount currencyID="EUR">100.00</cbc:PriceAmount>
<cac:AllowanceCharge>
<cbc:ChargeIndicator>false</cbc:ChargeIndicator>
<cbc:Amount currencyID="EUR">60.00</cbc:Amount>
</cac:AllowanceCharge>
</cac:Price>
<cac:Item>
<cbc:Description>Item A</cbc:Description>
</cac:Item>
</cac:LineItem>
</cac:OrderLine>

 ...

 

Best regards

 

Steve

---

Stephen D Green

 

 

 

On 15 December 2011 10:33, Duvekot, Kees <kduvekot@wehkamp.nl> wrote:

> UBL enthusiasts,

>

> We are working on implementing a UBL order document for internal use at

> wehkamp.nl. I have some questions about how to handle discounts in relation

> to VAT calculations.

>

> Here is the simple order I want to handle in a UBL order document. (this is

> just an example expressing the most important parts, not the actual order)

>

> A customer wants to buy a single “Item A”. The normal price for this article

> is 100 EUR ex VAT for a single Item. With this buyer we have agreed a

> discount of 60 EUR ex VAT. So the buyer needs to pay 40 EUR ex VAT for this

> article. The VAT category on this item is Domestic-High and the VAT

> percentage is 20%.

>

> For every “Item A” that is sold we also need to charge the customer for a

> “Disposal Charge”. This is 10 EUR ex VAT. For this charge the VAT category

> is also Domestic-High and the VAT percentage is 20%.

>

> So the orderline on the order should look like this to me:

>

> Article Unit    Price           Discount        Net     VAT     %       VAT

> Amt

>

> Item A  1Pc     100 EUR -60 EUR 40 EUR  Dom-H   20%     8 EUR

>

>         Disposal charge                 10 EUR  Dom-H   20%     2 EUR

>

> Now I am trying to bring all this information into the OrderLine/LineItem

> component.

>

> The Article and Quantity ordered can be place inside the Item component

> under the LineItem component

>

> The Disposal charge can be placed in a AllowanceCharge component directly

> under the LineItem component. The VAT of this disposal charge can be

> specified inside the AllowanceCharge component under the TaxTotal and

> TaxCategory components.

>

> Now the “problem” starts with the price component. If I look at this

> component I could place the net amount of 40 EUR in the PriceAmount

> component and the 60 EUR discount as an Allowance under the AllowanceCharge

> component. But where do I leave the VAT over the 40 EUR? And where do I

> place the standard price of 100 EUR of the item?

>

> Any help and guidance is appreciated.

>

> Regards,

>

>

> Kees Duvekot

>

> IT Business Consultant

>

> wehkamp.nl