Simple ODF/XForms (OOo2/SO8) for UBL 1.0 Invoice
---------------------------------------------------------------
Here are (hopefully) fixed OpenOffice 2.0 (OOo2)
/ StarOffice 8.0 (SO8) Open Document Format /
XForms combination XML Forms to produce simple
UBL Invoices (without tax, etc at this stage of progress).
Only * for use at your own risk * but open source
(produced on behalf of the Open Source Academy).
The forms were actually produced with the first dev
version of OOo2 but are expected to work with the
production versions of OOo2 and SO8.
Notes:
I avoided including Country/IdentificationCode since
this would have warranted including a combo box with
country codes (similar to that I've included for currency
codes) and time constraints forbade this.
The Invoice produced should be UBL 1.0 Small Business
Subset (SBS) compliant in that it does not include any
essential extra subset data but the reader form only caters
for the same ultra simple Invoice and not the full SBS.
A nice improvement would be to aim to cater for the whole
SBS but constraints forbid me personally at present.
Another obvious improvement would be to add functionality
as it is added to the OOo2+/SO8+ XForms implementation.
Adding indirect tax capabilities would warrant (perhaps
necessitate) adding a disclaimer that the forms should only
be used in accordance with relevant tax authority and other
legal regulations (which are out of the scope of the input
form itself). For instance it may not be allowed that tax
registered businesses use UBL 1.0 as electronic XML files
for trading without local tax office permission.
NB:
The archives of these ubl-dev messages replace the
filenames with generated filenames, replacing the .odt
extensions with .bin extensions. I suggest saving the file
locally and changing the filename or at least the extension
back to .odt before attempting to open with OOo (2+) or
SO8 (8+) or an equivalent product which might be able to
handle the ODF/XForms combination.
All the best
Stephen Green
----- Original Message -----
From: "Stephen Green" <>
To: <>
Sent: Friday, December 23, 2005 10:43 AM
Subject: Re: [ubl-dev] Simple ODF/XForms (OOo2/SO8) for UBL 1.0 Invoice
Apologies folks, I found some errors in
my work (not surprised, just dismayed). The
'readonly' XML form isn't readonly, for a
start, and it shouldn't include the currency
combo box. The other XML form has a
readonly combo box. No idea how all that
happened (I'll blame it on the gremlins :-)
Anyway, I'm getting into constraint problems
from higher so, though I'll try to send out
improved versions, I may have my time on
this curtailed - in which case it'll be up to
others to fix things if they wish to use them
or take them further. I hope there's enough
done to give the idea though. Having such
forms available to as many as possible
('bridging the digital divide' as much as
possible) would be nice though...
By the way, a crazy idea I had was that
if folk don't have email access (like myself
out of working hours) what if those who
process invoices by scanning them were to
configure their OCR to read UBL (printed),
then folk could send printed UBL invoices
(etc) without the hassle of conversion to pdf
(if they've already a means to easily produce
UBL). Crazy?
All the best
Stephen Green
----- Original Message -----
From: Stephen Green
To:
Sent: Thursday, December 22, 2005 1:12 PM
Subject: Re: [ubl-dev] Simple ODF/XForms (OOo2/SO8) for UBL 1.0 Invoice
Please note that if you open these forms
from the web archive they will need the
filename extensions changing to .odt
Also, if you have unix/linux you'll need to
change the target filepath/url for the submission
and the same change for the linked file of the
readonly form. At present both point to
file:///c:/invoice.xml so they could be changed
to something like file:///home/invoice.xml (not
quite sure if this is correct).
It should be possible to create a simple UBL 1.0
Invoice with one form (saved locally) then use
the other form to read it (from where it is saved)
and convert it to pdf (OpenOffice 2 and Star
Office 8 have this facility). Then either or both
as appropriate could be sent say by email (for
micro/small businesses this might be OK - please
don't blame me if it isn't) as attachments and/or
imported somehow into a finance system or
spreadsheet (perhaps with an office product
macro, say). Note that the first form, if used to
directly create a pdf, will in OOo2/SO8, produce
a form that can be edited before printing and this
would be unacceptably risky for sending as an
Invoice. Again, please accept that the use of the
forms is at users own risk.
All the best
Stephen Green
PS Really loved Juha's UBL greeting customisation!
Peace and Goodwill to all -
And y'all Love the Almighty back with all you've got!
----- Original Message -----
From: Stephen Green
To:
Sent: Wednesday, December 21, 2005 7:07 PM
Subject: [ubl-dev] Simple ODF/XForms (OOo2/SO8) for UBL 1.0 Invoice
Folks,
Just in time for the holidays I've produced
(for 'Open Source Academy' but anyone can
use them if you do so at your own risk) a
couple of forms, one for input, the other for
reading and exporting to PDF, to produce
crude but possible useful UBL 1.0 invoices.
They would probably suit a micro business
and illustrate the ODF/XForms combination
used in OpenOffice 2 and StarOffice 8.
Please forgive the ultra-simplicity (there are
just 10 lines and I couldn't yet find a way to
not output lines when they are void of data).
I'd welcome feedback so I can improve these
(again as part of some open source work).
I hope the archive can accept the attachments,
sorry if this doesn't work - please ignore this
email then and I'll try another way later.
All the best and happy holidays.
Stephen Green
----------------------------------------------------------------------------
---------------------------------------------------------------------
This publicly archived list supports open discussion on implementing the
UBL OASIS Standard. To minimize spam in the
archives, you must subscribe before posting.
[Un]Subscribe/change address: http://www.oasis-open.org/mlmanage/
Alternately, using email: list-[un]
List archives: http://lists.oasis-open.org/archives/ubl-dev/
Committee homepage: http://www.oasis-open.org/committees/ubl/
List Guidelines: http://www.oasis-open.org/maillists/guidelines.php
Join OASIS: http://www.oasis-open.org/join/
----------------------------------------------------------------------------
--
---------------------------------------------------------------------
This publicly archived list supports open discussion on implementing the
UBL OASIS Standard. To minimize spam in the
archives, you must subscribe before posting.
[Un]Subscribe/change address: http://www.oasis-open.org/mlmanage/
Alternately, using email: list-[un]
List archives: http://lists.oasis-open.org/archives/ubl-dev/
Committee homepage: http://www.oasis-open.org/committees/ubl/
List Guidelines: http://www.oasis-open.org/maillists/guidelines.php
Join OASIS: http://www.oasis-open.org/join/
