Financial Reports (VA056_)

1. Added new menu report (BI) - Vendor Ageing Report(As on Trx Date) 

Procedure - VA056_BPAgeingTrx

Table - va056_doctype_para

Note : Tested on Postgresql only

1. Resolved Closing Balance Issue in Account Activity Report. 

Changes in the procedure and temp table for resolving issues in Inventory Transaction report – Added opening and closing balance. 

Procedure - va056_inventorytransactions 

1. Added new report in menu, Inventory Transaction Report. 

Note: These changes are available for Oracle DB only.   

1. Changes in the procedure and temp table for resolving issues in following reports.

Procedure - va056_vendorbalance_p 

Temp Table - va056_t_vendorbalance 

1.1 Vendor Balance Detail (As on Date) Report 

1.2 Customer Balance Detail (As on Date) Report 

Procedure - va056_bpageing 
Temp Table - VA056_T_BPAGEING 

1.3 Customer Ageing Report (As on Date)  

1.4 Vendor Ageing Report (As on Date) 

Balance sheet As on Date(Detailed) : 

1. Report was showing 3 Level of Summary levels defined in COA, it is increased to 5 Levels, There are changes in Table Structure, View Script and CR functions

1. In procedure VA056_BPAGEING changing the insert section columns to uppercase , update section current_timestamp to now() in all update section changed and Age days columns format to be changed in postgre sql

1. Added new report in menu, Account Activity Report. 

Note: These changes are not available for Oracle DB . 

1. Correction in sequence of Ledger code in Balance Sheet Report(Detailed) report. 

2. Handled Multi search type on Organization and added Report Title Parameter in Balance Sheet Report(Detailed) 

Note: These changes are not available for Oracle DB  

1. Added report Balance Sheet Report(Detailed) in menu. 
Note: These changes are not available for Oracle DB . 

1. Added va056_transactions function for PostgreSQL DB. 

2. Added new report in menu, Stock Valuation Report,
Report will provide Stock Details as on selected date along with Valuation. 

Added following reports for Oracle DB
1.Customer Summary Report (As on Date)
2.Vendor Summary Report (As on Date)

These reports are summary of following 2 reports

1.Customer Ageing Report (As on Date)
2.Vendor Ageing Report(As on Date) 

Note: These changes are not available for PostgreSQL DB 

1.On parameters Product and Product Category added validation to remove Fixed Asset related products.
1.Stock Ageing Report
2.Stock Valuation Report 

Note: These changes are not available for PostgreSQL DB 

1.Parameter Product Category set as multiselect and Removed the Fixed asset related products in following reports for Oracle DB
1.Stock Ageing Report
2.Stock Valuation Report 

2. Parameter BP Group set as multiselect in following reports for Oracle DB
1. Customer Ageing Report (As on Date)
2.Vendor Ageing Report(As on Date) 

Note: These changes are not available for PostgreSQL DB 

Added following reports for Oracle D

- Customer Balance Detail (As on Date)

- Vendor Balance Detail (As on Date)

Note: These changes are not available for PostgreSQL DB 

1. Vendor Ageing Report (As on Date) 

-Created Procedure 

- Created Bi Report 

- Created Report & Process with required parameters 

- Created Menu 

2. Customer Ageing Report (As on Date) 

- Created Procedure 

- Created Bi Report 

- Created Report & Process with required parameters 

- Created Menu 

Note: These changes are not available for PostgreSQL DB 

1. Resolved issues in following reports for Oracle DB

Stock Ageing Report
Stock Valuation Report 

2. Removed following Report from module

Stock Ageing Report (With Valuation)

Note: These changes are not available for PostgreSQL DB 

Added following reports for Oracle DB

1. Stock Ageing Report
2.Stock Ageing Report (With Valuation)
3.Stock Valuation Report

Note: These changes are not available for PostgreSQL DB 

1.Added Report Structure Setup  related functionality for Oracle Database. 

Enhancements in GL Statement of Accounts report

- Added Org unit and Business partner in parameters and in report

-Changes done in procedure

1. Increased Fetch size in All procedures to 500000 

2.Procedure and RPT level changes in following reports
- Customer Statement Report 

VA056_CustStatement.rpt 

pr_load_cust_statement_wgl 

- Customer Ledger Report (Foreign Currency) 

VA056_CustLedgerFC.rpt 

pr_load_cust_statement_wgl 

- GL Statement of Accounts 

VA056_GLStateAcc.rpt 

PR_LOAD_STATEMENTOFACCT1 

- Vendor Ledger Report (Foreign Currency) 

VA056_VendorLedgerFC.rpt 

PR_LOAD_VENDOR_STATEMENT_WGL 

- Vendor Aging Detail (Without Payment) 

VA056_VendorAgingDetailWP.rpt 

PR_LOAD_BPVNDR_AG_DETAIL_WP 

1. Increased length of Acct_Name column to 100  in

TEMP_CUSTOMER_AGING_INV 

1.Rounding issues in the reports fixed.  

2.Aging reports title renamed to Aging instead Ageing. 

3.Correction done for the Total OS amount in  Aging reports. 

1. Resolved issues in va056_getfactbal() db function. 

1. Increased Column Length in Temp Tables used for reports. 

1. Resolved issue of Bank Ledger Report  

1. Resolved performance issue of Bank Ledger Report 

1. Resolved performance issue of GL Statement of Accounts 

1. BI Multidimension Report Performance issue.  

2. Added Indexes on Fact_Acct table  

Renamed menu names for 2 menu reports 

Added Only Ledger Code functionality for calculation in multidimensional reports on report line 

Added Only Ledger Code Functionality for calculation in Multidimensional reports. 

Handled following posting types for BI Integrated reports. 

B Budget 

E Commitment 

R Reservation 

S Statistical 

V Virtual 

1.New Window "Report Structure Setup" 

2.Processes : Balance Sheet (BI), Income Statement(BI)

1. Bug fixing- Increased Customer Search Key length in temp table. 

Updated Postgre functions 

1.Converted functions, temp table, views from oracle to postgre 

2. Converted oracle stored procedures to postgre functions 

Deployed below mentioned financial reports: 

- Vendor Aging Detail Report 

-  GL Statement of Accounts 

- Balance Sheet 

- Trial Balance Summary 

- Profit and Loss Statement 

- Bank Ledger Report 

- Bank Reconciliation Details 

- Bank Reconciliation Summary 

1. Converted functions, temp table, views from oracle to Postgre

2. Converted oracle stored procedures to Postgre functions

Deployed below mentioned financial reports:

1. Customer Outstanding as on Date 

2. Customer O/S Ledger (Foreign Currency) report 

3. Customer Ledger Report (Foreign Currency) 

4. Customer Statement Report 

5. Customer Aging Detail Report

6. Customer Aging Summary Report 

7. Vendor Balance Report (As on Date) 

8. Vendor Outstanding Ledger Report (Foreign Currency) 

9. Vendor Ledger Report (Foreign Currency)

10. Vendor Aging Summary 

11.Cashbook Statement Report (based on Transactions)

12. Employee Ledger Report

Oracle financial reports