FMS - Multi School Reporting APIs Cash Summary

FMS Cross School Reporting APIs

NB: Access subject to customer licence

        private XmlDocument btCLFP_ExportSummaryCashFlow()
        {
            var extractor = new CSFMSCSRExport.CsrExporter(tbServer.Text, tbDatabase.Text, tbUsername.Text, tbPassword.Text);
            var result = extractor.ExportSummaryCashflow() as XmlDocument;
            return result;
        }

Yields:

<?xml version="1.0" encoding="utf-8"?>
<CashFlow>
  <Header>
    <SchoolName>Waters Edge School</SchoolName>
    <SchoolNumber>2999</SchoolNumber>
    <LANumber>823</LANumber>
    <ExportDateTime>2023-04-05T11:41:00+01:00</ExportDateTime>
    <SoftwareVersion>6.93.529</SoftwareVersion>
    <User>SYS</User>
  </Header>
  <BankAccountsTotal>
    <Description>Bank Accounts</Description>
    <RecType>BK</RecType>
    <BankAccountsTotal>92033.32</BankAccountsTotal>
  </BankAccountsTotal>
  <TransactionHeader>
    <TransactionType>Unpaid AP Transactions</TransactionType>
    <RecType>AP</RecType>
    <SumPeriod1>0.00</SumPeriod1>
    <SumPeriod2>0.00</SumPeriod2>
    <SumPeriod3>0.00</SumPeriod3>
  </TransactionHeader>
  <TransactionHeader>
    <TransactionType>Recurring Expenditure</TransactionType>
    <RecType>RP</RecType>
    <SumPeriod1>0.00</SumPeriod1>
    <SumPeriod2>0.00</SumPeriod2>
    <SumPeriod3>0.00</SumPeriod3>
  </TransactionHeader>
  <TransactionHeader>
    <TransactionType>Salary Expenditure</TransactionType>
    <RecType>SA</RecType>
    <SumPeriod1>0.00</SumPeriod1>
    <SumPeriod2>0.00</SumPeriod2>
    <SumPeriod3>0.00</SumPeriod3>
  </TransactionHeader>
  <TransactionHeader>
    <TransactionType>Income</TransactionType>
    <RecType>IN</RecType>
    <SumPeriod1>0.00</SumPeriod1>
    <SumPeriod2>0.00</SumPeriod2>
    <SumPeriod3>0.00</SumPeriod3>
  </TransactionHeader>
  <TransactionFooter>
    <TransactionType>Outstanding Accounts Receivable</TransactionType>
    <RecType>AR </RecType>
    <SumPeriod1>2260.00</SumPeriod1>
  </TransactionFooter>
  <TransactionFooter>
    <TransactionType>Purchase Orders</TransactionType>
    <RecType>PO </RecType>
    <SumPeriod1>-9040.23</SumPeriod1>
  </TransactionFooter>
  <TransactionFooter>
    <TransactionType>VAT Balance</TransactionType>
    <RecType>VA </RecType>
    <SumPeriod1>888.54</SumPeriod1>
  </TransactionFooter>
</CashFlow>