Added new menu report (crystal) - GL Journal Summary Procedure :- va056_SummaryTrialBalance View :-VA056_T_GLJournalSummary_V
Tables:-VA056_T_GLJournalSummary
,VA056_T_GLJournalSummary _para
Added new menu report (crystal) - GL Journal Detail Report Procedure :- VA056_GLJournalDetail View :-VA056_T_GLJOURNALDETAIL_V
Tables:-VA056_T_GLJournalDetail
,VA056_T_GLJournalDetail_Para
Added new menu report (crystal) - Account Fact Report Procedure :- VA056_AccountFactReport View :-VA056_AcctFactReport_V
Tables:-VA056_T_AccountFactReport
,VA056_T_AccountFactReport_para
Add new menu report on Stock Valuation Report Menu for ( Stock valuation details report).
In stock valuation report showing in menu level bi report . The data was fetching All records. And process attached by stock valuation report menu. Process is Stock valuation. and procedure is va056_stockvaluationdetails updated db: Psotgresql
Add New menu report on Stock ageing Report Menu for ( Stock ageing details report) .
In stock ageing report showing in menu level bi report . The data was fetching All records. And process attached by stock ageing detail report menu . Process is Stock Ageing Detail Report. and procedure is va056_transactionsdetails updated db: Psotgresql
Add New menu report on inventory transaction report details Menu for ( inventory transaction detail report) .
In inventory transaction report showing in menu level bi report . The data was fetching All records . And process attached by stock ageing detail report menu . Process is Inventory Transaction Report Details. and procedure is va056_inventorytransaction updated db: Psotgresql
1.0.42.0
Expand
title
Enhancement
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.0.41.0
Expand
title
Bug Fixes
1. Resolved Closing Balance Issue in Account Activity Report.
1.0.40.0
Expand
title
Bug Fixes
Changes in the procedure and temp table for resolving issues in Inventory Transaction report – Added opening and closing balance.
Procedure - va056_inventorytransactions
1.0.39.0
Expand
title
Enhancement
1. Added new report in menu, Inventory Transaction Report.
Note: These changes are available for Oracle DB only.
Expand
title
Bug Fixes
1. Changes in the procedure and temp table for resolving issues in following reports.
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.0.37.0
Expand
title
Enhancement
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.0.36.0
Expand
title
Enhancement
1. Added new report in menu, Account Activity Report.
Note: These changes are not available for Oracle DB .
1.0.35.0
Expand
title
Enhancement
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.0.34.0
Expand
title
Enhancement
1. Added report Balance Sheet Report(Detailed) in menu. Note: These changes are not available for Oracle DB .
1.0.33.0
Expand
title
Enhancement
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.
1.0.31.0
Expand
title
Enhancement
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.0.29.0
Expand
title
Enhancement
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.0.28.0
Expand
title
Enhancement
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
1.0.27.0
Expand
title
Enhancement
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.0.26.0
Expand
title
Enhancement
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.0.25.0
Expand
title
Enhancement
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
Note: Above Reports are currently only support for Oracle Database not supported for Postgres database.These changes are not available for PostgreSQL DB
1.0.23.0
Expand
title
Enhancement
1.Added Report Structure Setup related functionality for Oracle Database.
1.0.22.0
Expand
title
Enhancement
Enhancements in GL Statement of Accounts report
1. - Added Org unit and Business partner in parameters and in report
2. -Changes done in procedure
1.0.21.0
Expand
title
Enhancement
1. Increased Fetch size in All procedures to 500000500000
2.Procedure and RPT level changes in following reports - Customer Statement ReportReport
VA056_CustStatement.rptrpt
pr_load_cust_statement_wglwgl
- Customer Ledger Report (Foreign Currency)
VA056_CustLedgerFC.rptrpt
pr_load_cust_statement_wglwgl
- GL Statement of AccountsAccounts
VA056_GLStateAcc.rptrpt
PR_LOAD_STATEMENTOFACCT1STATEMENTOFACCT1
- Vendor Ledger Report (Foreign Currency)
VA056_VendorLedgerFC.rptrpt
PR_LOAD_VENDOR_STATEMENT_WGLWGL
- Vendor Aging Detail (Without Payment)
VA056_VendorAgingDetailWP.rptrpt
PR_LOAD_BPVNDR_AG_DETAIL_WPWP
1.0.20.0
Expand
title
Enhancement
1. Increased length of Acct_Name column to 100 in
TEMP_CUSTOMER_AGING_INV
1.0.18.0
Expand
title
Enhancement
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.0.17.0
Expand
title
Enhancement
1. Resolved issues in va056_getfactbal() db function.
1.0.16.0
Expand
title
Enhancement
1. Increased Column Length in Temp Tables used for reports.
1.0.15.0
Expand
title
Enhancement
1. Resolved issue of Bank Ledger Report
1.0.14.0
Expand
title
Enhancement
1. Resolved performance issue of Bank Ledger Report
1.0.13.0
Expand
title
Enhancement
1. Resolved performance issue of GL Statement of Accounts
1.0.12.0
Expand
title
Enhancement
1. BI Multidimension Report Performance issue.
2. Added Indexes on Fact_Acct table
1.0.11.0
Expand
title
Enhancement
Renamed menu names for 2 menu reports
1.0.10.0
Expand
title
Enhancement
Added Only Ledger Code functionality for calculation in multidimensional reports on report line
1.0.9.0
Expand
title
Enhancement
Added Only Ledger Code Functionality for calculation in Multidimensional reports.
1.0.8.0
Expand
title
Enhancement
Handled following posting types for BI Integrated reports.
B Budget
E Commitment
R Reservation
S Statistical
V Virtual
1.0.7.0
Expand
title
Enhancement
1.New Window "Report Structure Setup"
2.Processes : Balance Sheet (BI), Income Statement(BI)