The AP reporting seems incl. those paid, but unpresented payment/cheques. Example, we’ve issued a cheque and book the payment on 27.12.17 of $100 for inv.#2017 for Supplier A, but the cheque was cleared only on 03Jan18 as per bank statement. However, in AP Aged report and SOA of Supplier A as at 31.12.17 or 01.01.18 the inv#2017 of $100 still listed, could you please advise how to excl. the paid but unpresented/in transit payment?
I cannot reproduce this behavior. Once a payment has been entered against an open payable, whether cleared or pending, Accounts payable is reduced by the amount of the payment. The Aged Payables report no longer shows the payable. And a Supplier Statement reflects the payment.
Can you post a screen shot of the payment entry screen for a payment you believe is not being properly reported? Also, what edition (desktop/server/cloud) edition and version number are you using?