Page Comparison

Posting of Allocation Document - Handle Gain / Loss posting when document created in multi-Currency.

Financial Report Form: Vienna introduces a new field named "Print Label & Period" on the Report Column Set tab. 

Upon selecting the "Print Label & Period" dropdown control, the system will present the following options: 

1. Only Display Print Label 

2. Only Display Period 

3. Both Print Label & Period  

Only Print label: When user select the "Only Print Label", then system will display the only Header/Print Label as column name.

Only Period: When user select the "Only Period", then system will display the only the Period/Year as column name.

Both Print Label & Period: When user select the "Period & Print Label", then system will display the column name with the combination of both Header/Print Label and Period as column name.  

Enhancement for displaying column name based on Print Label and Period-Ver 2.3.7.0

1. Download Financial Report PDF for Multiple Organization:  

Vienna has introduced a new parameter called "Download Report PDF" within the Report parameter tab. When users activate this parameter, the system will present a dropdown control labeled "Download Report PDF" on the Generate Report page, featuring LOV (List of Values) with the following options: 

Organization Wise 

Consolidated Organization 

Under the "Organization Wise" option, selecting "Organization wise" in the control will prompt the system to display data for one of the organizations on the generated report. Simultaneously, it will automatically download individual PDFs for all the selected organizations. 

In the case of "Consolidated Organization," choosing "Consolidated Organization" in the control will result in the system displaying consolidated data on the generated report. Additionally, it will automatically download a PDF containing consolidated data for all the organizations. 

Enhance the efficiency of generating financial reports. 

Enhancement for generating the Individual Financial Report PDF for multiple Organizations-2.3.6.0

2. To simplify the granting of access to various windows, processes, and forms for a specific role. We've enhanced the Right Groups configuration. Instead of manually granting access to individual components for a role, which can be a cumbersome process, users can now associate a right group with a role. This will automatically provide access to all the components included in the right group. 

 For detailed information about the components under different right groups, please refer to the link.

Right Groups Configuration (FRPT)

Created right group for the tenant level.

3. Improve Performance of Financial Report Form

Posting: When user post the document then system get the period according to the Account date in ledger account detail. 

1. To simplify the granting of access to various windows, processes, and forms for a specific role. We've enhanced the Right Groups configuration. Instead of manually granting access to individual components for a role, which can be a cumbersome process, users can now associate a right group with a role. This will automatically provide access to all the components included in the right group. 

This enhancement is supported by VIENNA Advantage Standard <1.2.16.0>

For detailed information about the components under different right groups, please refer to the link.

Right Groups Configuration (FRPT)

Created right group for the tenant level.

2. VIENNA has introduced the features to showcase report columns name as either the actual period, range of period, or the entire year in the generated report, depending on the selected parameter. 

Enhancement for displaying column names based on selected period/year - 2.3.3.0

Financial Report Form

1. VIENNA has introduced an "P&L before closing" option in report parameter tab of Financial Report. When user enable this parameter from report tab, and checked the parameter during generation of report then system will pull the data for the row line before P&L close. For more details, click on https://viennaadvantage.atlassian.net/wiki/spaces/VA/pages/140869636

1. Handling issue of trailing junk after numeric literal for PostgreSQL 15. 

Financial Report Form  

1. When the user generated a financial report with” Suppress Line (zero value after conditional formatting)," the system was not suppressing the row line. Now, the system will suppress the report line.

2. On Report Column, when the user defines the formula for column calculation with Account Type, and the calculated value is zero, the system will show a NULL value for the calculation column.

3. Previously, the system was displaying the zero or null value without applying the conditional formatting on the row line when the user defined the print value as "Replace Actual with ZERO or NULL" and on the report column when the user defined conditional formatting for the (any) column. Now, when the column condition matches the print value setting, the system will apply the conditional formatting.

Posting

1. Previously, when users posted the GL Journal Record, the system created a Ledger account detail record with different users. The point has now been resolved.

1. Financial Report Form

On Report Line – When a user creates a report line with the "Calculation" type and sets the column precision to ZERO, the system previously rounds the value for the calculation row after applying the formula. Now, the system will round the value for each row included in the calculations before applying the formula during report generation. 

