Probably the only way possible would be to export both reports, then merge and sort within a spreadsheet program.
Alternatively, in agreement with your customer/supplier you could contra the accounts receivable/accounts payable so there is only one balance. In agreement, as they may not have the same capabilities within their system - see below