<%@ Control Language="C#" AutoEventWireup="true" CodeFile="debtorsReports.ascx.cs" Inherits="controls_module_debtorsReports" %> <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

Reports

Report Selection

Report Type

eRA Status

Process Status

From Date

To Date

Report Results

Patient No	Surname	Name	Med Aid	Med No	Invoiced	Paid	Due	0-30 Days	30-60 Days	60-90 Days	90-120 Days	120+ Days	Last Invoiced	Last Paid
<%#DataBinder.Eval(Container, "DataItem.PatientNum")%>
			Totals:

Patient No	Surname	Name	Invoiced	Paid	Due	0-30 Days	30-60 Days	60-90 Days	90-120 Days	120+ Days
<%#DataBinder.Eval(Container, "DataItem.PatientNum")%>
		Totals:

	Patient No	Surname	Name	Invoiced	Paid	Due	0-30 Days	30-60 Days	60-90 Days	90-120 Days	120+ Days

			Totals:

Patient No	Member	Due	Due To Assistant (Incl. VAT)	VAT Amount	Due To Assistant (Excl. VAT)	Payable To Assistant	Assistant
<%#DataBinder.Eval(Container, "DataItem.PatientNum")%>							<%#DataBinder.Eval(Container, "DataItem.Assistant")%>

Assistant / Specialist	Due To Assistant (Incl. VAT)	VAT Amount	Due To Assistant (Excl. VAT)	Payable To Assistant	Paid YTD	Paid YTD
<%#DataBinder.Eval(Container, "DataItem.Assistant_Specialist")%>
Totals :

Date & Time	Invoice Authorized BY	Invoice Number	Patient Number	Patient	Medical Aid	Invoiced Amount (excl Assistant Fee)	Assistant Fee	VAT	Total Billing
<%#DataBinder.Eval(Container, "DataItem.InvoicedDateTime")%>	<%#DataBinder.Eval(Container, "DataItem.InvoiceAuthorizedBy")%>	<%#DataBinder.Eval(Container, "DataItem.InvoiceNumber")%>	<%#DataBinder.Eval(Container, "DataItem.PatientNumber")%>	<%#DataBinder.Eval(Container, "DataItem.Patient")%>	<%#DataBinder.Eval(Container, "DataItem.MedicalAid")%>

Date	Payment Receipting Authorized BY	Receipt Number	Patient Number	Patient	Medical Aid	Payment Method	Invoices	Total Receipted Amount (incl Assistant Fee)	Amount paid to Assistant fee
<%#DataBinder.Eval(Container, "DataItem.PaymentDateTime")%>	<%#DataBinder.Eval(Container, "DataItem.PaymentReceiptingAuthorizedBy")%>	<%#DataBinder.Eval(Container, "DataItem.ReceiptNumber")%>	<%#DataBinder.Eval(Container, "DataItem.PatientNumber")%>	<%#DataBinder.Eval(Container, "DataItem.Patient")%>	<%#DataBinder.Eval(Container, "DataItem.MedicalAid")%>	<%#DataBinder.Eval(Container, "DataItem.PaymentMethod")%>	<%#DataBinder.Eval(Container, "DataItem.Invoices")%>

Date & Time	Debit Note Authorized BY	Debit Note Number	Patient Number	Patient	Medical Aid	Note	Debit Note Amount (excl. VAT)	VAT Amount	Total Debit Note amount
<%#DataBinder.Eval(Container, "DataItem.DebitNoteDateTime")%>	<%#DataBinder.Eval(Container, "DataItem.DebitNoteAuthorizedBy")%>	<%#DataBinder.Eval(Container, "DataItem.DebitNoteNumber")%>	<%#DataBinder.Eval(Container, "DataItem.PatientNumber")%>	<%#DataBinder.Eval(Container, "DataItem.Patient")%>	<%#DataBinder.Eval(Container, "DataItem.MedicalAid")%>	<%#DataBinder.Eval(Container, "DataItem.Note")%>

Date & Time	Credit Note Authorized BY	Credit Note Number	Patient Number	Patient	Medical Aid	Note	Credit Note Amount (excl. VAT)	VAT Amount	Total Credit Note amount
<%#DataBinder.Eval(Container, "DataItem.CreditNoteDateTime")%>	<%#DataBinder.Eval(Container, "DataItem.CreditNoteAuthorizedBy")%>	<%#DataBinder.Eval(Container, "DataItem.CreditNoteNumber")%>	<%#DataBinder.Eval(Container, "DataItem.PatientNumber")%>	<%#DataBinder.Eval(Container, "DataItem.Patient")%>	<%#DataBinder.Eval(Container, "DataItem.MedicalAid")%>	<%#DataBinder.Eval(Container, "DataItem.Note")%>

<%----%> <%----%>

