------------------------------------------------------------------------------ JAY'S A/R - Accounts receivable system for dBase III PLUS This runs best off a hard disk. You will need to modify the MENU.PRG to set the default drive. It will support credits to an invoice or to an unapplied credit for the customer. It unfortunately does not support partial payments from the payment to invoice option. You must edit invoices if partial payments are received. You should NOT get the error message "Too many files are open",if you do,then set your config.sys to files=20 and buffers=25. The only place you can expect this program to be buggy is the option that prints statements for ALL customers. It will not print the first customer,it will start on the second one. It will then print all customers statements(unless they have a 0 balance),but will go to an EOF dBase error message. Just answer No and it will drop you to the dot prompt. This program includes 4 binary files which are called and run from within the program. The assembly language version is included also. ---------------------------- JAY'S OFFICE SUPPLIES,INC.----------------------- 824 Camino Del Rio North - #329 San Diego,CA 92108 voice (619)295-6053 data (619)291-5682 Accounts Receivable Users Manual Page 1 To start up: a)Put dBASEIII+ program disk in drive A (or copy to hard disk) b)Put AR program disk in drive B (or copy to hard disk) c)Type DBASE MENU to start program. ~~~~~~~~~~ Important...If the main menu appears scrambled,there is a simple way to fix it. If you do not have graphics installed in your computer,the main menu will not display correctly. To use this program you should get dBase up to the dot prompt then enter the command DO B:FIXTXT this will remove the 4 ASCII text files,and replace them with alternates. Sample data in files: There are 9 sample customers and 25 invoices for them in this program. To delete a customer choose option 6-(Edit account),to delete an invoice choose option 2-(Edit invoice). With the cursor on the record you want to delete,press Ctrl and U keys at the same time. Then run the option that removes the paid invoices,and both of your databases will have all of the records you have marked for deletion totally removed. If you want to clear the sample databases,enter the following commands: USE CUST ZAP USE INV ZAP Then enter your own customer names. !! Be CAREFUL of the ZAP command-it empties a database. ~~~~~~~ Page 2 End of month notes: Before running bulk statements you should remove the paid invoices from the invoice file.If you don't,it will run slower,and paid invoices are not shown on the statement anyway. Use option F8 of the sub-menu to do this. These paid invoices are saved in a database called PAID.DBF if you should ever need to check on them. Before running bulk statements for all customers,be sure to update balance for all customers,then sort the invoice file by using option F4 of the sub-menu. Regarding the order of the customer labels print: Our account numbers are really character fields in order to allow for accounts such as 181A,181B,181C etc. Because of this when you enter an account with a small number,it will still be at the bottom of the file. You can access the file CUST.DBF, and will find a field named NUMBER. Rearrange your customers in the order you want them to appear by changing the number field,then sort the file on the NUMBER field to TEMP. Then copy TEMP to CUST,re-index the whole thing on the account field. The proper syntax for this command is as follows: USE CUST BROWSE FIELDS ACCT,NAME,NUMBER (when done press Ctrl W or Ctrl End to save) SORT ON NUMBER TO TEMP USE TEMP COPY TO CUST USE CUST INDEX ON ACCT TO ACCT Access to DBASE: a)From a dot prompt you can always access the "ASSIST" mode of DBASE with the F2 key,this gives you total access to the database files b)The F1 key is a complete on-line tutorial for DBASE c)All of the rest of the function keys are reassigned by the menu. Forms for your printer: This program is designed to run on forms with a paper width of 9 1/2". All forms with the exception of the past-due mailers and the mailing labels are on standard blank computer paper. If you decide you would like to have custom printed statement forms,please contact us for pricing. The past due mailers are Tops brand # 5062 Our price is $49.95/box of 350 The 2-wide labels are Avery brand # 4143 Our price is $8.95/box of 2000 Labels form width is 9 1/2" We can ship these and many other products to you from 1 of 8 warehouses located across the nation. Drop us a note and we will send you a free catalog with over 20,000 office and computer related products.