SELECT Payer.PayName, Agency.Agency_Name, Payer.Output_Type, Payer.Payer_ID
FROM #Request.prefix_db_agency#.Payer, #Request.prefix_db_lookup#.Agency
WHERE Payer.Payer_ID IN (#Form.Payer#)
Where Payer.Agency_ID = Agency.Agency_ID
AND Agency.Status = 'active'
AND Agency.QBInUse = 1
AND Payer.Output_Type <> 'Medicare'
AND Payer.QB_Export = 0
Order by Agency_Name
UPDATE #Request.prefix_db_agency#.Payer
SET QB_Export = 1
WHERE Payer_ID = #GetPayer.Payer_ID#
Payers Exported to QuickBooks
Payers have been prepared for export. Right click on the hyperlink below and click Save Target As...