2. Foreign Currency Revaluation Form

Previously when creating a GL Journal entry through foreign currency revaluation form, system was checking any GL journal entry exist with selected accounting schema on revaluation date but not considering the organization. Now system will check the GL entry record existence with Organization as well.

Report / Column Precision: VIENNA has introduced an enhanced precision feature in the financial report form. Initially, Users can generate reports with the standard precision associated with the chosen currency in the Accounting Schema. But now, If a user wants to use a precision other than the one specified in the accounting schema currency, the system provides a setting in the report header. By setting "Not use Accounting Schema Precision" to true, users can define their own precision in the "Precision" field in the report header and based on this precision the system will generate the report. 

Additionally, the system provides a "Precision" field setting on the column line set, allowing users to specify precision for individual columns. In determining precision, the system prioritizes the column line set precision first, followed by either the report header precision if defined or the selected accounting schema currency precision, based on the specified settings. 

 Financial Report Form Enhancement - 2.2.3.0

Db Changes: 

Table: PA_ReportColumn 

Field: Precision 

Table: PA_Report 

Field: Not use Accounting Schema Precision

1. Added a new LOV value as "Replace Actual Value with Null" and "Replace Actual Value with Zero" on "Print Value” field on column posting type popup in Report Line Set tab.  

When user can select the print value "Replace Actual Value with Null" then system will replace the original value with null in generated report. 

When user can select the print value "Replace Actual Value with Zero" then system will replace the original value with zero in generated report.

FRPT Enhancement 2.2.2.0(Web View)

1. Previously, the system didn't keep track of the Account type for the Calculation row. As a result, the column calculation didn't function correctly for row calculation report line based on account type. Now, the system will ensure the account type is maintained for the calculation row, and it will apply the column formula to the calculation row as well.

1. Double Underline: Added a new LOV value as "Double Underline" on "Horizontal Line” field on Report Line Set tab. User can select the line break value and accordingly the system will show the horizontal lines at the report and in PDF.

2. Repeat Header Info on Each Page: New feature has been introduced on the report header tab with "Repeat Header on Each Page" field. When user selects the checkbox "Repeat Header on Each Page" on Report Header and generates a report, the system will dynamically print header on each page of the PDF format.

3. Ignore Horizontal Line for Name or Description: New feature has been introduced on the report line tab with "Ignore Horizontal Line for Name/Description" field. When user selects the checkbox "Ignore Horizontal Line for Name/Description" as true, system will not print the line for Name and Description column for the row.

4. Name and Description column shuffle: New feature has been introduced on the report header tab with "Print Name/Description after Column Index" field. When user define the column index, system will shuffle the name/description column after the defined column index in report, pdf and excel.

5. Generate Parallel Reports: Now user being able to generate multiple reports simultaneously from Financial Report Form and Financial Report Viewer.

Please go through the below document for more detail of above points

Ver 2.2.1.0 Enhancement in Repeat Header on Each Page, Shuffling Name & Description columns, double underline, Ignore horizontal line, Generate parallel reports, column formula calculation

In the financial report form, when users open the Organization or Organization Tree structure while generating a report, the system provides a "Search textbox" based on name to filter the organization hierarchy which will be case sensitive. 

1. Previously, when a user made changes to the report header but didn't save the record, and then selected another report, the system displayed a confirmation dialog. However, clicking "OK" did not save the record. Now, the system will save the record through the confirmation box when the user clicks "OK." 

2. Previously, if a user entered special characters like @, %, /, etc., in the report name, it would result in an exception when generating the PDF file. Now, issue with downloading PDF files from the "Financial Report Form" has been resolved. 

3. Previously, the system was unable to retrieve financial reports from the Financial Report Viewer. Now, system retrieve the report. 

4. System was not showing the selected dimension in report when list sources is true. Now system will display report with list sources included dimension. (Module Dependency 
VIENNA Advantage Standard <1.2.11.0> )

5. On Account Localization window, the system handles duplicate entities when a user creates the Posting rule and Post tab Entities from the tenant. 

