home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 March
/
Dpcb0399.iso
/
MONEY
/
Capital
/
SETUP.2
/
REPORTS
/
VATPLUN.REP
< prev
next >
Wrap
Text File
|
1996-02-05
|
10KB
|
307 lines
VERSION 2.00
Begin Report VATPLUN.REP
Caption = "VATPLUN.REP"
Width = 11175
Height = 15825
Reportheader = 975
Header = 735
Transaction = 13125
SubTotal = 15
Footer = 690
Pagefooter = 15720
Replicate = 435
Style = 0
Query = "PLTRAN PTTXNTYPE="P" & PTALLOC=" " ORDER BY PTCODE"
Macro = "2LU:Select from PLNAME where PNCODE=PLTRAN.PTCODE"
Macro = "2OF:@REPVARS.REPTOT(0) = PLTRAN.PTVALUE-PLTRAN.PTVAT"
Macro = "2OF:@REPVARS.REPTOT(1) = REPTOT(1)+PLTRAN.PTVALUE"
Macro = "2OF:@REPVARS.REPTOT(2) = REPTOT(2)+REPTOT(0)"
Macro = "2OF:@REPVARS.REPTOT(3) = REPTOT(3)+PLTRAN.PTVAT"
Macro = "4PP:@REPVARS.REPTOT(0) = 0"
Macro = "4PP:@REPVARS.REPTOT(1) = 0"
Macro = "4PP:@REPVARS.REPTOT(2) = 0"
Macro = "4PP:@REPVARS.REPTOT(3) = 0"
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Purchase Unallocated 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 = 2880
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 = 375
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 = 375
Width = 870
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 = 2610
Top = 375
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 = 3900
Top = 375
Width = 1005
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 = 8760
Top = 375
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Goods"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 5115
Top = 375
Width = 1140
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "VAT"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 6330
Top = 375
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "VAT Code"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 7545
Top = 375
Width = 870
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 = 165
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 = 165
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 = 2610
Top = 165
Width = 1140
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 = 8775
Top = 165
Width = 2805
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 = "Transaction Block"
Height = 255
Left = 5145
Top = 180
Width = 1035
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 = 255
Left = 3870
Top = 165
Width = 1065
End
Begin Control PTVAT
Type = "Text"
Style = 0
Fieldname = "PTVAT"
Filename = "PLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 255
Left = 6300
Top = 165
Width = 1065
End
Begin Control PTVATCODE
Type = "Text"
Style = 0
Fieldname = "PTVATCODE"
Filename = "PLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 255
Left = 7785
Top = 165
Width = 390
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Total"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 285
Left = 2565
Top = 405
Width = 870
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 = 255
Left = 3765
Top = 390
Width = 1170
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 = 255
Left = 4995
Top = 405
Width = 1170
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 = 255
Left = 6195
Top = 405
Width = 1170
End