Financial Reports (VA056_)

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