Is it possible to add a column of "opposite account(s)" on the report of "Transactions for Period"?

Question

Hi All,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!

Laura02 · Accepted Answer

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.Good luck!Laura

shuang57 · Answer

Hi Laura, really appreciate your input, and that’s also my concern. Anyway I’ll preparethe reportmanually for the moment. Thank you!

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded