We are currently migrating from Oracle Netsuite, so bare with me.
I would like to allocate an advance payment (recorded via Payment entry against a Sales order) with a submitted invoice. Payment Reconciliation tool is to be used for this purpose.
Now here is the problem - the advanced payment should be booked against a different balance sheet account than the sales invoice. Sales invoice is booked as debit - Account receivable. However, the advance payment from is treated as a liability of the business, see this very good explanation:
Payment Reconciliation tool requires one receivable/payable account:
But sales invoice is booked to a different account:
Therefore, is there a way to match the records?