How can I address the following problem?
Trade Creditors have a Vendor Liability Account of (say) 21000
Related Company Creditors have a Vendor Liability Account of (say) 25000.
In the balance sheet 25000 (and 21000) can be displayed in the appropriate location and will show the correct values provided there are no unallocated payment amounts.
However, if a payment has been made (say just a cash transfer in anticipation of a subsequent invoice) then this payment will be sitting in the single "Payment Selection" account which is probably grouped with Trade Creditors in the balance sheet. This results in the balances in the balance sheet being incorrect for both trade creditors and related company creditors.
In BP>Vendor>Accounting there are three account codes stored,
..Vendor Service Liability
A solution would be to also set the "Payment Selection" account (and its AR equivalent) on a per BP basis so that any value in the Payment Selection for related companies could be displayed in the correct section of the balance sheet.
Is there any other solution that you can suggest other than monthly journals?