ISInvoiceLine.ChildLines

Example

Display the number of the invoices loaded on the basis of the selected filter and some information about the invoice lines, including the child lines.

Dim aPatient
Dim aFilter
Dim aInvoices, aInvoice
Dim aInvoiceLines, aInvoiceLine
Dim aChildLines, aChildLine 
Dim aMessage
Dim i, j, k    

Set aPatient = Profile.SelectPatient
set aFilter = Profile.CreateInvoiceFilter
aFilter.PatientId = aPatient.ID
set aInvoices = aFilter.Load

aMessage = "Invoices Count = " & aInvoices.Count & vbNewLine

for i = 0 to aInvoices.Count - 1
  set aInvoice = aInvoices.Items(i)
  set aInvoiceLines = aInvoice.InvoiceLines 
  aMessage = aMessage & vbNewLine & (i + 1) & ". " &_
    "Date: " & aInvoice.Date & vbNewLine &_
    "    Invoice Lines Count: " & aInvoiceLines.Count & vbNewLine 
  for j = 0 to aInvoiceLines.Count - 1
    set aInvoiceLine = aInvoiceLines.Item(j)
    set aChildLines = aInvoiceLine.ChildLines 
    aMessage = aMessage & (i + 1) & "." & (j + 1) &_
      " -Description: " & aInvoiceLine.Description & vbNewLine &_
      "      -DateTime From: " & aInvoiceLine.DateTimeFrom & vbNewLine &_
      "      -DateTime To: " & aInvoiceLine.DateTimeTo & vbNewLine &_
      "      -Child Lines Count = " & aChildLines.Count & vbNewLine 
    for k = 0 to aChildLines.Count - 1
      set aChildLine = aChildLines.Item(k) 
      aMessage = aMessage & vbTab & (k + 1) & ". " & aChildLine.Description & vbNewLine
    next 'k   
  next 'j    
next 'i    

Profile.MsgBox(aMessage)