Re: Quest for information: Accounts Receivables/Payables Values

["Chris Travers" <..hidden..>]

Hi Charley;

On second view, the problem is likely to be in your acc_trans table.  You are just searching AR and AP transaction summary records (which we should probably properly normalize in 1.4).  You want to be searching the account line items instead.

Try something like:

select sum(amount) from acc_trans where chart_id = (select id from chart where accno = [ar_account_number]) and trans_date <= [balance_sheet_date]);


Best Wishes,
Chris Travers