DB Changes 
Window: Account Localization 
Tab: Posting Entity 
Column - FRPT_IsNegateInventory 

Field : Negate Inventory
Provide Setting on Posting Entity tab of Account Localization to Post Qty with Negative sign or not.

Tab: Posting Logic 
Column - FRPT_IsNotPostQty 

Field: Not Post Quantity

Provide setting on Posting Logic tab of account localization that allows to not post the quantity in Ledger account detail. 

Rounding Off Account Posting: Provide enhancement on Screen Accounting Book-> Tab: General Ledger to post the rounding account. To support this added new fields

1. User Rounding Off

2. Tolerance Range From

3. Tolerance Range To

4. Rounding off Account

When user submits a voucher within the VA system, the system will subsequently examine the Tolerance From and Tolerance To range during the voucher reconciliation process. If the values fall within this designated range, It will be categorized as a rounding difference rather than requiring suspense balancing. Conversely, If the value surpasses this range, It will be treated as a suspense balance. 

DB Changes 

Window / Screen – Accounting Book 

Tab -  General Ledger 

Table -C_AcctSchema_GL 

Columns added -  

FRPT_IsRoundinOff, FRPT_Roundingoff_Acct, FRPT_ToleranceRangeFrom, and FRPT_ToleranceRangeTo.

Module Dependency 

Vienna Advantage Standard <1.2.8.0> 

Enhancement on Financial Report Form

1. Column Formula: Added a new field as List control (LOV) with name "Account Type” Column Formula panel in Report Column Set tab. User can  create column formula based on account type of ledger.

DB Changes: added new column in  the following table 
Table : T_Report

Column: AccountType

Table : FRPT_ColumnFormula

Column: AccountType

For more details, click on Financial Report Enhancement-2.1.11. (WebView)

Bug Fixes on Posting: When we post a record, system will update the Line ID on ledger account detail based on Amount Entity / Master Entity defined on the logic if found, otherwise record id will be updated.

Financial Report Form

1. Horizontal Line: Added a new field as List control (LOV) with name "Horizontal Line” on Report Line Set tab. User can select the line break value and accordingly the system will show the horizontal lines at the report and in PDF. 

2. Print Value: Added a new field as List control (LOV) with name "Print Value" in “Column Posting Type” dialog popup on Report Line Set tab. By using this option user would be able to select which kind of value [either 0 or Blank] to be printed at the report.

For more details, click on Financial Report Enhancement-2.1.10.0

Financial Report Form

1. When user modifies data in a particular report line or column line set and attempts to move to another record or tab without saving the changes, a confirmation box will appear asking the user to confirm whether they want to save the changes. Upon user confirmation, the system will now correctly save the record instead of previously failing to save. 

2. When a user generates a report with date fields and exports it to PDF, the dates will be displayed in the format as on the User Interface.

3. New feature has been introduced on the report header tab with "Merge Description with Name" field. When user selects the checkbox "Merge Description with Name" on Report Header and generates a report, the system will dynamically merge the description column with the name column in the report output.

4. New feature has been introduced on the report header tab with "Precision" field. When users input a value for the "Precision" then system will render the amount column with defined precision otherwise the standard precision defined on selected accounting schema currency.

5. Now, users can perform other activities within the system while the report is being generated and will populate the message after generating the report.

For more details, go through the attached link document for all above points Financial Report Form Enhancements-2.1.9.0

Handle to copy default accounting Process (for PostgreSQL) 

1. Product Category to Product Default Accounting

2. Asset Group to Asset Default Accounting 

3. Business Partner Group to Customer / Vendor / Employee Default Accounting 

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. Provide option to Suppress Line

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. Provide option to Ignore Conditional Formatting for a specific row line.

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. Provide option to Ignore Conditional Formatting for a specific row line.

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 for above all four points in Financial Report Enhancement-2.1.3

5. Posting 

Provide option to post quantity either in Base UOM or in Seleted UOM

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. 

For more detail, please go through Intercompany Transaction Posting

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: 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) 

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

2. On Financial Report form - Resolve issue of pulling data in case large number of org unit available.

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

For more Information, Please click Ver 2.0.1.0 - Nullable Dimension Enhancement

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