Financial Reports (VA056_)

Owned by Tanpreet Singh (Unlicensed)
Last updated: Sept 12, 2024 by Asavari Mahajan
6 min read

Version

Date

Included

Version

Date

Included

1.0.46.0

Sep 12, 2024

Enhancement:

  1. Changes in filter product validation: VA056_stock valuation detail report, Stock ageing report and inventory transaction reports  

  2. Add column qtyexe for add update query in procedure va056_stockvaluationdetails calculation divided by cost column in bi report. 

  3. Considered all costing methods in va056_stock valuation detail report 

1.0.45.0

Jun 27, 2024

Enhancement:

  1. Added new menu report (crystal) - Trail Balance (New) 
        Procedure :- VA056_TrialBalance 
        View :- VA056_TRAILBAL_V 

    Tables:-VA056_T_TrialBalance , VA056_T_TrialBalance_Para 

  1. Added new menu report (crystal) - Trail Balance Summary Report (New) 
        Procedure :- VA056_SummaryTrialBalance 
        View :-VA056_TrialBalSummary_V 

    Tables:-VA056_T_SummaryTrialBalance 

                 ,VA056_T_SummaryTrialBalance_Para 

  1. Added new menu report (crystal) - GL Activity Detail Report 
        Procedure :- va056_GLActivityDetailReport 
        View :-VA056_GlActDetailReport_V 

    Tables:-VA056_T_GLActivityDetailReport  

                 ,VA056_T_GLActivityDetailReport _Para 

  1. Added new menu report (crystal) - GL Statement Report 

    Procedure :- VA056_GLStatementReport 
    View :-VA056_GlStateReport_V 

    Tables:-VA056_t_GLStatementReport 

                 ,VA056_t_GLStatementReport_para 

  1. Added new menu report (crystal) - GL Journal Summary 
        Procedure :- va056_SummaryTrialBalance 
        View :-VA056_T_GLJournalSummary_V 

    Tables:-VA056_T_GLJournalSummary  

                 ,VA056_T_GLJournalSummary _para 

  1. 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 

  1. Added new menu report (crystal) - Account Fact Report 
        Procedure :- VA056_AccountFactReport 
        View :-VA056_AcctFactReport_V 

    Tables:-VA056_T_AccountFactReport 

                 ,VA056_T_AccountFactReport_para 

  1. 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 

  

  1. 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 

  1. 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

Nov 7, 2023

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

Oct 18, 2023

1. Resolved Closing Balance Issue in Account Activity Report. 

1.0.40.0

Sep 29, 2023

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

Sep 12, 2023

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) 

1.0.38.0

Jul 17, 2023

1.0.37.0

Jul 4, 2023

1.0.36.0 

May 19, 2023

1.0.35.0 

Apr 14, 2023

1.0.34.0 

Apr 5, 2023

1.0.33.0 

Mar 10, 2023

1.0.31.0

Dec 18, 2022

1.0.29.0

Oct 14, 2022

1.0.28.0

Sep 16, 2022

1.0.27.0

Jul 25, 2022

1.0.26.0

Jul 5, 2022

1.0.25.0

Jun 28, 2022

1.0.24.0

Jun 10, 2022

1.0.23.0

May 17, 2022

1.0.22.0

May 5, 2022

1.0.21.0

Apr 11, 2022

1.0.20.0

Apr 1, 2022

1.0.18.0

Mar 17, 2022

1.0.17.0

Mar 4, 2022

1.0.16.0

Jan 31, 2022

1.0.15.0

Dec 28, 2021

1.0.14.0

Oct 20, 2021

1.0.13.0

Oct 7, 2021

1.0.12.0

Sep 12, 2021

1.0.11.0

Jul 21, 2021

1.0.10.0

Jul 19, 2021

1.0.9.0

Jul 13, 2021

1.0.8.0

Jul 6, 2021

1.0.7.0

Jun 28, 2021

1.0.5.0

Jun 9, 2021

1.0.4.0

Apr 22, 2021

1.0.3.0

Apr 21, 2021

1.0.2.0

Apr 13, 2021

1.0.1.0

Dec 18, 2019