home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
database
/
dbbooks.zip
/
UPDATER.CMD
< prev
Wrap
OS/2 REXX Batch file
|
1987-02-14
|
1KB
|
55 lines
*********************************** UPDATER.CMD
************** Monthly update program for
************** Updating Chart of Accounts Balances.
ERAS
? "This program should be performed once a month"
? "to bring the Chart of Accounts totals up-to-date"
?
STORE " " TO YN
@ 5,2 SAY "Is this the program you want? " GET YN
READ
IF !(YN) <> "Y"
RETURN
ENDIF (yn <> y)
******************** Ask about start of new quarter.
ERASE
STORE " " TO QTR
@ 10,2 SAY "Is this the start of a new quarter? "
@ 10,38 GET QTR
READ
************* Perform the update.
ERASE
? "Performing the update...."
USE TRANS INDEX ACCT
COPY TO TEMP FOR .NOT. POSTED
REPL ALL POSTED WITH T
USE COA INDEX COA
************** Set Month-to-Date field (AMOUNT) to zero.
REPLACE ALL AMOUNT WITH 0
************** If start of new quarter, replace all
************** Quarterly balances with zeroes too.
IF !(QTR)="Y"
REPLACE ALL QTD WITH 0
ENDIF (qtr=y)
************** Update from TEMO file, then
************** increment QTD and YTD.
UPDATE ON ACCT FROM TEMP ADD AMOUNT
REPL ALL QTD WITH QTD+AMOUNT
REPL ALL YTD WITH YTD+AMOUNT
************** Now, set POSTED flag in TRANS to T.
USE TRANS
REPLACE ALL POSTED WITH T
************** Update Geninfo File
USE GENINFO
REPLACE LAST:UPDAT WITH T:DATE
USE
RETURN