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.
Viewing 0 reply threads
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 currencyThere 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
Viewing 0 reply threads
- You must be logged in to reply to this post.
Login with:
Popular Posts
Blog Archive
2026
March (2)
February (2)
2025
June (1)
March (1)
February (2)
January (1)
2024
October (1)
September (1)
August (1)
2023
December (2)
September (1)
July (3)
April (2)
2022
2021
December (2)
November (1)
October (1)
April (1)
2020
- EBS SQL to Excel reporting with Blitz Report for non-developers 1229
- Getting all horizontal with ASCP planning 3945
- How to use EBS audit functionality to speed up operations 4114
- Accessing external data sources with Blitz Report™ 2220
- Does Oracle Discoverer 11g work with Oracle Database 19c? 4247
- Blitz Report™ Champion – quarterly awards announcement 1689
- Can data governance be free? 3489
- EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6488
- Ungarbling Oracle EBS Financial Accounting 3737
- Discover the secret of perfectly formatted Oracle EBS Excel report creation in under 10 minutes 4286
- A simpler way to work with Automatic Workload Repository (AWR) 3559
- Blitz Report Champion – absence visualization in Oracle EBS 1845
- Oracle E-Business Suite – concurrent request monitoring and alert reporting 6282
- Oracle Enterprise Command Center Framework upgrade to V4 3747
- How to quickly create or modify Oracle E-Business Suite BI Publisher based reports 5665
- How to replace Oracle ASCP exceptions with Blitz Report 2948
- How to add Blitz Report™ to your favorite form 3200
- How to create a Delivery in Full On Time metric in Oracle E-Business Suite using Blitz Report™ 3820
- Oracle E-Business Suite Inventory period-end optimization / close 4114
- Oracle Supply Chain Hub that takes simplicity to another level 5825
- How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123803
- How to put the Advanced functions into Oracle EBS Supply Chain Planning (ASCP) 4293
- How to optimize Order Management form exports in Oracle EBS 3792
December (2)
October (4)
September (2)
July (8)
June (3)
April (8)
March (7)
2019
October (1)
August (2)
June (2)
May (1)
2018
November (2)
January (1)
2017
November (1)
September (1)
Recent Events
2026
June (3)
March (1)
February (1)
2025
- High Performance, Low Cost: Optimizing E-Business Suite in the Cloud
- Beat the Heat! Lightning Fast E-Business Suite Report Generation and Data Loading (Customer Case Study)
- From XML Publisher to Nicely-Formatted Reports–How LiDestri Automated Oracle E-Business Suite Reporting (Customer Case Study)
- From Data Overhead to Data Overdrive. Supercharging E-Business Suite Processes at Ultradent (Customer Case Study)
- OBUG – AppsConnected25
- Ascend 2025
July (2)
November (4)
May (3)
June (6)
April (7)
March (8)
February (3)
January (3)
October (1)
2024
November (6)
October (7)
September (2)
April (5)
May (2)
February (1)
January (1)
2023
October (7)
November (7)
September (1)
June (3)
2022
November (2)
October (2)
May (3)
April (1)
September (1)
2021
- Blitz Report – Rel 3.2 – New features, improved workflow – EM
- Blitz Report – Rel 3.2 – New features, improved workflow – CT
- Blitz Report – Rel 3.2 – New features, improved workflow – PT
- Blitz Report – Release 3.2 – Customer Review – pd
- Blitz Report – Release 3.2 – Customer Review – ct
- Blitz Report – Release 3.2 – Customer Review – em
- DOUG: How to deliver EBS data directly to an Excel pivot table
- SROATUG: Worlds fastest EBS reporting introduces templates, pivots and drill-downs
- DOUG: Upgrading to 12.2? – How to use Enterprise Command Center Data WITHOUT a separate ECC Server
- MOUS: Two (2) Blitz Report™ talks – Dates/Times inside
- NYOUG: Running Oracle EBS on Cloud? Beware of this overlooked performance metric
- AUSOUG: Running EBS on Cloud? Be aware of this overlooked performance metric!
- Blitz Report transforms Oracle EBS reporting with 3 new features – pt
- Blitz Report transforms Oracle EBS reporting with 3 new features – ct
- Blitz Report transforms Oracle EBS reporting with 3 new features-em
- Blitz Report™ – 10 Ways to improve EBS Reporting
- On-Site Meet Up Space Reservations
- On-Site Meet Up Space Reservations
- EBS financial analysis with pivot tables – Reporting that won’t break the bank – pd
- EBS Financial analysis with Pivot tables – Reporting that won’t break the bank – cd
- EBS financial analysis with pivot tables – Reporting that won’t break the bank – em
- Ascend 2021 – Oracle Users Conference
- AUSOUG: Blitz Report™ – What’s new with the World’s fastest EBS reporting solution?
- Find your happiness – Blitz Report, the world’s fastest reporting for Oracle EBS
- Find your happiness – Blitz Report, the world’s fastest reporting for Oracle EBS – eu
- Webinar: Reconcile your inventory to G/L balances with ease, from 1-1,000 inventory organizations
- OATUG: Reconcile your inventory to G/L Balances with ease, from 1-1,000 inventory organizations
December (2)
November (4)
October (10)
September (5)
August (7)
June (5)
May (5)
April (5)
March (3)
2020
- Excel based ASCP Planner Workbench – A faster, easier approach
- Oracle EBS Enterprise Command Center – Reporting Toolkit – powered by Blitz Report
- Blitz Report Project Toolkit – Improve performance and get results
- EBS Reporting Solutions – Review before you Renew
- Review before you Renew – EBS Reporting Solutions
- DOUG Training Day 2020
- NCOATUG – EBS Project Toolkit for Implementation Consultants
- NCOATUG Talk: Blitz Report™ Data Migration Toolkit – A “must have” when starting a new Oracle EBS upgrade or implementation project
- EBS FORUM@2pm: Enterprise Command Centers (ECC) in Oracle 12.4 and up
- EBS FORUM@10am: Supply Chain Hub
- DCOUG Webinar – New Supply Chain Hub
- Webinar – Introducing Supply Chain Hub – 2020-05-21 PDT
- Webinar – Introducing Supply Chain Hub – 2020-05-19 GMT
- Webinar – Introducing Supply Chain Hub – 2020-05-18 EDT
- Webinar – Blitz Report Seamless Integration with Oracle EBS – 2020-05-22 EDT
- Webinar – Blitz Report Seamless Integration with Oracle EBS – 2020-05-20 GMT
- Webinar – Blitz Report Seamless Integration with Oracle EBS – 2020-05-19 CDT
December (4)
November (3)
October (8)
September (2)
August (2)
July (4)
June (5)
May (9)
January (1)
2019
- Gateway OATUG Kansas City Event
- TXLAOATUG Training Day, Houston
- GITEX Technology Week, Dubai
- UKOUG Partner of the Year Awards
- AUSOUG Connect 2019, Perth
- AUSOUG Connect 2019, Melbourne
- NWOAUG Portland OR
- BCOAUG – Fall Meeting
- UKOUG Analytics Modernisation Summit
- MOUS Michigan Oracle User Summit
- ECO East coast oracle conference
- DCOAUG Fall Meeting
- MAOAUG, Atlanta
- MEOUG Majils conference, Dubai
- HOUAG / HOUG – Quarterly Meeting
- Life is short, work fast! Blitz Report™ – the fastest & easiest way to export Oracle EBS data into Excel
- Discoverer Replacement for EBS – Don’t throw the baby out with the bathwater!
- Speed up Your EBS: Simple and Effective Performance Tuning using Excel
- OUG Ireland 2019, Dublin
- San Antonio, TX Collaborate 2019
- Dallas DOUG Dinner Meeting – Performance Tuning – to improve EBS User Experience – Dallas, TX
- Rocky Mountain (RMOUAG) Training Days, Denver, CO
- EBS Performance Tuning Simplified – Tips,Tricks and a free toolkit!
- SROAUG 2019 Spring Conference, Los Angeles
- Ohio Valley (OVOAUG) Winter Meeting – Louisville, KY
- Pittsburgh OAUG Chapter Meeting – Pittsburgh, PA