SELECT Revenue_Code.Rev_CodeID, Revenue_Code.Visit_Type, Revenue_Code.Description, Revenue_Code.Payer_ID, Revenue_Code.Quick_Books_Price, Payer.Payer_ID, Payer.Output_Type FROM #Request.prefix_db_agency#.Revenue_Code, #Request.prefix_db_agency#.Payer WHERE Revenue_Code.Agency_ID = #session.AgencyID# AND Payer.Payer_ID = Revenue_Code.Payer_ID AND Payer.Output_Type = 'Medicare' AND Revenue_Code.Visit_Type NOT LIKE 'Assessment' AND Revenue_Code.Visit_Type NOT LIKE 'Evaluation' AND Revenue_Code.Visit_Type NOT LIKE 'Private Duty Nursing' AND Revenue_Code.Visit_Type NOT LIKE 'Homemaker' AND (Revenue_Code.QB_Export = 0 or Revenue_Code.QB_Export IS Null) SELECT Revenue_Code.Rev_CodeID, Revenue_Code.Visit_Type, Revenue_Code.Description, Revenue_Code.Payer_ID, Revenue_Code.Quick_Books_Price, Payer.Payer_ID, Payer.Output_Type FROM #Request.prefix_db_agency#.Revenue_Code, #Request.prefix_db_agency#.Payer WHERE Revenue_Code.Agency_ID = #session.AgencyID# AND Payer.Payer_ID = Revenue_Code.Payer_ID AND Payer.Output_Type <> 'Medicare' AND (Revenue_Code.QB_Export = 0 or Revenue_Code.QB_Export IS Null) UPDATE #Request.prefix_db_agency#.Revenue_Code SET QB_Export = 1 WHERE Agency_ID = #session.AgencyID#

Agency Administration - Lists Ready for Export to QuickBooks

The list of new revenue codes has been prepared for export. Right click on the hyperlink
below and click Save Target As...

Save file to your desktop