Page Comparison

1. Financial Report Form: When user pull the report in PDF format then display Table header Information on every page. 

Vienna has introduced a new feature called "Column Posting Type Setting" on the Report Line. 

When the user selects "Segment Value" in the "Line type" field and select either "Ledger Code" or "Ledger Group" in the "Link with" field on the Report Line Set tab, the "Column Posting Type" panel will appear. 

This setting allows the user to pull reports for different posting types on the same column but for different report lines. 

The system follows a priority order for determining the posting type. The first priority is given to the posting type defined in the "Column Posting Type" panel for the column in the report line. The second priority is given to the posting type defined in the "Report Line Set", and the third priority is given to the posting type defined in the "Column Line Set". 

DB Changes: Added new table with the following columns 

Table :FRPT_RLPostingType 

Column:  

1. FRPT_ReportLine_ID

2. PostingType

3. FRPT_ReportColumn

Enhancement in Financial Report Form-2.1.6.0

1. On the Review Posting dialog, Display the dimension value with an mark identifier. 

Dimensions handled are: 

1. Business Partner

2. Product 

3. Project

4. Campaign

5. Trx Organization

Financial Report Form 

1. Added option to resize the width size of the panel dynamically, User can increase/decrease the width size of the panel based on the requirement. option applied in the following tab

1.Report Header

2.Report Row Line

3.Report Column Set

2. Applied  Astrik "*" icon with column names which is mandatory to define in Financial Report Form 

3. System provide the option to pullout the report in PDF with different page size. For this, added a new field name as "Page Size", and default value is selected as "A4 Landscape" 

This field contains the option as mentioned below-

A4 Portrait, A4 Landscape, 

A3 Portrait, A3 Landscape,

A2 Portrait, A2 Landscape 

Conditional Formatting on Report Column Set: When user wants to apply "Formatting" only  like bold, color etc. then no need to define the value in field "Set Value". System will print the original value and applied only the formatting for the column. 

View Formula : System provide the functionality to view formula calculation.

To verify the formula easily, System will show the cross and tick icon against that formula. 

When User click on “View Formula”, system will verify each formula expression if correct then it will show (Tick) mark in green color against that formula otherwise it will show (Cross) mark in red color on View Formula popup. 

Financial Report Form

1. Window: Financial Report 

Tab: Financial Report Header 

Created Field: Suppress line (Zero value before conditional formatting), Suppress line (Zero value after conditional formatting) 

Window: Report Line Set 

Tab: Report Line 

Created Field: Ignore Suppress line 

On Report Header:  

a) Created a new field as a checkbox with the name Suppress line (Zero value before conditional formatting). 

When the User will pull the report and this checkbox is true then the system will check all the rows where all columns contain ZERO value then the system will suppress those lines. 

b) Created a new field as a checkbox with the name "Suppress line (Zero value after conditional formatting)" on Report Header. 

When the user clicks on the field "Suppress line (Zero value after conditional formatting)" then the system will mark "Suppress line having zero value" as false and the system will suppress the report line after conditional formatting applies on the report line. 

On Report Line:

a) Created a new field as a checkbox with the name "Ignore Suppress line".

When the user will check this column, then the system will not suppress line either all the columns contain ZERO values. 

2. Table: FRPT_Formula

Column: FRPT_ExcludeColumnCalculation

On Report Line --> When the Report line is created with the Line type "Calculation" then system showed "Formula Grid". In Formula Grid,  created a new field as "Exclude Column in Calculation" whose reference type is Multi-serach. 

a) When the User selects any column in this field then those columns are not to be used in the formula for calculation. 

b) Also, provide Copy and Paste functionality for exclude column in calculation on "Formula Grid". 

c) System also provide the feature to show View Formula.

3. Window: Report Line Set 

Tab: Report Line

Created Field: Ignore Conditional Formatting 

On Report Line ->  created a new field as "Ignore Conditional Formatting" whose reference type is Multi-serach. 

When the user selects any column in the field, then the system will not apply conditional formatting for that column.

4. On Report Column: In formula grid, system will show record that created for columns marked as calculation. 

For more information see details in Financial Report Enhancement-2.1.3

5. Posting 

Window: Account Localization

Tab: Posting Entity 

Created new Field: 

a) Is Converted Qty 

b) Base Quantity Column 

This field will be visible when the Entity type is selected as "Quantity". Quantity column always represents the quantity with the Base UOM of the product.

