Report Name=One Invoice
Last Update=2019/01/21 11:50 Mike King
Associate Library=reports/reportlib.pvrlib
DataSource=View: Invoice,V
Output Device=P
Top Margin=1000
Bottom Margin=1000
Font=Arial,-10
Sort Segment=InvoiceNumber
Sort Segment Type=S
Sort Segment Length=6
Sort Segment Case Insensitive=N
Sort Segment Order=A
Sort Segment=Itm_LineNumber
Sort Segment Type=S
Sort Segment Length=4
Sort Segment Case Insensitive=N
Sort Segment Order=A
Parameter Name=InvNum
Parameter Description=Enter Invoice
Parameter Type=S
Parameter Length=6
Parameter Maximum=999999
Parameter Default=118840
FilterSet=1
FilterSet Option=Accept
Filter Variable=InvoiceNumber$
Filter Condition=1
Filter Case Sensitive=N
Filter Compare Value=InvNum$
Columns=65.57,88.07,36,64.29,52.71,17.36,36,61.07,84.21
Break=Header PG
Break=Header 01 InvoiceNumber OPT=P
Row=14.79
Layout Library=reports/reportlib.pvrlib
Layout Library Reference=Letterhead
Row=11.57
Row=11.57
Column= 4
Value$=Invoice Number:
Font$=Arial,-10,B
Align$=TR
JoinColumns= 2
JoinRows= 1
Column= 7
Value$=InvoiceNumber$
Text$=000000
JoinColumns= 3
JoinRows= 1
Row=11.57
Column= 4
Value$=Invoice Date:
Font$=Arial,-10,B
Align$=TR
JoinColumns= 2
JoinRows= 1
Column= 7
Value$=InvoiceDate$
Text$=0000-00-00
JoinColumns= 3
JoinRows= 1
Row=11.57
Row=11.57
Column= 1
Value$=Sold To:
Font$=Arial,-10,B
Column= 2
Value$=Cl_ClientName$
Text$=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
JoinColumns= 3
JoinRows= 1
Column= 5
Value$=Ship To:
Font$=Arial,-10,B
Align$=TR
Column= 7
Value$=Cl_ClientName$
Text$=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
JoinColumns= 3
JoinRows= 1
Row=11.57
Column= 2
Value$=Cl_Address1$
Text$=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
JoinColumns= 3
JoinRows= 1
Column= 7
Value$=Address1$
Text$=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
JoinColumns= 3
JoinRows= 1
Row=11.57
FilterSet=1
FilterSet Option=Reject
Filter Variable=Address2$
Filter Condition=1
Filter Case Sensitive=N
Filter Compare Value=""
Filter Variable=Cl_Address2$
Filter Condition=1
Filter Case Sensitive=N
Filter Compare Value=""
Column= 2
Value$=Cl_Address2$
Text$=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
JoinColumns= 3
JoinRows= 1
Column= 7
Value$=Address2$
Text$=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
JoinColumns= 3
JoinRows= 1
Row=11.57
Column= 2
Value$=Cl_City$
Text$=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Column= 7
Value$=City$
Text$=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
JoinColumns= 3
JoinRows= 1
Row=11.57
Column= 2
Value$=Cl_State$+", "+Cl_Country$
Text$=xxxxxxxxxxxxxx
JoinColumns= 3
JoinRows= 1
Column= 7
Value$=State$+", "+Country$
Text$=xxxxxxxxxxxxxx
JoinColumns= 3
JoinRows= 1
Row=11.57
Column= 2
Value$=Cl_ZipCode$
Text$=xxxxxxxxxx
JoinColumns= 3
JoinRows= 1
Column= 7
Value$=ZipCode$
Text$=xxxxxxxxxx
JoinColumns= 3
JoinRows= 1
Row=11.57
Row=11.57
Column= 4
Value$=Attention:
Font$=Arial,-10,B
Align$=TR
JoinColumns= 2
JoinRows= 1
Column= 7
Value$=Cl_ContactName$
Text$=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
JoinColumns= 3
JoinRows= 1
Row=11.57
Row=16.07
Column= 1
Value$=Account #
Font$=Arial,-10,B
Align$=TC
TopBorder= 1
LeftBorder= 1
BottomBorder= 1
RightBorder= 1
Column= 2
Value$=Customer Phone
Font$=Arial,-10,B
Align$=TC
TopBorder= 1
BottomBorder= 1
RightBorder= 1
JoinColumns= 2
JoinRows= 1
Column= 4
Value$=Payment Type
Font$=Arial,-10,B
Align$=TC
TopBorder= 1
BottomBorder= 1
RightBorder= 1
JoinColumns= 3
JoinRows= 1
Column= 7
Value$=Sales Rep
Font$=Arial,-10,B
Align$=TC
TopBorder= 1
BottomBorder= 1
RightBorder= 1
JoinColumns= 3
JoinRows= 1
Row=14.14
Column= 1
Value$=ClientId$
Text$=000000
Align$=TC
LeftBorder= 1
BottomBorder= 1
RightBorder= 1
Column= 2
Value$=STR(Cl_PhoneNumber$:"000-000-0000")+TBL(Cl_PhoneExtension$<>"",""," x"+Cl_PhoneExtension$)
Text$=xxxxxxxxxxxxxxxxxx
Align$=TC
BottomBorder= 1
RightBorder= 1
JoinColumns= 2
JoinRows= 1
Column= 4
Value$=TBL(POS(PaymentType$="$CMV"),"","Cash","Cheque","MasterCard","Visa")
Text$=xxxxxxxxxxxx
Align$=TC
BottomBorder= 1
RightBorder= 1
JoinColumns= 3
JoinRows= 1
Column= 7
Value$=Sr_Name$
Text$=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Align$=TC
BottomBorder= 1
RightBorder= 1
JoinColumns= 3
JoinRows= 1
Row=18.64
Row=14.79
Column= 1
Value$=Quantity
Font$=Arial,-10,B
Align$=TC
TopBorder= 1
LeftBorder= 1
BottomBorder= 1
RightBorder= 1
Column= 2
Value$=Product Code
Font$=Arial,-10,B
Align$=TC
TopBorder= 1
BottomBorder= 1
RightBorder= 1
Column= 3
Value$=Product Description
Font$=Arial,-10,B
Align$=TC
TopBorder= 1
BottomBorder= 1
RightBorder= 1
JoinColumns= 5
JoinRows= 1
Column= 8
Value$=Unit Cost
Font$=Arial,-10,B
Align$=TC
TopBorder= 1
BottomBorder= 1
RightBorder= 1
Column= 9
Value$=Total
Font$=Arial,-10,B
Align$=TC
TopBorder= 1
BottomBorder= 1
RightBorder= 1
Break=Detail L1
Row=12.86
Column= 1
Value$=Itm_ItemQty
Text$=###,##0
Align$=TC
LeftBorder= 1
RightBorder= 1
Column= 2
Value$=Itm_ProductCode$
Text$=xxxxxxxxxx
Align$=TC
RightBorder= 1
Column= 3
Value$=Itm_ItemDescription$
Text$=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
RightBorder= 1
JoinColumns= 5
JoinRows= 1
Column= 8
Value$=Itm_Price
Text$=#,##0.00
Align$=MR
RightBorder= 1
Column= 9
Value$=Itm_CalcPrice
Text$=##,###,##0.00
Align$=MR
RightBorder= 1
Break=Footer 01 InvoiceNumber
Row=11.57
Column= 1
Value$=
TopBorder= 1
JoinColumns= 9
JoinRows= 1
Row=11.57
Column= 7
Value$=Merchandise Total:
Font$=Arial,-10,B
Align$=TR
JoinColumns= 2
JoinRows= 1
Column= 9
Value$=Amount
Text$=##,###,##0.00
Align$=MR
Row=11.57
Column= 7
Value$=Tax:
Font$=Arial,-10,B
Align$=TR
JoinColumns= 2
JoinRows= 1
Column= 9
Value$=Tax
Text$=##,###,##0.00
Align$=MR
Row=11.57
Column= 1
Value$=Due Date:
Font$=Arial,-10,B
Column= 2
Value$=DueDate$
Text$=0000-00-00
Column= 7
Value$=Balance Due:
Font$=Arial,-10,B
Align$=TR
JoinColumns= 2
JoinRows= 1
Column= 9
Value$=Amount+Tax
Text$=##,###,##0.00
Align$=MR
Row=11.57
Column= 1
Value$=
BottomBorder= 1
JoinColumns= 9
JoinRows= 1
Break=Footer 00
Break=Footer PG
