home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
database
/
dbbooks.zip
/
COAREPT.CMD
< prev
next >
Wrap
OS/2 REXX Batch file
|
1987-02-14
|
2KB
|
84 lines
**************************** COAREPT.CMD
************ Print Chart of Accounts and Balances.
************ Get date of last update.
USE GENINFO
STORE LAST:UPDAT TO LAST:DATE
USE COA INDEX COA
************ Ask about hardcopy.
ERAS
STORE " " TO YN
@ 5,2 SAY "Send report to printer? " GET YN
READ
IF !(YN)="Y"
STORE "TO PRINT" TO COND
ELSE
STORE " " TO COND
ENDIF (yn=y)
*********** Caculate totals, leaving out sub-accounts.
ERASE
? "Calculating totals...."
SUM AMOUNT FOR ACCT<300 .AND. INT(ACCT)=ACCT TO TOT:MTD1
SUM AMOUNT FOR ACCT>=300 .AND. INT(ACCT)=ACCT TO TOT:MTD2
SUM QTD FOR ACCT<300 .AND. INT(ACCT)=ACCT TO TOT:QTD1
SUM QTD FOR ACCT>=300 .AND. INT(ACCT)=ACCT TO TOT:QTD2
SUM YTD FOR ACCT<300 .AND. INT(ACCT)=ACCT TO TOT:YTD1
SUM YTD FOR ACCT>=300 .AND. INT(ACCT)=ACCT TO TOT:YTD2
********************** Print the report using
********************** pre-defined report formats.
SET EJECT OFF
ERASE
? " Chart of Accounts for &COMPANY"
?
********************* Print appropriate sub-heading.
? "Last Update: &LAST:DATE"
******************** Print income accounts.
?
? "INCOME:"
REPO FORM COA FOR ACCT<300 &COND PLAIN
? "Total Income ",TOT:MTD1," ",TOT:QTD1," ",TOT:YTD1
?
******************** Print expense transactions.
? "EXPENSES:"
REPO FORM COA FOR ACCT>=300 &COND PLAIN
? "Total Expenses ",TOT:MTD2," ",TOT:QTD2," ",TOT:YTD2
******************** Display balance at bottom of sheet.
?
? "Total Income ",TOT:MTD1," ",TOT:QTD1," ",TOT:YTD1
? "Total Expenses ",TOT:MTD2," ",TOT:QTD2," ",TOT:YTD2
?
? "Balance ",;
TOT:MTD1-TOT:MTD2," ",TOT:QTD1-TOT:QTD2," ",;
TOT:YTD1-TOT:YTD2
EJECT
*************** If report not going to printer,
*************** pause on screen.
IF COND = " "
?
?
? "Press any key to continue"
WAIT
ENDIF (cond=" ")
RETURN
DO BEDIT
ENDCASE
ENDDO (while choice <> 4)
ERASE
STORE T TO ADDING
DO WHILE ADDING
APPEND BLANK