Re: [LUG] Billing/Invoice formats

[kevin <kevin.lucas@xxxxxxxxxxxxxxxxxx>]

I have been playing with 
OpenBravo POS 

which is a point of sale system in Java.
I am just waiting for some hardware from Ebay to test the final set up before using it in the Tearooms at minions.


The same lot also do an http://www.openbravo.com/ open bravo ERP 
whatever that is ?

My needs don't go to managing the Star ship but I do have to process around Fifty different invoices each week all in a different formats

The same info is on each thought that I feel are essential
Co Name
Date
Invoice No
Listing of goods
Vat grouping  ie Standard, Zero, Low and Exempt
Net total 
Total invoice inc Vat
Their Vat reg details.
Terms of supply.

To process I use a web form php and MySql
The only problems I get is when invoices are for many separate categories which I designate as Split and then use a Spread sheet to enter each line of the invoice the input the totals in the web form.
 






On Sun, 2009-03-29 at 13:42 +0100, Neil Williams wrote:
> On Sun, 29 Mar 2009 13:17:38 +0100
> Tom Potts <tompotts@xxxxxxxxxxxxxxxxxxxx> wrote:
>
> > > - System
> > > 	- Produces pretty pages and creates pdf for emailing
>
> > Thats what I want to avoid - with proper data interchange these should be 
> > pointless. No more 'here have a pretty document to print out so someone can 
> > type it into our system. I used to parse text documents into an ERP system 
> > and then some fwit decided DOCs and then PDF would be more fun.
>
> I've looked for various means of doing this many times before - no
> standard exists and the range of values that might need to be supported
> is too long to make a sensible standard - it would need to be a
> multi-layer standard. Even just a split between a wholesale invoice
> and a service invoice would be a start.
>
> > But there are no XBRL codes for invoices etc - this seems to be at too micro a 
> > level  for XBRL which surprises me with this anal government of ours! They 
> > dont want to know you've bought 67,000 widgets just how much they get to tax 
> > you on it. Theres a whole space to be filled here - and if we can do it Open 
> > then thats good for FLOSS in general.
> > I think you defined half of whats needed above!
>
> It's the other half that is the problem.
> :-)

Regards

Kevin Lucas
Minions Post Master(Sub) reprieved (possibly!)
Po House, Minions,
Liskeard Cornwall
PL14 5LE
01579363386

-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html