Re: [Gnumed-devel] Billing/invoicing for GNUmed

[Sebastian Hilbert]

Am Sonntag 06 Juni 2010, 22:34:37 schrieb Sebastian Hilbert:

It currently works as root. This is a permission problem. I guess the user 
cannot write into /usr/lib/lx-office-erp

There is two solutions. First is to tell it to output the tex file a location 
the user has write access or run as root.

Running as root is not really an option.

If anyone wants to play around with it I can provide a fully configure vmware 
image of Debian Squeeze/Testing

A command line to create an invoice and pipe it to pdf
----------------------------------------------
debian:/usr/lib/lx-office-erp# ./is.pl 
"path=./bin/mozilla&id=1&action=print&type=invoice&media=queue&format=pdf&queued=&printed=&emailed=&title=Rechnung+bearbeiten&vc=customer&discount=&title=Rechnung+bearbeiten&creditlimit=0.00000&creditremaining=-17.85&tradediscount=&business=&closedto=&locked=&shipped=&storno=0&storno_id=&max_dunning_level=&dunning_amount=&shiptoname=&shiptostreet=&shiptozipcode=&shiptocity=&shiptocountry=&shiptocontact=&shiptophone=&shiptofax=&shiptoemail=&shiptodepartment_1=&shiptodepartment_2=&message=&email=&subject=&cc=&bcc=&taxaccounts=1776+&cursor_fokus=&convert_from_do_ids=&convert_from_oe_ids=&customer_id=901&oldcustomer=Evik+Kneevel--901&selectcustomer=1&forex=1&exchangerate=1&1776_rate=0.19000&1776_description=Umsatzsteuer&1776_taxnumber=1776&follow_up_trans_id_1=1&follow_up_trans_type_1=sales_invoice&follow_up_trans_info_1=EK03-2706%2F2010+%28Evik+Kneevel%29&follow_up_rowcount=1&lizenzen=1&customer=Evik+Kneevel--901&customer_klass=0&customer_id=901&oldcustomer=Evik+Kneevel--901&selectcustomer=1&AR=1400--
Ford.+a.Lieferungen+und+Leistungen&selectAR=%3Coption+selected%3E1400--Ford.
+a.Lieferungen+und+Leistungen%3C%2Foption%3E%0D%0A%3Coption%3E1445--
Ford.a.LuL+z.allg.USt-Satz+o.eines+Kleinuntern.
%28E%C3%9CR%29%3C%2Foption%3E%0D%0A%3Coption%3E1446--Ford.aLuL+z.erm.USt.-
Satz+%28E%C3%9CR%29%3C%2Foption%3E%0D%0A%3Coption%3E1447--
Ford.a.steuerfr.od.nicht+steuerb.LuL+%28E%C3%9CR%29%3C%2Foption%3E%0D%0A%3Coption%3E1448--
Ford.a.LuL+n.Durchschnittss.gem.
%C2%A724UStG%28E%C3%9CR%29%3C%2Foption%3E%0D%0A%3Coption%3E1450--
Ford.a.LuL+n.Durchschnittss.gem.
%C2%A724UStG%28E%C3%9CR%29%3C%2Foption%3E%0D%0A%3Coption%3E1400--Ford.
+a.Lieferungen+und+Leistungen%3C%2Foption%3E%0D%0A%3Coption%3E1445--
Ford.a.LuL+z.allg.USt-Satz+o.eines+Kleinuntern.
%28E%C3%9CR%29%3C%2Foption%3E%0D%0A%3Coption%3E1446--Ford.aLuL+z.erm.USt.-
Satz+%28E%C3%9CR%29%3C%2Foption%3E%0D%0A%3Coption%3E1447--
Ford.a.steuerfr.od.nicht+steuerb.LuL+%28E%C3%9CR%29%3C%2Foption%3E%0D%0A%3Coption%3E1448--
Ford.a.LuL+n.Durchschnittss.gem.
%C2%A724UStG%28E%C3%9CR%29%3C%2Foption%3E%0D%0A%3Coption%3E1450--
Ford.a.LuL+n.Durchschnittss.gem.
%C2%A724UStG%28E%C3%9CR%29%3C%2Foption%3E%0D%0A&taxzone_id=0&department_id=&fxgain_accno=&fxloss_accno=&shippingpoint=&shipvia=&transaction_description=&employee_id=861&salesman_id=861&invnumber=EK02-2606%2F2010&invdate=06.06.2010&duedate=06.06.2010&donumber=&deliverydate=&ordnumber=&orddate=&quonumber=&quodate=&cusordnumber=&globalproject_id=&webdav=0&runningnumber_1=1&partnumber_1=3&description_1=Gesundheitszeugnis+ausf%C3%BChrlich+neu&qty_1=1%2C00&price_factor_id_1=&unit_1=Stck&sellprice_1=15%2C00&sellprice_pg_1=--
&discount_1=0&unit_old_1=Stck&price_new_1=0&orderitems_id_1=&bo_1=&pricegroup_old_1=&price_old_1=0&id_1=907&inventory_accno_1=&bin_1=&partsgroup_1=&partnotes_1=&income_accno_1=8400&expense_accno_1=3400&listprice_1=15%2C00000&assembly_1=0&taxaccounts_1=1776&ordnumber_1=&transdate_1=&cusordnumber_1=&longdescription_1=&basefactor_1=1&marge_absolut_1=0%2C00&marge_percent_1=0%2C00&marge_price_factor_1=&lastcost_1=15&serialnumber_1=&project_id_1=&reqdate_1=&runningnumber_2=2&partnumber_2=&description_2=&qty_2=0%2C00&price_factor_id_2=&unit_2=kg&sellprice_2=0%2C00&discount_2=0&unit_old_2=&price_new_2=0&orderitems_id_2=&bo_2=&pricegroup_old_2=&price_old_2=0&id_2=&inventory_accno_2=&bin_2=&partsgroup_2=&partnotes_2=&income_accno_2=&expense_accno_2=&listprice_2=&assembly_2=&taxaccounts_2=&ordnumber_2=&transdate_2=&cusordnumber_2=&longdescription_2=&basefactor_2=&marge_absolut_2=0%2C00&marge_percent_2=0%2C00&marge_price_factor_2=&lastcost_2=0&serialnumber_2=&project_id_2=&reqdate_2=&notes=&intnotes=&payment_id=&marge_total=0&marge_percent=0&datepaid_1=&source_1=&memo_1=&paid_1=&AR_paid_1=1000--
Kasse&paidaccounts=1&selectAR_paid=%3Coption%3E1000--
Kasse%3C%2Foption%3E%0D%0A%3Coption%3E1200--
Bank%3C%2Foption%3E%0D%0A%3Coption%3E8731--
Gew%C3%A4hrte+Skonti+7%25+USt%3C%2Foption%3E%0D%0A%3Coption%3E8735--
Gew%C3%A4hrte+Skonti+16%25%2F19%25+USt.%3C%2Foption%3E%0D%0A%3Coption%3E8750--
Gew%C3%A4hrte+Boni+7%25+USt.%3C%2Foption%3E%0D%0A%3Coption%3E8760--
Gew%C3%A4hrte+Boni+16%25%2F19%25+USt.%3C%2Foption%3E%0D%0A%3Coption%3E8780--
Gew%C3%A4hrte+Rabatte+7%25+USt.%3C%2Foption%3E%0D%0A%3Coption%3E8790--
Gew%C3%A4hrte+Rabatte+16%25%2F19%25+Ust.
%3C%2Foption%3E%0D%0A%3Coption%3E1000--
Kasse%3C%2Foption%3E%0D%0A%3Coption%3E1200--
Bank%3C%2Foption%3E%0D%0A%3Coption%3E8731--
Gew%C3%A4hrte+Skonti+7%25+USt%3C%2Foption%3E%0D%0A%3Coption%3E8735--
Gew%C3%A4hrte+Skonti+16%25%2F19%25+USt.%3C%2Foption%3E%0D%0A%3Coption%3E8750--
Gew%C3%A4hrte+Boni+7%25+USt.%3C%2Foption%3E%0D%0A%3Coption%3E8760--
Gew%C3%A4hrte+Boni+16%25%2F19%25+USt.%3C%2Foption%3E%0D%0A%3Coption%3E8780--
Gew%C3%A4hrte+Rabatte+7%25+USt.%3C%2Foption%3E%0D%0A%3Coption%3E8790--
Gew%C3%A4hrte+Rabatte+16%25%2F19%25+Ust.
%3C%2Foption%3E%0D%0A&oldinvtotal=15&oldtotalpaid=0&formname=invoice&language_id=&format=pdf&media=screen&rowcount=2&callback=is.pl%3Faction%3Dadd%26type%3Dinvoice&draft_id=&draft_description=&customer_discount=0&gldate=06.06.2010&login=tux&password=linux">/home/tux/invoice.pdf

The information provided so far should make it possible to create invoices in 
the Lx-Office-database and have them available as pdf. 
I see no problem feeding that back into GNUmed.

As for the error management. When calling the command line it will return 
database errors such as customer ids not being unique.

Sebastian