home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 March
/
Dpcb0399.iso
/
MONEY
/
Capital
/
SETUP.2
/
REPORTS
/
PLSUGGS.REP
< prev
next >
Wrap
Text File
|
1996-02-05
|
14KB
|
407 lines
VERSION 2.00
Begin Report PLSUGGS.REP
Caption = "PLSUGGS.REP"
Width = 11175
Height = 15795
Reportheader = 900
Header = 1560
Transaction = 10890
SubTotal = 1035
Footer = 870
Pagefooter = 15615
Replicate = 375
Style = 0
Query = "PLTRAN (PTTXNTYPE="I" & PTDUEDATE<DATE(0) | PTTXNTYPE<>"I" & PTTXNDATE<DATE(0)) & PTALLOC=" " & PTDISP=" " ORDER BY PTCODE"
Macro = "1LU:Select from PLNAME where PNCODE=PLTRAN.PTCODE"
Macro = "2OF:@REPVARS.REPTOT(1) = 0"
Macro = "2CD:When PLTRAN.PTTXNTYPE<>"I" then SKIP 3"
Macro = "2CD:When (DATE(0)-PLTRAN.PTDUEDATE)<PLNAME.PNDAYS2 then REPTOT(0)=PLNAME.PNDISC2"
Macro = "2CD:When (DATE(0)-PLTRAN.PTDUEDATE)<PLNAME.PNDAYS1 then REPTOT(0)=PLNAME.PNDISC1"
Macro = "2CD:When PLTRAN.PTTXNTYPE="I" then REPTOT(1)=REPTOT(0)*(PLTRAN.PTVALUE-PLTRAN.PTVAT)/100"
Macro = "2OF:@REPVARS.REPTOT(3) = REPTOT(3)+PLTRAN.PTOUTSTAND"
Macro = "2OF:@REPVARS.REPTOT(2) = PLTRAN.PTOUTSTAND-REPTOT(1)"
Macro = "2OF:@REPVARS.REPTOT(4) = REPTOT(4)+REPTOT(1)"
Macro = "2OF:@REPVARS.REPTOT(5) = REPTOT(5)+REPTOT(2)"
Macro = "2PP:@REPVARS.REPTOT(1) = 0"
Macro = "3PP:@REPVARS.REPTOT(0) = 0"
Macro = "3PP:@REPVARS.REPTOT(3) = 0"
Macro = "3PP:@REPVARS.REPTOT(4) = 0"
Macro = "3PP:@REPVARS.REPTOT(5) = 0"
Macro = "3OF:@REPVARS.REPTOT(6) = REPTOT(6)+REPTOT(3)"
Macro = "3OF:@REPVARS.REPTOT(7) = REPTOT(7)+REPTOT(4)"
Macro = "3OF:@REPVARS.REPTOT(8) = REPTOT(8)+REPTOT(5)"
Macro = "4PP:@REPVARS.REPTOT(6) = 0"
Macro = "4PP:@REPVARS.REPTOT(7) = 0"
Macro = "4PP:@REPVARS.REPTOT(8) = 0"
Macro = "4PP:@REPVARS.REPTOT(0) = 0"
Macro = "4PP:@REPVARS.REPTOT(1) = 0"
Macro = "4PP:@REPVARS.REPTOT(2) = 0"
BreakOn = "PLTRAN.PTCODE"
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Suggested Payments List"
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 = 4
Caption = "Date"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 1020
Top = 990
Width = 1140
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Discount"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 3420
Top = 990
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Amount Due"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 9405
Top = 975
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Outstanding"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 6060
Top = 990
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Discount Amount"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 7650
Top = 990
Width = 1545
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Type"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 2430
Top = 990
Width = 735
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 = "Header Block"
Height = 270
Left = 105
Top = 360
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 = "Header Block"
Height = 270
Left = 1365
Top = 360
Width = 4290
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 = 45
Top = 990
Width = 1005
End
Begin Control PNPAYDAYS
Type = "Text"
Style = 0
Fieldname = "PNPAYDAYS"
Filename = "PLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 6015
Top = 360
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Days"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 7095
Top = 360
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Invoiced Amount"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 4575
Top = 990
Width = 1410
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 = 1155
Top = 90
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 = 45
Top = 90
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(PLTRAN.PTTXNTYPE="I",STR(REPTOT(1),10,2)," ")"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 7830
Top = 105
Width = 1350
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "MID(" InvCrnPayAdjDscRfd",INSTR("ICPADF",PLTRAN.PTTXNTYPE)*3+1,3)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 2430
Top = 105
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(PLTRAN.PTTXNTYPE="I",STR(REPTOT(0),5,2)+"%"," ")"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 3375
Top = 105
Width = 675
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 = "Transaction Block"
Height = 270
Left = 9450
Top = 105
Width = 1350
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(PLTRAN.PTOUTSTAND,10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 6075
Top = 105
Width = 1350
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(PLTRAN.PTVALUE,10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 4590
Top = 105
Width = 1350
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 = 6345
Top = 435
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(4),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 8085
Top = 435
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(5),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 9720
Top = 450
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Account Total"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 2445
Top = 420
Width = 2010
End
Begin Control BOX
Type = "Box"
Style = 2
Location = "Footer Block"
Height = 540
Left = 4320
Top = 330
Width = 6615
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Totals"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 4455
Top = 465
Width = 1350
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(6),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 6345
Top = 465
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(8),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 9720
Top = 450
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(7),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 8100
Top = 450
Width = 1080
End