home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 March
/
Dpcb0399.iso
/
MONEY
/
Capital
/
SETUP.2
/
REPORTS
/
SLAUDIT2.REP
< prev
next >
Wrap
Text File
|
1995-11-09
|
9KB
|
278 lines
VERSION 2.00
Begin Report SLAUDIT2.REP
Caption = "SLAUDIT2.REP"
Width = 11175
Height = 15810
Reportheader = 1050
Header = 495
Transaction = 11805
SubTotal = 1035
Footer = 525
Pagefooter = 15615
Replicate = 360
Style = 0
Query = "NLTRAN NLTRAN.NTAUDIT="B" ORDER BY NLTRAN.NTCODE"
Macro = "1LU:Select from NLNAME where NNACCOUNT=NLTRAN.NTCODE"
Macro = "2SQ:Select from SLTRAN where STNOMACC+STNOMBATCH=NLTRAN.NTCODE+NLTRAN.NTENTRYNO"
Macro = "2PP:@REPVARS.REPTOT(0) = REPTOT(0)+SLTRAN.STVALUE*-1"
Macro = "3PP:@REPVARS.REPTOT(1) = REPTOT(1)+REPTOT(0)"
Macro = "3PP:@REPVARS.REPTOT(0) = 0"
Macro = "4PP:@REPVARS.REPTOT(0) = 0"
Macro = "4PP:@REPVARS.REPTOT(1) = 0"
BreakOn = "NLTRAN.NTCODE"
Special = "TXNRANGE(NTENTRYNO,NTPOSTDATE)"
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Analysis of Receipts & Adjustments"
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 = 3015
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 NNACCOUNT
Type = "Text"
Style = 0
Fieldname = "NNACCOUNT"
Filename = "NLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 45
Top = 15
Width = 1275
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 = "Header Block"
Height = 270
Left = 1560
Top = 15
Width = 2760
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Entry"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 75
Top = 300
Width = 735
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Date"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 1155
Top = 300
Width = 870
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Reference"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 2505
Top = 300
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Account"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 3855
Top = 300
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Value"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 5475
Top = 300
Width = 1005
End
Begin Control STREF
Type = "Text"
Style = 0
Fieldname = "STREF"
Filename = "SLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 2505
Top = 60
Width = 1140
End
Begin Control STTXNDATE
Type = "Text"
Style = 0
Fieldname = "STTXNDATE"
Filename = "SLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 1125
Top = 60
Width = 1275
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(SLTRAN.STVALUE*-1,10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 5070
Top = 75
Width = 1410
End
Begin Control STACCOUNT
Type = "Text"
Style = 0
Fieldname = "STACCOUNT"
Filename = "SLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 3855
Top = 60
Width = 870
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "MID(NLTRAN.NTENTRYNO,5,5)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 75
Top = 75
Width = 1005
End
Begin Control STCOMMENT
Type = "Text"
Style = 0
Fieldname = "STCOMMENT"
Filename = "SLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 6690
Top = 60
Width = 3030
End
Begin Control BOX
Type = "Box"
Style = 8
Location = "Subtotal Block"
Height = 465
Left = 5010
Top = 45
Width = 1485
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 = 5280
Top = 150
Width = 1215
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 = 3570
Top = 195
Width = 1290
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 = "Footer Block"
Height = 270
Left = 5265
Top = 195
Width = 1215
End
Begin Control BOX
Type = "Box"
Style = 8
Location = "Footer Block"
Height = 45
Left = 5010
Top = 75
Width = 1485
End
Begin Control BOX
Type = "Box"
Style = 8
Location = "Footer Block"
Height = 45
Left = 5010
Top = 480
Width = 1485
End