home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 March
/
Dpcb0399.iso
/
MONEY
/
Capital
/
SETUP.2
/
REPORTS
/
VATPOUT.REP
< prev
next >
Wrap
Text File
|
1995-06-21
|
14KB
|
427 lines
VERSION 2.00
Begin Report VATPOUT.REP
Caption = "VATPOUT.REP"
Width = 11175
Height = 16185
Reportheader = 1080
Header = 675
Transaction = 13080
SubTotal = 105
Footer = 990
Pagefooter = 15960
Replicate = 405
Style = 0
Query = "PLTRAN (PTTXNTYPE="I" | PTTXNTYPE="C") & PTVATOUT<>0"
Macro = "2CD:When PLTRAN.PTTXNTYPE="I" then REPTOT(1)=REPTOT(1)+PLTRAN.PTVATOUT"
Macro = "2CD:When PLTRAN.PTTXNTYPE="I" then REPTOT(0)=REPTOT(0)+PLTRAN.PTOUTSTAND"
Macro = "2LU:Select from PLNAME where PNCODE=PLTRAN.PTCODE"
Macro = "2CD:When PLTRAN.PTTXNTYPE="C" then REPTOT(2)=REPTOT(2)+PLTRAN.PTOUTSTAND"
Macro = "2CD:When PLTRAN.PTTXNTYPE="C" then REPTOT(3)=REPTOT(3)+PLTRAN.PTVATOUT"
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 VAT Outstanding"
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 = 1800
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 = 270
Width = 1140
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 = 1425
Top = 270
Width = 735
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 = 3285
Top = 270
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "VAT"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 7185
Top = 255
Width = 465
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Value"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 4710
Top = 270
Width = 735
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Goods"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 5895
Top = 270
Width = 735
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 = 2475
Top = 270
Width = 600
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 = 8235
Top = 270
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Outstanding"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 4440
Top = 510
Width = 1140
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Outstanding"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 5655
Top = 510
Width = 1140
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Outstanding"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 6915
Top = 510
Width = 1140
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 = 120
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 = 120
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 = 3285
Top = 120
Width = 1005
End
Begin Control PTOUTSTAND
Type = "Text"
Style = 0
Fieldname = "PTOUTSTAND"
Filename = "PLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 4440
Top = 120
Width = 1005
End
Begin Control PTVATOUT
Type = "Text"
Style = 0
Fieldname = "PTVATOUT"
Filename = "PLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 6675
Top = 120
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(PLTRAN.PTOUTSTAND-PLTRAN.PTVATOUT,10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 5535
Top = 135
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(PLTRAN.PTTXNTYPE="I","Invce","Cnote")"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 2565
Top = 135
Width = 675
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 = 7995
Top = 105
Width = 3075
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 = 6600
Top = 180
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(0)-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 = 5535
Top = 180
Width = 1080
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 = "Footer Block"
Height = 270
Left = 4365
Top = 180
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Total Invoices"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 2430
Top = 180
Width = 1620
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Total Credits"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 2430
Top = 450
Width = 1620
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 = 4365
Top = 435
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(2)-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 = 5535
Top = 465
Width = 1080
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 = 6600
Top = 450
Width = 1080
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 = "Footer Block"
Height = 270
Left = 2430
Top = 720
Width = 1620
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(2)+REPTOT(0),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 4365
Top = 720
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(0)+REPTOT(2)-REPTOT(1)-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 = 5535
Top = 720
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(1)+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 = 6600
Top = 720
Width = 1080
End