%@ Control Language="C#" AutoEventWireup="true" CodeFile="debtorsReports.ascx.cs" Inherits="controls_module_debtorsReports" %> <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
| 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")%> |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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")%> |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Patient No | Surname | Name | Invoiced | Paid | Due | 0-30 Days | 30-60 Days | 60-90 Days | 90-120 Days | 120+ Days |
|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
|
|---|---|---|---|---|---|---|
| <%#DataBinder.Eval(Container, "DataItem.Assistant_Specialist")%> |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 | 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")%> |
|
|
| Date & Time | Debit Note Authorized BY | Debit Note Number | Patient Number | Patient | Medical Aid | 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")%> |
|
|
|
| Date & Time | Credit Note Authorized BY | Credit Note Number | Patient Number | Patient | Medical Aid | 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")%> |
|
|
|
| Fiscal Period | Calendar Period | Opening Balance | Invoices | Receipts | Credit Notes | Debit Notes | Closing Balance |
|---|---|---|---|---|---|---|---|
| <%#DataBinder.Eval(Container, "DataItem.FiscalPeriod")%> | <%#DataBinder.Eval(Container, "DataItem.CalendarDate")%> |
|
|
|
|
|
|