home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 March
/
Dpcb0399.iso
/
MONEY
/
Capital
/
SETUP.2
/
REPORTS
/
NLRECURR.REP
< prev
next >
Wrap
Text File
|
1995-06-21
|
12KB
|
387 lines
VERSION 2.00
rem Rev 1.0 12 Jan 1995 16:27:56 capital_admin
rem Initial revision.
rem
Begin Report NLRECURR.REP
Caption = "NLRECURR.REP"
Width = 11175
Height = 15795
Reportheader = 990
Header = 930
Transaction = 11430
SubTotal = 1035
Footer = 795
Pagefooter = 15615
Replicate = 390
Style = 0
Query = "NLRECDT ALL"
Macro = "1LU:Select from NLRECHD where NRCODE=NLRECDT.NECODE"
Macro = "2LU:Select from NLNAME where NNACCOUNT=NLRECDT.NEACCID"
Macro = "2CD:When NLRECDT.NEVALUE=>0 then REPTOT(0)=REPTOT(0)+NLRECDT.NEVALUE"
Macro = "2CD:When NLRECDT.NEVALUE<0 then REPTOT(1)=REPTOT(1)+(NLRECDT.NEVALUE*-1)"
Macro = "3PP:@REPVARS.REPTOT(2) = REPTOT(2)+REPTOT(0)"
Macro = "3PP:@REPVARS.REPTOT(3) = REPTOT(3)+REPTOT(1)"
Macro = "3PP:@REPVARS.REPTOT(0) = 0"
Macro = "3PP:@REPVARS.REPTOT(1) = 0"
Macro = "4PP:@REPVARS.REPTOT(0) = 0"
Macro = "4PP:@REPVARS.REPTOT(1) = 0"
Macro = "4PP:@REPVARS.REPTOT(2) = 0"
Macro = "4PP:@REPVARS.REPTOT(3) = 0"
BreakOn = "NLRECDT.NECODE"
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "List of Recurring Journals"
Font = "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 375
Left = 0
Top = 675
Width = 11025
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "DTOC(DATE())"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 285
Left = 135
Top = 705
Width = 1800
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = ""Page "+PAGENUM()"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 285
Left = 9180
Top = 720
Width = 1800
End
Begin Control LABEL
Type = "Label"
Style = 12
Caption = "TRIM(SYSTEM.COMPNAME)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 270
Left = -15
Top = 405
Width = 11070
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Entry:"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 90
Top = 60
Width = 600
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Next Due"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 1170
Top = 60
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Freq"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 2385
Top = 60
Width = 600
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Repetitions"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 3060
Top = 60
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Debit"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 4935
Top = 810
Width = 1275
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Credit"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 6555
Top = 810
Width = 1275
End
Begin Control NRDUEDATE
Type = "Text"
Style = 0
Fieldname = "NRDUEDATE"
Filename = "NLRECHD"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 1125
Top = 345
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Account"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 75
Top = 810
Width = 1140
End
Begin Control NRNARR
Type = "Text"
Style = 0
Fieldname = "NRNARR"
Filename = "NLRECHD"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4395
Top = 345
Width = 3975
End
Begin Control NRCODE
Type = "Text"
Style = 0
Fieldname = "NRCODE"
Filename = "NLRECHD"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 45
Top = 345
Width = 870
End
Begin Control NRFREQ
Type = "Text"
Style = 0
Fieldname = "NRFREQ"
Filename = "NLRECHD"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 2475
Top = 345
Width = 330
End
Begin Control NRREPS
Type = "Text"
Style = 0
Fieldname = "NRREPS"
Filename = "NLRECHD"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 3015
Top = 345
Width = 465
End
Begin Control NNACCNAME
Type = "Text"
Style = 0
Fieldname = "NNACCNAME"
Filename = "NLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 1290
Top = 90
Width = 3165
End
Begin Control NEACCID
Type = "Text"
Style = 0
Fieldname = "NEACCID"
Filename = "NLRECDT"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 45
Top = 90
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "CORD(NLRECDT.NEVALUE,10,2,1)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 4800
Top = 105
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "CORD(NLRECDT.NEVALUE,10,2,-1)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 6420
Top = 105
Width = 1410
End
Begin Control NECOMMENT
Type = "Text"
Style = 0
Fieldname = "NECOMMENT"
Filename = "NLRECDT"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 8040
Top = 90
Width = 2895
End
Begin Control BOX
Type = "Box"
Style = 8
Location = "Subtotal Block"
Height = 465
Left = 4875
Top = 315
Width = 2970
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(0),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 5010
Top = 420
Width = 1215
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(1),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 6615
Top = 420
Width = 1215
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Account Total"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 3165
Top = 420
Width = 1605
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Input By:"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 150
Top = 420
Width = 930
End
Begin Control NRINPUTBY
Type = "Text"
Style = 0
Fieldname = "NRINPUTBY"
Filename = "NLRECHD"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 1215
Top = 420
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Totals"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 3435
Top = 330
Width = 885
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(2),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 4995
Top = 465
Width = 1215
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(3),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 6615
Top = 450
Width = 1215
End
Begin Control BOX
Type = "Box"
Style = 8
Location = "Footer Block"
Height = 45
Left = 5010
Top = 345
Width = 2835
End
Begin Control BOX
Type = "Box"
Style = 8
Location = "Footer Block"
Height = 45
Left = 5010
Top = 750
Width = 2835
End