Estimates / Quotes that have NOT been Converted to Bill

Show quotes or estimates that have NOT been converted to a bill.
Conversions are only recorded from v7.1.1
Create as export spreadsheet so the can export to csv

select BM."Ref_Number" "Transaction Num",

case when BM."Type" = 7 then 'Quote'

     else 'Estimate' end "Bill Type",

CM."First_Name", CM."Last_Name", BM."Total", BM."Dis_Date" "Creation Date", BM."Cur_Staff" "Staff"

from "Bill_Main" BM

join "Client_Main" CM on CM."Ref_Number" = BM."Cln_Number"

where "Dis_Date" between :Datelo/*Created From*/  and :Datehi/*To*/

and BM."Type" in (7,8)

and "InBitValue" (512, "Bill_Prop") = 'N'

and BM."Acc_State" <> 59

• Related Articles

• Estimates / Quotes that have been Converted to Bill

  Show quotes or estimates that have been converted to a bill. We don't have way of showing which bills it has been converted to and will only record conversions from v7.1.1 Create as export spreadsheet so the can export to csv select BM."Ref_Number" ...

• Bill Email Templates

  Default Billing Template There is a default bill email template in; Options -> Picklists Setup -> Bill -> Bill Email Templates -> double click Email Bill template to edit If no custom templates are enabled then the default templates is used for all ...

• Creating a Prescriptions for Pharmacy from Bill

  To make prescriptions for drugs that are not kept in stock a Create Prescription options exists under the Actions button at billing. This creates a document that is stored in the Patient document manager under a prescription tab. A mail merge ...

• GAP - wrong payment method

  For GAP payment bills Check status of the claim, should be Pmt Submitted. Find the GAP payment bill and reverse existing bill. In Ibview got to Claim_Main table and find the claim and set the status back to Awaiting Payment (8). Make payment from the ...

• Version 7 Video Practice Checklist

  Printable checklist for Staff General Know how to access training videos Know how to Show / Hide menus Know how to customise window size to fit to workstations monitor size Know how to adjust column width Know how to Show / Hide columns Client / ...