Customer Listing: with addresses
City Ledger Customer Listing YOUR HOTEL 7:29PM Jan 7'10 Pg1
4M 01
4M CORP FERGUSSEN SUPPLIES
JERRY
936 EDWARDS STREET 104 E 7TH STREET
GLEN ROVEN NC 27215 FREEMONT CA 94555
422-555-1212 415-555-1212
26 02
ACE HARDWARE DAWSON CONSTRUCTION
DESIGN DEPT
71 KANSAS AVE 400 FIRST STREET
EVERETT WA 98201 BAYFIELD CO 81122
206-555-1212 403-555-1212
10 03
ALABAMA FASHION BANK OF AMERICA
DIANNE
7895 OAK STREET 802 E MAIN STREET STE 202
PALMERDALE AL 35123 NEW YORK NEW YORK 10111
302-555-1212 201-555-1212
13 04
ALASKA CARGO SAMSUNG INDUSTRIAL
AR DEPT ACCOUNTS PAYABLE DEPT
55 E MAIN 78 E MINISOTA STREET
SAN JOSE CA 95123 CHARLESTOWN IN 47111
404-555-1212 204-555-1212
FOR PILOTS ONLY, GET PILOT EMPLOYEE NUM
AA 05
ANDERSON AND ANDERSON TRI-DESIGN CO INC
JENI
303 E COLUMBUS 409 E FOURTH STREET
ALLOUEZ WI 54301 UTICA MI 48317
654-555-1212 409-555-1212
.
.
.
AutoClerk lists every account twice. On the left the accounts are listed in alphabetical order, and on the right side accounts are listed by account number order. This list is usually used by the accounting, and the sales department.
Customer Listing: without addresses
City Ledger Customer Listing YOUR HOTEL 7:30PM Jan 7'10 Pg1 (4M) 4M CORP (01) FERGUSSEN SUPPLIES (26) ACE HARDWARE (02) DAWSON CONSTRUCTION (10) ALABAMA FASHION (03) BANK OF AMERICA (13) ALASKA CARGO (04) SAMSUNG INDUSTRIAL (AA) ANDERSON AND ANDERSON (05) TRI-DESIGN CO INC (99) BAD DEBTS (06) NYCOM RESEARCH GROUP (03) BANK OF AMERICA (07) CONAIR INC (08) BANTOM BOOKS INC (08) BANTOM BOOKS INC (46) BEASTWAY LEASING CO (09) CONNOR PRIOR AND GREEN (28) CARTER INDUSTRIAL (10) ALABAMA FASHION (C ) COMPLIMENTARY (11) THOMAS MAYBURN CO (07) CONAIR INC (12) MUNDAY AND COLLINS (09) CONNOR PRIOR AND GREEN (13) ALASKA CARGO (02) DAWSON CONSTRUCTION (14) STATE APPLIANCE CO (DD) DEPT OF ENERGY (15) RUSHING & TACKLE INC
This list is usually used by the front desk.
NOTE: The left column is sorted alphabetically by customer name and the right
column is sorted alphabetically by city ledger code.
Below is a sample of AutoClerk's exporting the names and address from the city ledger into ASCII delimited text.
"4M","4M CORP "," ","936 EDWARDS STREET ","GLEN ROVEN NC ","27215 ", "422-555-1212 "," "," 0.000000000000000"," 4.749500000000001E2"," 8.000000000000000E2","N","5485","-800""26","ACE HARDWARE ","DESIGN DEPT ","71 KANSAS AVE ","EVERETT WA ","98201 ", "206-555-1212 "," "," 0.000000000000000"," 0.000000000000000"," 8.000000000000000E2","N","0","-800"
"10","ALABAMA FASHION "," ","7895 OAK STREET ","PALMERDALE AL ","35123 ", "302-555-1212 "," "," 0.000000000000000"," 0.000000000000000"," 8.000000000000000E2","N","0","-800"
"13","ALASKA CARGO ","AR DEPT ","55 E MAIN ","SAN JOSE CA ","95123 ", "404-555-1212 ","FOR PILOTS ONLY, GET PILOT EMPLOYEE NUMBER "," 0.000000000000000", " 7.515500000000000E2"," 8.000000000000000E2","N","5485","-800"
AutoClerk can even export the city ledger information to ASCII delimited text. That means that almost any other program such as Q&A, Dbase, Microsoft Access, or Word Perfect. They can then use this data to create mailings, and analysis.