We have 6 of these invoice types (6 different customers) that have not yet
been paid, but their amounts are currently not included into the customers'
balances. 5 of these were created when we were using Emerald 2.1 and one
was created today (few days after upgrading to 2.5).
I don't know if adding them in will cause problems in the future or not.
If they shouldn't be added in, then I need to take the sum(Invoices.Amount)
for unpaid invoices of Type='Invoice' and add that to
sum(MasterAccounts.Balance) for active MBRs to obtain an accurate account's
I've already completely redone our Monthly Sales and Monthly Payments
reports (run via ISQL) and still have to redo the Accounts Receivable one.