Home › Discussions › Questions & Answers › Question about enhancement of report

Question about enhancement of report

Avatar photoCustomer Questions & Answers 1 reply

Hello,

I wanted to ask about enhancing one of reports, CE Bank Statement and Reconciliation.

Our finance department expressed it would be useful to include original amounts for credit and debit.

I had a look and needed data is in table gl_je_lines as accounted_dr or accounted_cr and for receipts in table ar_cash_receipt_history_all as acctd_amount.

SQL query is fairly complex and would take time for me to adjust and it was mentioned that enhancements can be done by Enginatics if judged as useful for all customers.

1 reply

  • Support Enginatics

    Hi,

    I have added the following 2 columns to the report

    Trx Original Amount – the original transaction amount in entered currency
    Trx Original Amount Acctd – the original transaction amount in functional currency

    There was already a column in the report called Trx Original Amount, but this comes from the statement line rather than from the reconciled transactions, so this has been relabeled as

    Line Original Amount – the original amount recorded on the statement line

    Please find attached the updated report definition XML file you can import into Blitz Report.

    Kind Regards,

    Eric

    Attachments:
    1. CE_Bank_Statement_and_Reconciliation_20240327_1.zip
  • You must be logged in to reply to this post.