Petty cash formulas

1

Hi there Clarion buddies.
I need to know if anyone can send me a formula for a petty cash procedure with
CF totals, BF totals and totals etc.

Kind regards

2

There’s a formula? That’s, standard, everywhere?
Sorry, that sort of thing tends to be very much a local thing as to what gets included or not.

3

I would have the database structured like so:

                        Year Totals File/Table YYYY
                                  | 1
                                  | 
                                  |
 Quarterly Totals File/Table**    |
 YYYYQ                   | 1      |
                         |        |
                        \/ Many  \/ Many
                       Monthly Totals File/Table YYYYMM
              | 1                   | 1                         | 1
              |                     |                           |
             \/ Many               \/ Many                     \/ Many
Bought Ledger File/Table      Sales Ledger File/Table      Petty Cash File/Table
YYYYMMDD                      YYYYMMDD                     YYYYMMDD

Where the Monthly Totals File/Table contains the Petty Cash Totals along with Bought Ledger and Sales Ledger Totals, and then have some procedures which perform the totalling by Month.

** Optional because this could be a Report, but if the database is slow because you are using ISAM files like TPS, and there is alot of data, running a totalling procedure periodically can speed up the Report generation by reporting from this file. Likewise this could also be a SQL View or Stored Procedure.

4

Thanks so much for your help.

Kind regards