Date	eRA Status	eRA Reference No	Processed Status	Receipt Number	Patient Number	Patient	Date of Birth	ID Number	Medical Aid	Claim Amount	Paid Amount / Journal Amount	Response Description / Journal Description	General Comments	Disclaimer
	<%#DataBinder.Eval(Container, "DataItem.EraStatus")%>	<%#DataBinder.Eval(Container, "DataItem.EraReferenceNumber")%>	<%#DataBinder.Eval(Container, "DataItem.ProcessedStatus")%>	<%#DataBinder.Eval(Container, "DataItem.ReceiptNumber")%>	<%#DataBinder.Eval(Container, "DataItem.PatientNumber")%>	<%#DataBinder.Eval(Container, "DataItem.Patient")%>		<%#DataBinder.Eval(Container, "DataItem.patientIdNumber")%>	<%#DataBinder.Eval(Container, "DataItem.MedicalAid")%>			<%#DataBinder.Eval(Container, "DataItem.ResponseDescription")%>	<%#DataBinder.Eval(Container, "DataItem.GeneralComments")%>	<%#DataBinder.Eval(Container, "DataItem.Disclaimer")%>

Fiscal Period	Calendar Period	Opening Balance	Invoices	Receipts	Credit Notes	Debit Notes	Closing Balance
<%#DataBinder.Eval(Container, "DataItem.FiscalPeriod")%>	<%#DataBinder.Eval(Container, "DataItem.CalendarDate")%>

Patient Number	Patient Name	Patient Surname	Medical Aid	Invoice Number	Invoice Date	Procedures	Invoiced Amount	Claimable	Claimed Not Paid	Paid By Medical Aid	Total Paid	Claim Sent	Claim Date	Claim Number	Response Result	Responding Party	Delivery Type	Allow Reversal	Allow Force Fetch	Allow Resubmit
<%#DataBinder.Eval(Container, "DataItem.patientNumber")%>	<%#DataBinder.Eval(Container, "DataItem.patientName")%>	<%#DataBinder.Eval(Container, "DataItem.patientSurname")%>	<%#DataBinder.Eval(Container, "DataItem.medicalAid")%>	<%#DataBinder.Eval(Container, "DataItem.invoiceNo")%>		<%#DataBinder.Eval(Container, "DataItem.procedures")%>								<%#DataBinder.Eval(Container, "DataItem.claimNumber")%>	<%#DataBinder.Eval(Container, "DataItem.ResponseResult")%>	<%#DataBinder.Eval(Container, "DataItem.RespondingParty")%>	<%#DataBinder.Eval(Container, "DataItem.DeliveryType")%>

Invoices

Date & Time	Invoice Authorized BY	Invoice Number	Patient Number	Patient	Medical Aid	Invoiced Amount (excl Assistant Fee)	Assistant Fee	VAT	Total Billing
<%#DataBinder.Eval(Container, "DataItem.InvoicedDateTime")%>	<%#DataBinder.Eval(Container, "DataItem.InvoiceAuthorizedBy")%>	<%#DataBinder.Eval(Container, "DataItem.InvoiceNumber")%>	<%#DataBinder.Eval(Container, "DataItem.PatientNumber")%>	<%#DataBinder.Eval(Container, "DataItem.Patient")%>	<%#DataBinder.Eval(Container, "DataItem.MedicalAid")%>
							Totals:

Receipts

Date	Payment Receipting Authorized BY	Receipt Number	Patient Number	Patient	Medical Aid	Payment Method	Amount paid to Assistant fee	Total Receipted Amount (incl Assistant Fee)
<%#DataBinder.Eval(Container, "DataItem.PaymentDateTime")%>	<%#DataBinder.Eval(Container, "DataItem.PaymentReceiptingAuthorizedBy")%>	<%#DataBinder.Eval(Container, "DataItem.ReceiptNumber")%>	<%#DataBinder.Eval(Container, "DataItem.PatientNumber")%>	<%#DataBinder.Eval(Container, "DataItem.Patient")%>	<%#DataBinder.Eval(Container, "DataItem.MedicalAid")%>	<%#DataBinder.Eval(Container, "DataItem.PaymentMethod")%>
							Totals:

Debit Notes

Date & Time	Debit Note Authorized BY	Debit Note Number	Patient Number	Patient	Medical Aid	Note	Debit Note Amount (excl. VAT)	VAT Amount	Total Debit Note amount
<%#DataBinder.Eval(Container, "DataItem.DebitNoteDateTime")%>	<%#DataBinder.Eval(Container, "DataItem.DebitNoteAuthorizedBy")%>	<%#DataBinder.Eval(Container, "DataItem.DebitNoteNumber")%>	<%#DataBinder.Eval(Container, "DataItem.PatientNumber")%>	<%#DataBinder.Eval(Container, "DataItem.Patient")%>	<%#DataBinder.Eval(Container, "DataItem.MedicalAid")%>	<%#DataBinder.Eval(Container, "DataItem.Note")%>
							Totals:

Credit Notes

Date & Time	Credit Note Authorized BY	Credit Note Number	Patient Number	Patient	Medical Aid	Note	Credit Note Amount (excl. VAT)	VAT Amount	Total Credit Note amount
<%#DataBinder.Eval(Container, "DataItem.CreditNoteDateTime")%>	<%#DataBinder.Eval(Container, "DataItem.CreditNoteAuthorizedBy")%>	<%#DataBinder.Eval(Container, "DataItem.CreditNoteNumber")%>	<%#DataBinder.Eval(Container, "DataItem.PatientNumber")%>	<%#DataBinder.Eval(Container, "DataItem.Patient")%>	<%#DataBinder.Eval(Container, "DataItem.MedicalAid")%>	<%#DataBinder.Eval(Container, "DataItem.Note")%>
							Totals:

R 0.00 Total VAT:

R 0.00 Total:

<%-- --%>