I am trying to extract a report from AP which will list the current amt of every invoice outstding from every vendor. I selected "current transactions", and then "current amt" from the menu. When I ran the report, I noticed that the report skipped those invoices where part-payment had been made. Next, I try selecting "amt payable", which still doesn't display invoices 'with part-payments. Is there something that I am doing wrong? I would like the report the display the net balances outstding. Thanks in adv for yr replies.

Hi Danny,

If you know that records you expected to see on your report are not selected, the usual culprit is the selection formula or range.

What I would suggest is to temporarily remove the entire selection formula and print, to verify that the records you want do appear (ie partially paid invoices). Also insert into your report the fields you intend to base the record selection upon. This is a check so that when you enter your record selection formula, you can determine which records will and won't be selected.

The current amount field is probably what you want, but the selection formula may need to be based upon this field being greater than zero, rather than a status field. The testing above should point out to you which fields would work.