When the Quantity Entity is selected on any posting logic and on the selected quantity entity,  when user defined "Is Converted Qty" as True and select "Base Quantity column" in  field then the system will post the quantity from the selected "Base Quantity Column" in the Ledger account Detail else system post the quantity in the Ledger account Detail from "Quantity" column. 

1. System provide the functionality to post the intercompany account from the "Intercompany setting" defined on accounting book. If not defined then system will pick the intercompany account from the "General Ledger" tab. 

Module Dependency 

Vienna Advantage Standard <1.0.7.0> 

Review Posting – When we open Review Posting from any transaction window where the button enabled, System provided Excel Export Button from which user can download the excel with Posting entry 

1. Financial Report form – When we open any saved report line for type "User Element" then Report Line Data not rendering for User Element 1 to 9. 

2.Handle Organization Unit length for generate report 

3.Financial Report Form: In Report Parameter, show Organization Unit as Tree Structure rather than Multi-Search. 

(Note: This module is dependent on Organization Structure of 1.0.7.0) 

4.Create new field on Provisional Invoice as "Review Posting" which will show the posting affects before actual posting. 

1. Financial Report form – When we open any saved report line for type "User Element" then Report Line Data not rendering for User Element 1 to 9. 

1. Rebuild the module with updated NuGet Packages and done necessary code changes to make compatible with Vienna Advantage Framework version 5.0 and above.  

2. Financial Report Form: Enhance Include Nullable Dimension Control on Report Line set for showing data detail included with Null Dimension as well. For more information, please click Ver 2.0.1.0 - Nullable   (Web view) 

3.Financial Report Form:  In-Active Ledger group will not show 

Note:- This version and all future versions of this module will be compatible with Vienna Advantage Framework version 5.0 and above. If you are using Vienna Advantage Framework 4.X.X.X then, do not install this version.  

Module Dependency 

- Vienna Advantage Standard (VAS_) <1.0.1.0> 

1. Handle Organization Unit length for generate report 

1. Financial Report Form: In Report Parameter, show Organization Unit as Tree Structure rather than Multi-Search. 

This module is dependent on Organization Structure of 1.0.7.0 

1.Rebuild the module with updated NuGet Packages and done necessary code changes to make compatible with Vienna Advantage Framework version 5.0 and above.    

2.Financial Report Form: Enhance Include Nullable Dimension Control on Report Line set for showing data detail included with Null Dimension as well.

Include Nullable Dimension Control on Report Line

3.Financial Report Form:  In-Active Ledger group will not show 

Note:- This version and all future versions of this module will be compatible with Vienna Advantage Framework version 5.0 and above. If you are using Vienna Advantage Framework 4.X.X.X then, do not install this version.  

 Module Dependency 

- Vienna Advantage Standard (VAS_) <1.0.1.0> 

1.Financial Report Form: Handle PDF Report in Arabic language 

2.In Financial Report Form: Last specified Year Data to be pulled out in report. 

3.On Banking Journal Window: Create new column as "Review Posting" which will be displayed before completion. 

1. Handle Case of Dimension Posting from Line, when Amount Entity defined from the Line and Master Entity defined from the Header. 

1.When we post a record at that time Post UOM and Quantity as well. 

Financial Report Form 

1.Subgroup will not display when list subgroup is false on report header.

2.Handle Rounding during comparison when apply conditional formatting 

3.UI Changes 

Financial Report Form 

1.In Report, Amount shown based on Standard precision defined on selected Accounting Schema. 

2.In Report, Handle Amount with Culture. 

3.When we generate PDF file form the report, PDF file Name will be as "Report Name (first 30 char) plus time-ticks" 

Posting 

1.When we Post "Allocation Document", On Fact Line Post the dimension and Record Line id for gain/loss. 

2.Handle UI message after posting. 

3.Allocation Document: Handle Gain/Loss Posting where invoice to payment or invoice to invoice has  different currency type. (This point is supported by Vienna Advantage Framework <4.10.3.0>). 

1.Provide functionality to Copy Financial Report Structure (Report Header Tab) on Financial Report Form. 

2.Provide "Type Not Include" functionality on Report Column Set. This will exclude selected dimension data from the ledger account at the column level. 

3.Create new field as FRPT_TypeNotInclude on PA_ReportColumn table

4.Provide "Conditional Formatting" based on specified report column. Previously, system applied conditional formatting on its own column. 

Create new field on Table: FRPT_ConditionalFormatting 

            as Column: FRPT_ReportColumn_ID 

Enhancement in Financial Report Form-1.4.  (Web view)