Basic Invoice Exploration

[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 

###################