We would like to have a report similar to “Transactions for Period”, but for each transaction under each account, is there any way to show the “opposite account”?
For example, here’s an entry that has been recorded.
Debit: 4600 Administration Expenses 600 USD
Credit: 1005 Citi USD Bank Account 600 USD
For this transaction under “1005 Citi USD Bank Account”, we’d like another column showing that the opposite account is “4600 Administration Expenses”. Same for the transaction under “4600 Administration Expenses”.
Is there any way to achieve that? Thanks!
Best answer by Laura02
Hello,
You can try joining debit to credit on the batch number and reference number field.
However, think it will be very difficult to accurately match “opposite account” because batches can potentially have many debits and many credits. Acumatica doesn’t “tie” lines of the posted GL batch to other lines, with key fields, even when the amount of debit = amount of credit. You may get lucky sometimes, when a batch has only two lines, or when only two lines have matching amounts, or when only two lines have populated and matching reference number field.
You can try joining debit to credit on the batch number and reference number field.
However, think it will be very difficult to accurately match “opposite account” because batches can potentially have many debits and many credits. Acumatica doesn’t “tie” lines of the posted GL batch to other lines, with key fields, even when the amount of debit = amount of credit. You may get lucky sometimes, when a batch has only two lines, or when only two lines have matching amounts, or when only two lines have populated and matching reference number field.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
