[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: RE: [ubl-dev] UBL 2.0 Order document with discounts and VAT calculations
Thanks for looking into this issue with us.
You suggest to look into the 'calculation model' of a document. For the moment we (wehkamp.nl) are both the sender and the receiver of the document. So we could determine these calculation models our self.
Below I have put an indented version of your message with some changes to it.
Here are some remarks about your proposal:
The documentation says for LineExtensionAmount the following:
The total amount for the Line Item, including Allowance Charges but net of taxes
So I think that should be 50 (40 Euros for the Item and 10 for the DisposalCharge).
In your example you show a TotalTaxAmount of 8 Euro under the LineItem component, but there is no specification of what kind of Tax it relates to.
I also think it should have been 10 Euros because that is the total tax amount of this LineItem (8 for the Item, 2 for the disposal charge)
The Tax for the disposal charge can be specified under the AllowanceCharge line under the LineItem. So the problem that I see is that there is no place to put the Tax details for the 8 Euro VAT of the Item. There is no TaxTotal element under the Price component and also not at a higher level directly under the LineItem component.
So what other options do I have to correctly communicate the VAT details (Category, Percentage, Amount) of the OrderLine/LineItem? This should be there for information purposes so that it could be shown to the recipient of the order. I know that the Tax details at OrderLine level are for information purposes, but now I have no way to put this information in the UBL document at all.
And now that I think about it a bit more … even if there were no disposal charges or discounts, how can I communicate the Tax Details (Category, Percentage, Amount) at line level for information purposes?
======================== Indented Example =======
<!-- ===== Price Component ===== -->
<!-- ===== AllowanceCharge for the Discount ===== -->
<!-- ===== AllowanceCharge for the Disposal Charge ===== -->
<!-- ===== TaxTotal for the Disposal Charge ===== -->
======================== Indented Example =======
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!)
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).
---------- Forwarded message ----------
How about this?
Stephen D Green
On 15 December 2011 10:33, Duvekot, Kees <email@example.com> 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
> 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
> 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.
> Kees Duvekot
> IT Business Consultant