Solved

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

  • 10 October 2023
  • 2 replies
  • 32 views

Userlevel 4
Badge

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!

icon

Best answer by Laura02 10 October 2023, 04:38

View original

2 replies

Badge +18

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

Userlevel 4
Badge

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

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved