home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 March
/
Dpcb0399.iso
/
MONEY
/
Capital
/
SETUP.2
/
REPORTS
/
INVPRF01.REP
< prev
next >
Wrap
Text File
|
1996-03-06
|
27KB
|
842 lines
VERSION 2.00
Begin Report INVPRF01.REP
Caption = "INVPRF01.REP"
Width = 11175
Height = 16395
Reportheader = 0
Header = 6375
Transaction = 6330
SubTotal = 3360
Footer = 0
Pagefooter = 16080
Replicate = 375
Style = 13
Query = "STTRND "
Macro = "1LU:Select from SLNAME where SLNAME.SNACCOUNT=STTRND.CDACCID"
Macro = "1LU:Select from STTRNH where STTRNH.CHTRANNO=STTRND.CDTRANNO"
Macro = "1OF:@REPVARS.REPTOT(0) = REPTOT(0)+1"
Macro = "3PP:@REPVARS.REPTOT(0) = 0"
BreakOn = "STTRND.CDTRANNO"
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = ""Quantity""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 5670
Top = 5850
Width = 870
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = ""Description""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 2655
Top = 5850
Width = 1140
End
Begin Control SNNAME
Type = "Text"
Style = 0
Fieldname = "SNNAME"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 2280
Width = 3645
End
Begin Control SNADD1
Type = "Text"
Style = 0
Fieldname = "SNADD1"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 2535
Width = 3645
End
Begin Control SNADD2
Type = "Text"
Style = 0
Fieldname = "SNADD2"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 2790
Width = 3645
End
Begin Control SNADD3
Type = "Text"
Style = 0
Fieldname = "SNADD3"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 3030
Width = 3645
End
Begin Control SNADD4
Type = "Text"
Style = 0
Fieldname = "SNADD4"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 3285
Width = 3645
End
Begin Control SNPOSTCODE
Type = "Text"
Style = 0
Fieldname = "SNPOSTCODE"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 3540
Width = 3645
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = ""Price""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 6915
Top = 5850
Width = 600
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = ""Product ID""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 360
Top = 5850
Width = 1275
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = ""Invoice To:""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 2040
Width = 2025
End
Begin Control CHDEL1
Type = "Text"
Style = 0
Fieldname = "CHDEL1"
Filename = "STTRNH"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 6615
Top = 2280
Width = 3645
End
Begin Control CHDEL2
Type = "Text"
Style = 0
Fieldname = "CHDEL2"
Filename = "STTRNH"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 6615
Top = 2535
Width = 3645
End
Begin Control CHDEL3
Type = "Text"
Style = 0
Fieldname = "CHDEL3"
Filename = "STTRNH"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 6615
Top = 2790
Width = 3645
End
Begin Control CHDEL4
Type = "Text"
Style = 0
Fieldname = "CHDEL4"
Filename = "STTRNH"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 6615
Top = 3030
Width = 3645
End
Begin Control CHDEL5
Type = "Text"
Style = 0
Fieldname = "CHDEL5"
Filename = "STTRNH"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 6615
Top = 3285
Width = 3645
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = ""Deliver To:""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 6615
Top = 2040
Width = 2025
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = ""Despatched By""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 5535
Top = 4545
Width = 1215
End
Begin Control CHDESPBY
Type = "Text"
Style = 0
Fieldname = "CHDESPBY"
Filename = "STTRNH"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 6750
Top = 4545
Width = 1890
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = ""Customer ID""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 5010
Width = 2025
End
Begin Control CHACCID
Type = "Text"
Style = 0
Fieldname = "CHACCID"
Filename = "STTRNH"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 2835
Top = 5010
Width = 1890
End
Begin Control COMPADD1
Type = "Text"
Style = 0
Fieldname = "COMPADD1"
Filename = "SYSTEM"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 540
Width = 3375
End
Begin Control COMPADD2
Type = "Text"
Style = 0
Fieldname = "COMPADD2"
Filename = "SYSTEM"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 810
Width = 3375
End
Begin Control COMPADD3
Type = "Text"
Style = 0
Fieldname = "COMPADD3"
Filename = "SYSTEM"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 1080
Width = 3375
End
Begin Control COMPADD4
Type = "Text"
Style = 0
Fieldname = "COMPADD4"
Filename = "SYSTEM"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 1350
Width = 3375
End
Begin Control COMPTEL
Type = "Text"
Style = 0
Fieldname = "COMPTEL"
Filename = "SYSTEM"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 5265
Top = 810
Width = 2160
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Telephone No."
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4185
Top = 810
Width = 1080
End
Begin Control COMPFAX
Type = "Text"
Style = 0
Fieldname = "COMPFAX"
Filename = "SYSTEM"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 5265
Top = 1080
Width = 2160
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = ""Value""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 9885
Top = 5850
Width = 600
End
Begin Control LABEL
Type = "Label"
Style = 12
Caption = ""Discount %""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 7560
Top = 6090
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 12
Caption = ""Line Discount""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 8400
Top = 5850
Width = 1275
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = ""Proforma : ""
Font = "-240|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 7560
Top = 360
Width = 1350
End
Begin Control CHDOCNO
Type = "Text"
Style = 0
Fieldname = "CHDOCNO"
Filename = "STTRNH"
Font = "-240|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 8910
Top = 360
Width = 2160
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Facsimile No."
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4185
Top = 1080
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(TRIM(REPSTR(9))<>"P" & TRIM(SYSTEM.VATREG)<>"","VAT Reg. No.","")"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4185
Top = 1350
Width = 1140
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = ""Customer VAT Reg. No.""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 4545
Width = 2025
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = ""Date : ""
Font = "-195|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 7950
Top = 765
Width = 945
End
Begin Control CHTXNDATE
Type = "Text"
Style = 0
Fieldname = "CHTXNDATE"
Filename = "STTRNH"
Font = "-195|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 8910
Top = 765
Width = 1620
End
Begin Control LABEL
Type = "Label"
Style = 12
Caption = ""Line""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 7590
Top = 5850
Width = 870
End
Begin Control LABEL
Type = "Label"
Style = 12
Caption = ""Amount""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 8520
Top = 6090
Width = 1005
End
Begin Control COMPNAME
Type = "Text"
Style = 0
Fieldname = "COMPNAME"
Filename = "SYSTEM"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 270
Width = 4995
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = ""Page No. "+STR(REPTOT(0),3,0)"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 8700
Top = 5010
Width = 1395
End
Begin Control SNVATREGNO
Type = "Text"
Style = 0
Fieldname = "SNVATREGNO"
Filename = "SLNAME"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 3240
Top = 4545
Width = 2160
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(TRIM(REPSTR(9))<>"P" & TRIM(SYSTEM.VATREG)<>"",SYSTEM.COUNTRY,"")"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 5265
Top = 1350
Width = 270
End
Begin Control VATREG
Type = "Text"
Style = 0
Fieldname = "VATREG"
Filename = "SYSTEM"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 5535
Top = 1350
Width = 2025
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(SLNAME.SNVATREGNO="" | SLNAME.SNCOUNTRY="XN","",SLNAME.SNCOUNTRY)"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 2835
Top = 4545
Width = 405
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "">> THIS IS NOT A TAX INVOICE <<""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 7965
Top = 1335
Width = 3105
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = ""Customer Ref.""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 8700
Top = 4545
Width = 1080
End
Begin Control CHREF
Type = "Text"
Style = 0
Fieldname = "CHREF"
Filename = "STTRNH"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 9840
Top = 4545
Width = 1620
End
Begin Control CDDESC
Type = "Text"
Style = 0
Fieldname = "CDDESC"
Filename = "STTRND"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 2385
Top = 90
Width = 3300
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "if(STTRND.CDDISCP=0,"",STR(STTRND.CDDISCP,5,2))"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 7575
Top = 90
Width = 720
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "if(STTRND.CDDISCVAL=0,"",STR(STTRND.CDDISCVAL,10,2))"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 8385
Top = 90
Width = 990
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "if(STTRND.CDPRODTYPE="0","",STTRND.CDPRODID)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 285
Top = 90
Width = 2070
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "if(STTRND.CDPRICE=0,"",STR(STTRND.CDPRICE,10,2))"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 6495
Top = 90
Width = 990
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "if(STTRND.CDQUANTITY=0,"",STR(STTRND.CDQUANTITY,10,2))"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 5550
Top = 90
Width = 855
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "if(STTRND.CDGOODSVAL=0,"",STR(STTRND.CDGOODSVAL,10,2))"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 9465
Top = 90
Width = 990
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "if(STTRNH.CHSETTVAL1<>0,"If Paid Within","")"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 285
Left = 270
Top = 525
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 12
Caption = "if(STTRNH.CHSETTVAL1<>0,STR(SLNAME.SNDAYS1,2,0),"")"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 285
Left = 1350
Top = 525
Width = 195
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "if(STTRNH.CHSETTVAL1<>0,"Days You May Deduct ","")"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 285
Left = 1620
Top = 525
Width = 1680
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "if(STTRNH.CHSETTVAL1<>0,STR(STTRNH.CHSETTVAL1,10,2),"")"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 285
Left = 3330
Top = 525
Width = 1140
End
Begin Control CHTOTGOODS
Type = "Text"
Style = 0
Fieldname = "CHTOTGOODS"
Filename = "STTRNH"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 9465
Top = 1335
Width = 990
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(TRIM(SYSTEM.VATREG)<>"",STR(STTRNH.CHTOTVAT,10,2),"")"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 9465
Top = 2145
Width = 990
End
Begin Control CHTOTVALUE
Type = "Text"
Style = 0
Fieldname = "CHTOTVALUE"
Filename = "STTRNH"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 9465
Top = 2550
Width = 990
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = ""Total Goods""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 285
Left = 7830
Top = 1335
Width = 1275
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(TRIM(SYSTEM.VATREG)<>"","Total VAT","")"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 285
Left = 7830
Top = 2145
Width = 1275
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = ""Invoice Total""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 285
Left = 7830
Top = 2550
Width = 1275
End
Begin Control CHNARR
Type = "Text"
Style = 0
Fieldname = "CHNARR"
Filename = "STTRNH"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 945
Left = 270
Top = 2265
Width = 6540
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "if(STTRNH.CHNETCARR=0,"","Net Carriage")"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 285
Left = 7830
Top = 1605
Width = 1275
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "if(STTRNH.CHNETCARR=0,"",STR(STTRNH.CHNETCARR,10,2))"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 9465
Top = 1605
Width = 990
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "if(STTRNH.CHOVRDISC=0,"","Overall Discount")"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 285
Left = 7830
Top = 1875
Width = 1275
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "if(STTRNH.CHOVRDISC=0,"",STR(STTRNH.CHOVRDISC,10,2))"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 9465
Top = 1875
Width = 990
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "">> THIS IS NOT A TAX INVOICE <<""
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 3780
Top = 1740
Width = 3105
End