SELECT pDeposit_temp.*,pPayer.Pay_Name FROM #Request.prefix_db_lookup#.pDeposit_temp
JOIN #Request.prefix_db_agency#.pPayer ON pDeposit_temp.Payer_ID = pPayer.Pay_ID
WHERE pDeposit_temp.Status = 0
AND pDeposit_temp.Dep_ID =
SELECT Dep_ID FROM #Request.prefix_db_agency#.pDeposit
WHERE Remit_No =
AND Status = 0
SELECT Invoice_ID,Internal_Control_number FROM #Request.prefix_db_agency#.Invoices
WHERE deleted = 0
AND Invoice_ID =
SELECT * FROM #Request.prefix_db_agency#.pSchedules
WHERE (pSchedules.NOA = #variables.Invoiceid# OR pSchedules.Invoice_ID = #variables.Invoiceid#)
AND pSchedules.Status = 0
GROUP BY pSchedules.Schedule_ID
INSERT INTO #Request.prefix_db_agency#.pDeposit
( Status, Payer_ID, Date_Create, Date_Deposit, Date_Check, Deposit_Type, Check_Total,Total_Provider,Remit_No,
Internal_Control_number, Pay_Name,
Net_Total, Record_Created_Date, Record_Created_By, Record_Modified_Date, Record_Modified_By)
VALUES(
,
,
,
,
,
'Check',
,
,
,
,
,
,
,
,
,
)
INSERT INTO #Request.prefix_db_agency#.Payments (
invoice_id, patientpayer_id, paymentdate, amount, paymentmethod, comments, writeoffamount,EFT_Amount,EFT_No,
Claim, writeofftype,Record_Created_By,Record_Created_Date,Record_Modified_By,Record_Modified_Date
) VALUES (
,
,
,
,'Check'
,'Updated by new remittance'
,'#total_writeoffamount#'
,0.00
,
,
,NULL
,'#Session.EmployeeId#'
,#now()#
,'#Session.EmployeeId#'
,#now()#
)
SELECT * FROM #Request.prefix_db_agency#.pSchedules
WHERE AutoSchedule_ID =
AND Status = 0
pgcfc = CreateObject("Component", "components.general.progressnotes");
retiredschedules = pgcfc.retire_schedules(#getcurrentschd.Schedule_ID#);
You may be giving wrong data in the visit form, so error occured while updating the schedule visit.
So please go back and correct it or contact your admin.
Something wen wrong. So please click here to back