>> Since the business is web printing and newspaper advertisments no inventory codes are involved. <<
No inventory? No ink, no paper is consumed? I assume that you mean
your job it out and provide only services as a middle man (I did that
in college, along with typesetting for high school and underground
No problem, but since when did any industry have an infinite record
retension schedule? Federal and State Archives are the only places I
have worked actually threw out nothing. That required microfilm in the
old days, and warehouses. Lots of warehouses.
This ad appeared in the May 22 2006 edition of the Yellowknifer
3 columns x 100 agates @ 1.00
Prices Slashed 300.00
Color charge Red 50.00
Goods & Service Tax 24.50
Invoice Total 374.50 <<
It is a bit hard to design a full job costing system in a newsgroup.
(I also had to look up agate line = 1/14", which does not match to the
Point system or Metric). But each one of the services is a detail with
a description. I remember that DEC had a classified ad system
(TypeSet-11) with a pretty good set of codes in its day. Use them to
replace the SKU in a regular retail operation.
I tend to favor a hierarchical encoding for production work, but leave
the price of penalty copy open for a manual entry.
How about using this magical universal form for passports and birth
certificates, too? Absurd! You have a forms control officier who is
not going to approve that kind of design. Hell, the legal boilerplate
for credit & debit memos has nothing whatsoever to do with invoicing,
and vice versa.
The same database might track all of these things, but you are once
again confusing the physical paperwork with the logical data.
You do about http://www.yqcomputer.com/
side of the house, do the right job. On the database side of the
house, do the job right. These days, you are not pre-printing most
forms anyway (email and laser printing, not ink); you do not need a
warehouse to store them.