CompuServe Thread

Business Software

8 messages in this thread
#29201From: Dean BrownOct 13, 1992 10:55 PM
Rich, I am very interested in any accounting package that runs on the Amiga. I would much appreciate any information you could pass my way. Dean DKB Software
#29259From: Ken CooperOct 16, 1992 8:16 AM
H Dean, I noticed your comment about being interested in any accounting programs for the Amiga. $$$$$$$$$$$$$$$$$$$$ Here's a brief description of several programs, that I've written entirely in ARexx, as a personal project. The rexxarplib.library is used for screens/windows/gadgets. >>> Money.rexx (current working title), is about 141k bytes in size. An accrual/double entry accounting program used for basic bookkeeping: bills, checks, invoices, deposits, etc. Designed in layman's terms, but produces all the reports that Accountants love to see. Opens its own screen/window with various gadget blocks. Overscan Grey base with 3D gadgets with white hi-lites, dark shadow, black text. Mainly mouse driven. Selected buttons are yellow with blue text. There is a limit of 840 vendors. A panel can show 120 four character vendor names per panel, and each panel (up to 8) can be rotated into view randomly. Names added/subtracted on the fly. Pull-down menus (limit of 38 items per menu) for each of the Account Codes: Asset, Liability, Equity, Revenue and Expenses. There's also a Project menu and an "invoice" menu which makes consecutively numbered invoices. A config file controls how the month gadgets are displayed – depending when your fiscal year starts, whether you collect taxes, what year you want the Year gadgets to start at, location for temp files and location for the compressed backup of your data files, etc. Various search/find functions for locating data. Correcting errors is very easy. If you are behind, you can enter data for any fiscal year. Handles multiple companies, each with their own sets of data. No manual – hitting the HELP key calls up a window with 3 rows of gadgets running along the top of the screen. Each button describes some aspect of the program. Upon selection, specific text is then displayed below these buttons. [ MORE ]
#29260From: Ken CooperOct 16, 1992 8:17 AM
[ continuation ] Here are the 6 directories that Money.rexx uses to store/read data. All data files are in ascii. inc = contains all the transaction files incD = contains completed Data reports incP = contains each month's pending accounts Payable incR = contains each month's pending accounts Receivable incS = contains Support files incT = contains each month's Tax reports >>> Taxer.rexx at 11k bytes, is a small program that opens a window and communicates with Money.rexx. Used for adding taxes to a number, or to find what the taxes were, for a given amount. There is room to handle 2 different taxes, their names and rates pulled from the config file. >>> Loaner.rexx at 14k bytes is another program that opens a window on the Money screen that handles loan payments. >>> Reporter.rexx at 109k bytes, is used to produce various reports at monthend (or anytime) of: Balance Sheet, P&L Statement, Accounts Payable/Receivable (each showing detail & summary information), Job Journals, Audit Trail, Reconcilation Report, plus a few others. After selecting the month/year gadgets and then clicking "GO", a complete Data report is automatically made and stored, and to be printed out onto fanfold, at your leisure. AP or AR reports can be done at anytime, as long as all the raw data has been entered for the previous months. In Canada (I'm in Vancouver), one could get involved with collecting taxes, such as PST and GST. A Tax report can be done whenever. >>> Flipper.rexx at 3k bytes is a row of 7 gadgets that resides on the WorkBench screen, in the upper right corner. There is a similar row on Money.rexx and Calendar.rexx. This program checks for various port names, and if the ports are active, calls that screen to the front – or else runs that program. Currently I flip between WorkBench, CygnusEd, DiskMaster, Calendar, Money, plus a few others that float, depending on which screen [ MORE ]
#29261From: Ken CooperOct 16, 1992 8:17 AM
[ continuation ] I'm on. >>> Calendar.rexx, at 41k bytes, opens its own screen. The first window shows all the days of the current month in your usual grid manner. Year range is from 0 thru to 9999. (Original 5821 bytes of code from Mike Meyer). In each box, up to 5 flags or reminders are displayed. Upon clicking on a particular day, the 2nd detail window is brought forward, with the day broken up into 24 one hour buttons (each controlling the string gadget to its right). The setting of flags on the main window is done here. Any day can be encrypted. >>> Searcher.rexx, at 17k bytes, has 3 areas: search for text in the CalendarDB files, search for text anywhere on the harddrive, or use "Find" (Larry Phillips) to locate names of files/directories. Various gadgets are selected to set switches, and results are either sent to a WShell window or dumped into CygnusEd. In addition, there are maybe a dozen or so, other arexx script files that have specific functions and work in the background when needed. ——————————————- WB 2.04 is required. All the file sizes mentioned above are source files. Using the Dineen Edwards compiler on the major programs, would produce much larger binary files. All of these programs are pretty solid now. There is only one other person at present using these programs and her desk is next to mine 🙂 I hear about the rare bug report fairly quickly 🙂 I've tried to design an intergrated collection of programs, that are easy to use and work well. Perhaps not as fast were they written in C or Assembler, since my knowledge of these languages is zip! Payroll has not been tackled yet since I don't have any employees in my photography business. Charts/graphs should be incorporated somehow. So far two complete sets of fiscal years have already been put thru to my Accountant, with no mention of output error. Just your usual year-end [ MORE ]
#29262From: Ken CooperOct 16, 1992 8:18 AM
[ continuation ] adjustments for depreciation and such. With 3000+ hours invested in writing these puppies, I'm getting eager to making images again. Plus I've moved into a 3600 foot studio space the first of August and there is a lot of work to be done there. If I find that people are interested in my 'project' then I'll start to market the set, directly thru the mails.
#29274From: Dean BrownOct 16, 1992 8:46 PM
Ken, Thanks for the description of what you have done. It does seem as though I need a few things that your current system hasen't addressed such as manufacturing inventory, Purchase orders, and product inventory. Any system that I get would also need to be networkable as I have four-five people/stations that would need to access the data simultanously. I've come to the conclusion that I will need to go with a PC clone based system as nothing I've found in the Amiga market is yet capable of handling my needs. (I would love to be proven wrong though). Dean DKB Software
#29280From: Jonathan BlackwellOct 17, 1992 2:20 AM
Dean, everything that you have been requesting already exists! It is called SuperBase! i am sure that there are modules already written either with the Windows version of the Amiga version. And there's a bonus, it is networkable. You might want to contact OXXI and see what they can help you with….. -Jonathan
#29292From: Dean BrownOct 17, 1992 9:51 AM
Jonathan, Thanks, I'll call OXXI and check into it. Dean DKB Software