The overdue balance field seems to be giving some odd numbers. for instance customer MJC272 overdue balance is 25K where as total balance is £20K
*On the customer record, the Balance field computes of all open invoices whether due or not, unapplied payments, unapplied credit memos and accounts receivable lines on journal entries.
* On the customer record, the Overdue field computes all due invoices and accounts receivable lines on journal entries only. Unapplied payments and unapplied credit memos are disregarded from the computation.
for the overdue field can it include the unapplied payments and unapplied credits too so it is giving us true picture??
maybe by creating a custom field? if this can be done, please let me know how.
e.g - 3 custom fields one showing applied, one showing unapplied, and then subtracting from one another. only 1 field should be showing