home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 March
/
Dpcb0399.iso
/
MONEY
/
Capital
/
SETUP.2
/
REPORTS
/
PLPAYMTS.REP
< prev
next >
Wrap
Text File
|
1996-07-31
|
10KB
|
325 lines
VERSION 2.00
Begin Report PLPAYMTS.REP
Caption = "PLPAYMTS.REP"
Width = 11175
Height = 16845
Reportheader = 975
Header = 570
Transaction = 12855
SubTotal = 1410
Footer = 0
Pagefooter = 15945
Replicate = 360
Style = 9
Query = "PLTRAN PTTXNTYPE="P" | PTTXNTYPE="D""
Macro = "2LU:Select from PLNAME where PNCODE=PLTRAN.PTCODE"
Macro = "2PP:@REPVARS.REPTOT(0) = REPTOT(0)+PLTRAN.PTVALUE"
Macro = "2CD:When PLTRAN.PTTXNTYPE="P" & PLTRAN.PTALLOC="A" then REPTOT(1)=REPTOT(1)+PLTRAN.PTVALUE"
Macro = "2CD:When PLTRAN.PTTXNTYPE="P" & PLTRAN.PTALLOC=" " then REPTOT(2)=REPTOT(2)+PLTRAN.PTVALUE"
Macro = "2CD:When PLTRAN.PTTXNTYPE="D" then REPTOT(3)=REPTOT(3)+PLTRAN.PTVALUE"
Macro = "4PP:@REPVARS.REPTOT(0) = 0"
Special = "TXNRANGE(PTBATCHNO,PTDATE)"
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Purchase Payments"
Font = "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 420
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 = 3690
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "PAGENUM()"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 285
Left = 10395
Top = 720
Width = 585
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Page:"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 285
Left = 9720
Top = 720
Width = 585
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 = "Supplier ID"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 135
Top = 240
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Date"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 1290
Top = 240
Width = 1140
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Reference"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 3960
Top = 240
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Value"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 5655
Top = 240
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Type"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 2640
Top = 240
Width = 870
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Supplier Name"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 6870
Top = 240
Width = 1815
End
Begin Control PTCODE
Type = "Text"
Style = 0
Fieldname = "PTCODE"
Filename = "PLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 135
Top = 60
Width = 1005
End
Begin Control PTTXNDATE
Type = "Text"
Style = 0
Fieldname = "PTTXNDATE"
Filename = "PLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 1290
Top = 60
Width = 1140
End
Begin Control PTREF
Type = "Text"
Style = 0
Fieldname = "PTREF"
Filename = "PLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 3960
Top = 60
Width = 1410
End
Begin Control PTVALUE
Type = "Text"
Style = 0
Fieldname = "PTVALUE"
Filename = "PLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 5520
Top = 60
Width = 1140
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(PLTRAN.PTTXNTYPE="D","Discount","Payment")"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 2640
Top = 75
Width = 1005
End
Begin Control PNNAME
Type = "Text"
Style = 0
Fieldname = "PNNAME"
Filename = "PLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 6885
Top = 60
Width = 3075
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Total"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 4320
Top = 285
Width = 945
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 = 5445
Top = 285
Width = 1215
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Allocated Payments"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 135
Top = 465
Width = 2025
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Unallocated Payments"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 135
Top = 735
Width = 2025
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Discount"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 135
Top = 1005
Width = 1620
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 = 2340
Top = 465
Width = 1215
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 = "Subtotal Block"
Height = 270
Left = 2340
Top = 735
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 = "Subtotal Block"
Height = 270
Left = 2340
Top = 1005
Width = 1215
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Total"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 135
Top = 1275
Width = 1620
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(3)+REPTOT(2)+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 = 2340
Top = 1275
Width = 1215
End