Some time ago, I made up a program to print shipping address labels from the webERP database (to suit my own needs). My blog of the process is located at my advert/junk free website below for anyone who is interested:-
"find-client-shipping-details.pl" then queries your WebERP Mysql
database using the Customer Branch ID number and fetches the customer
name, phone number address data etc. It does this read-only and doesn't
affect the integrity of your database
the details will be printed on the xterm
A Lyx window will pop up, click the icon with two large eyeballs (print
preview), then a XPDF (or your default PDF viewer) window will open and
display what the printed sheet will look like, if it's correct, click
print and your shipping sddress label will then be printed ready for you
attach to your customer shipment carton etc.
Note 1: all customer shipping data is converted to CAPS for printing clarity
Note 2: in the webERP "Add/Modify/Delete Customer Branches" menu, there
are two address entry areas, 1) Street Address and 2) Postal Address.
If Postal Address 1 has data then Postal Address 1 - Postal Address 5
fields are used, if not, then Street Address 1 - Street Address 5 are
used in the printed label. This is because if your customer doesn't
want goods shipped to his street address, then he will want it shipped
to his postal address instead. It will be one or the other
From: [hidden email] [mailto:[hidden email]]
Sent: 08 January 2016 18:29
To: For the general discussion of webERP project
Subject: [webERP-users] is there a manual on one page?