home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 March
/
Dpcb0399.iso
/
MONEY
/
Capital
/
SETUP.2
/
REPORTS
/
FACTBAT.REP
< prev
next >
Wrap
Text File
|
1996-08-01
|
15KB
|
432 lines
VERSION 2.00
Begin Report FACTBAT.REP
Caption = "FACTBAT.REP"
Width = 11460
Height = 16185
Reportheader = 0
Header = 3495
Transaction = 10260
SubTotal = 0
Footer = 0
Pagefooter = 13755
Replicate = 405
Style = 13
Query = "FACTAD ORDER BY STR(FCFACTER,8,0)+FCBATCHNO+FCDOCNO"
Macro = "0LU:Select from FACTOR where ALL"
Macro = "1OF:@REPVARS.REPTOT(3) = REPTOT(3)+1"
Macro = "1CD:When REPTOT(3)=1 then REPTOT(2)=0"
Macro = "1CD:When REPTOT(3)=1 then REPTOT(4)=0"
Macro = "1CD:When REPTOT(3)=1 then REPTOT(5)=0"
Macro = "2OF:@REPVARS.REPTOT(0) = REPTOT(0)+FACTAD.FCTOTVALUE"
Macro = "2OF:@REPVARS.REPTOT(1) = REPTOT(1)+FACTAD.FCTOTVAT"
Macro = "2OF:@REPVARS.REPTOT(2) = REPTOT(2)+1"
Macro = "2OF:@REPVARS.REPTOT(4) = REPTOT(4)+FACTAD.FCTOTVALUE"
Macro = "2OF:@REPVARS.REPTOT(5) = REPTOT(5)+FACTAD.FCTOTVAT"
Macro = "2OF:RUNTIME.ALPHAFIELD = FACTAD.FCBATCHNO"
Macro = "3PP:@REPVARS.REPTOT(3) = 0"
Macro = "5PP:@REPVARS.REPTOT(0) = 0"
Macro = "5PP:@REPVARS.REPTOT(1) = 0"
BreakOn = "STR(FACTAD.FCFACTER,8,0)+FACTAD.FCBATCHNO"
End
Begin Control LABEL
Type = "Label"
Style = 12
Caption = "IF(REPTOT(3)=1,IF(FACTAD.FCTYPE="I","NOTIFICATION OF RECEIVABLES","NOTIFICATION OF RETURNS & ALLOWANCES"),IF(FACTAD.FCTYPE="I","NOTIFICATION OF RECEIVABLES ( Contd )","NOTIFICATION OF RETURNS & ALLOWANCES ( Contd )"))"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 270
Top = 540
Width = 11025
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 = 8430
Top = 3090
Width = 510
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(FACTAD.FCTYPE="I","Invoice No.","Credit No.")"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 2940
Top = 3090
Width = 1110
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Cust. Ref. No."
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 1320
Top = 3090
Width = 1245
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(REPTOT(3)=1,"Client Number :","")"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 1080
Width = 1755
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Item"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 105
Top = 3090
Width = 705
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(FACTAD.FCTYPE="I","Invoice Date","Credit Date")"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 4560
Top = 3090
Width = 1245
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(FACTAD.FCTYPE="I","Invoice Value","Credit Value")"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 6315
Top = 3090
Width = 1110
End
Begin Control LABEL
Type = "Label"
Style = 12
Caption = "IF(FACTAD.FCTYPE="I","INVOICES","CREDIT NOTES")"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 270
Top = 270
Width = 11025
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(REPTOT(3)=1,FACTOR.FACTCLIENT,"")"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 2565
Top = 1080
Width = 1485
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(REPTOT(3)=1,"Authorised Signatory :","")"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 810
Top = 1755
Width = 3105
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Batch Number :"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 6885
Top = 1080
Width = 1620
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "FACTAD.FCBATCHNO"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 8505
Top = 1080
Width = 1485
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(REPTOT(3)=1,"Date :","")"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 6885
Top = 1755
Width = 675
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(REPTOT(3)=1,DTOC(DATE()),"")"
Font = "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 7560
Top = 1755
Width = 1080
End
Begin Control FCTOTVALUE
Type = "Text"
Style = 0
Fieldname = "FCTOTVALUE"
Filename = "FACTAD"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 6300
Top = 135
Width = 1185
End
Begin Control FCTOTVAT
Type = "Text"
Style = 0
Fieldname = "FCTOTVAT"
Filename = "FACTAD"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 7800
Top = 135
Width = 1185
End
Begin Control FCDOCNO
Type = "Text"
Style = 0
Fieldname = "FCDOCNO"
Filename = "FACTAD"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 3000
Top = 135
Width = 1050
End
Begin Control FCFACTR
Type = "Text"
Style = 0
Fieldname = "FCFACTR"
Filename = "FACTAD"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 1380
Top = 135
Width = 960
End
Begin Control FCTXNDATE
Type = "Text"
Style = 0
Fieldname = "FCTXNDATE"
Filename = "FACTAD"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 4620
Top = 135
Width = 960
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(2),3,0)"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 30
Top = 135
Width = 675
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(REPTOT(3)=0,"___________","")"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Pagefooter Block"
Height = 270
Left = 7800
Top = 1125
Width = 1185
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(REPTOT(3)=0,"___________","")"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Pagefooter Block"
Height = 270
Left = 6300
Top = 1125
Width = 1185
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(0),10,2)"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Pagefooter Block"
Height = 270
Left = 6300
Top = 760
Width = 1185
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPTOT(1),10,2)"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Pagefooter Block"
Height = 270
Left = 7800
Top = 760
Width = 1185
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "___________"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Pagefooter Block"
Height = 270
Left = 6300
Top = 370
Width = 1185
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "___________"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Pagefooter Block"
Height = 270
Left = 6300
Top = 910
Width = 1185
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "___________"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Pagefooter Block"
Height = 270
Left = 7800
Top = 370
Width = 1185
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "___________"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Pagefooter Block"
Height = 270
Left = 7800
Top = 910
Width = 1185
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Sub Totals"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Pagefooter Block"
Height = 270
Left = 4410
Top = 760
Width = 1590
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(REPTOT(3)=0,"Totals for Batch "+TRIM(RUNTIME.ALPHAFIELD),"")"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Pagefooter Block"
Height = 270
Left = 4410
Top = 1515
Width = 1860
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(REPTOT(3)=0,STR(REPTOT(4),10,2),"")"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Pagefooter Block"
Height = 270
Left = 6300
Top = 1515
Width = 1185
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(REPTOT(3)=0,"___________","")"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Pagefooter Block"
Height = 270
Left = 6300
Top = 1665
Width = 1185
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(REPTOT(3)=0,STR(REPTOT(5),10,2),"")"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Pagefooter Block"
Height = 270
Left = 7800
Top = 1515
Width = 1185
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(REPTOT(3)=0,"___________","")"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Pagefooter Block"
Height = 270
Left = 7800
Top = 1665
Width = 1185
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(REPTOT(3)=0,"Total No. of Documents in Batch "+TRIM(RUNTIME.ALPHAFIELD)+" = "+STR(REPTOT(2),3,0),"")"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Pagefooter Block"
Height = 270
Left = 225
Top = 1515
Width = 3615
End