[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [ubl-dev] Basic Invoice Exploration
My knowledge is a bit rusty (I've been out of finance work for a year or so now) but I think the LineExtensionAmount is the amount without VAT. The VAT is calculated (in my country at least - UK) on the total including allowances and charges (except those made dependant on payment terms like charges for late payment which do not affect the VAT calculation). Also in UK I think it is still true that the VAT cannot be altered once it is declared on an invoice so there are some things the LineExtensionAmount has to include and some things it doesn't. Anyway, AFAIK, it is the basis for VAT calculation so it doesn't itself include the VAT. All this is general accounting knowledge so doesn't get dicated by the language (UBL in this case) and does have to comply with whatever VAT rules apply to your invoice. I do accept that concepts like LineExtension have been floded into UBL and need a UBL explanation for what they entail - which I guess is at present just in the official UBL semantic definition (a bit sparce - could maybe be extended to include a general conceptual calculation model, albeit one which might have to be a default which gets overridden by local customs and rules). best regards Stephen D Green 2009/6/18 <jaymuz@optusnet.com.au>: > Hi Folks, > > I thought I would take a simple example of an invoice ans assume I am the seller and determine what the UBL-Invoice-2.0 doc might look like: > > The thread was on the front page. > > I am going to work through Kens answer and see if I can get the same. > > ########### > jazza | Tue, 2009-06-16 03:11 > Rosa it may be that you are on the same path as me. Or you may be further down the track. > > I am trying to take the following example and determine what the XML should be for it. > > I purchased for $AUD18.61 in total [incuding GST which is a national Australian tax payable bythe shopkeeper of 10% 2 light bulbs and a mouse trap for a pesky mouse that has popped into my office. > > I paid by electronic funds transfer. > > The seller was Bunnings Warehouse with ABN 26 008 672 179 phone 5467 5322 > > The items have a Sellers code, a Sellers Description, and a unti dollar price. > > The 2 light globes are listed on seperate liens thought they are the same. > > There is a Total line that says $18.61 and a line under it that says GST Included in the total $1.68. > > What is the XML for that invoice? > > Login or register to post comments > A UBL-schema-valid example invoice > gkholman | Wed, 2009-06-17 04:22 > Here is a rough cut at an example for your criteria. > > I hope this helps. > > . . . . . . . . . . Ken > > <?xml version="1.0" encoding="UTF-8"?> > <Invoice xmlns="urn:oasis:names:specification:ubl:schema:xsd:Invoice-2" > xmlns:cac="urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2" > xmlns:cbc="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2"> > <cbc:UBLVersionID>2.0</cbc:UBLVersionID> > <cbc:ID>12345</cbc:ID> > <cbc:CopyIndicator>false</cbc:CopyIndicator> > <cbc:IssueDate>2009-06-17</cbc:IssueDate> > <cbc:DocumentCurrencyCode>AUD</cbc:DocumentCurrencyCode> > <cac:AccountingSupplierParty> > <cac:Party> > <cac:PartyName> > <cbc:Name>Bunnings Warehouse</cbc:Name> > </cac:PartyName> > <cac:PartyLegalEntity> > <cbc:CompanyID schemeName="ABN">26 008 672 179</cbc:CompanyID> > </cac:PartyLegalEntity> > <cac:Contact> > <cbc:Telephone>5467 5322</cbc:Telephone> > </cac:Contact> > </cac:Party> > </cac:AccountingSupplierParty> > <cac:AccountingCustomerParty> > <cac:Party> > <cac:PartyName> > <cbc:Name>Jazza</cbc:Name> > </cac:PartyName> > <cac:Contact> > <cac:OtherCommunication> > <cbc:Channel>UBL.XML.org</cbc:Channel> > <cbc:Value>http://ubl.xml.org/users/jazza</cbc:Value> > </cac:OtherCommunication> > </cac:Contact> > </cac:Party> > </cac:AccountingCustomerParty> > <cac:PaymentMeans> > <cbc:PaymentMeansCode>46</cbc:PaymentMeansCode> > </cac:PaymentMeans> > <cac:TaxTotal> > <cbc:TaxAmount currencyID="AUD">1.68</cbc:TaxAmount> > </cac:TaxTotal> > <cac:LegalMonetaryTotal> > <cbc:LineExtensionAmount currencyID="AUD">18.61</cbc:LineExtensionAmount> > <cbc:TaxInclusiveAmount currencyID="AUD">18.61</cbc:TaxInclusiveAmount> > <cbc:PayableAmount currencyID="AUD">18.61</cbc:PayableAmount> > </cac:LegalMonetaryTotal> > <cac:InvoiceLine> > <cbc:ID>1</cbc:ID> > <cbc:InvoicedQuantity>1</cbc:InvoicedQuantity> > <cbc:LineExtensionAmount currencyID="AUD">3.61</cbc:LineExtensionAmount> > <cac:Item> > <cbc:Description>Mouse Trap</cbc:Description> > </cac:Item> > <cac:Price> > <cbc:PriceAmount currencyID="AUD">3.61</cbc:PriceAmount> > <cbc:BaseQuantity>1</cbc:BaseQuantity> > </cac:Price> > </cac:InvoiceLine> > <cac:InvoiceLine> > <cbc:ID>2</cbc:ID> > <cbc:InvoicedQuantity>1</cbc:InvoicedQuantity> > <cbc:LineExtensionAmount currencyID="AUD">7.50</cbc:LineExtensionAmount> > <cac:Item> > <cbc:Description>Light globe</cbc:Description> > </cac:Item> > <cac:Price> > <cbc:PriceAmount currencyID="AUD">7.50</cbc:PriceAmount> > <cbc:BaseQuantity>1</cbc:BaseQuantity> > </cac:Price> > </cac:InvoiceLine> > <cac:InvoiceLine> > <cbc:ID>3</cbc:ID> > <cbc:InvoicedQuantity>1</cbc:InvoicedQuantity> > <cbc:LineExtensionAmount currencyID="AUD">7.50</cbc:LineExtensionAmount> > <cac:Item> > <cbc:Description>Light globe</cbc:Description> > </cac:Item> > <cac:Price> > <cbc:PriceAmount currencyID="AUD">7.50</cbc:PriceAmount> > <cbc:BaseQuantity>1</cbc:BaseQuantity> > </cac:Price> > </cac:InvoiceLine> > </Invoice> > > Login or register to post comments > Ask this again on UBL-Dev to get broader feedback > gkholman | Tue, 2009-06-16 05:01 > I suggest you post your scenario to UBL-Dev ... please see http://www.oasis-open.org/mlmanage/ for how to register. > > There are volunteers there who can post an answer, and it is the end of my day with a busy day tomorrow teaching so I can't get to my suggested answer until tomorrow evening. I would also be interested to see how others choose to instantiate your example. > > But as I said in http://ubl.xml.org/forum/basic-picture#comment-10 there is no definitive answer as there is no community definition of how UBL is to be used in your scenario. > > To see the way Denmark uses UBL see: > > http://www.oioubl.info/guidelines/en/OIOUBL_GUIDE_TOTALS.pdf > > ... but it was pointed out to me that OIO has incorrectly documented their use of TaxExclusiveAmount. > > I hope this helps. > > . . . . . . . . . Ken > > ################### > > --------------------------------------------------------------------- > To unsubscribe, e-mail: ubl-dev-unsubscribe@lists.oasis-open.org > For additional commands, e-mail: ubl-dev-help@lists.oasis-open.org > >
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]