[Emerald] balances

Josh Hillman ( (no email) )
Thu, 17 Jun 1999 21:23:17 -0400

If a customer has an invoice created of Invoice.Type='Invoice', should
Invoice.Amount be included in MasterAccounts.Balance?

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
receivable listing.

I've already completely redone our Monthly Sales and Monthly Payments
reports (run via ISQL) and still have to redo the Accounts Receivable one.


Emerald 2.5.278