[webERP-users] Shipping Address Label printing

[Terry P. <te...@tj...>]

Hi Phil, and All,

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:-

http://portertech.org/bb/viewtopic.php?f=22&t=52&p=58&sid=45ac99604ad3706ba2eee338527dc22a#p58

This post is only to mention that I have altered it slightly  to use the
customer postal address if the street address is not to be used for
shipping:-

Note, my program is written in Perl and requires Unix admin level skills to
deploy, so it's not for everyone, however its licensed under the GPL, and
is freely downloadable.

Summary of how to use the program

   - configure five items in the config section at the top of "
   find-client-shipping-details.pl". These are the details of your Mysql
   database and working directory etc.
   - run "find-client-shipping-details.pl" in a xterm
   - enter the Customer Branch ID number when asked
   - "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


Cheers
Terry

<http://expert-wifi.com>