Financial Management (FRPT_)

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 Enhancement with P&L Closing_2.3.1.0

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 

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) 

1.Validation on Business Partner, Trx Organization parameter on Financial report form. 

2.Handle Intercompany Posting on Inventor Move 

1.In Financial report form, Name field to be shown as "All Dimension" value.

2.Handle Calculation formula – close the Bracket first before operator, when defined. 

1.Bug Fixes for Financial Report Form 

1.Convert Target Framework version from 4.5 to 4.8

2.Financial Report Form: Handle Calculation with scale value - When divide the value in the calculation, system was not showing scale value (value after precision) 

Posting

1.Post Master Entity Dimension Value based on Account Combination filtration. 

2.Post accurate ledger detail, when Master entity column available in Amount Entity filed, but still we pass the Account Combination filter. 

Financial Report Form 

1.In the Generate Report, the "Date Account From" parameter is cutting/overlapping. 

2.While selecting  the Organization parameter it's showing as "Controller Not Found" when hierarchy not found, now system show Empty. 

3.Message Handling : When a column is deactivated or a new report line is added its row is deactivated in form and while generating a report, it comes as [@No@ @PA_ReportColumn_ID@] 

4.In case the Previous Year is selected and the value (e.g 2 years) of that period does not exist in Calendar and Period (2019), then data of the existing year comes (2021) 

5.On selecting the date range in the parameter, the error is coming as [ORA-00923: FROM keyword not found where expected] [Handle Query] 

6.Message Handling : Report Line Set is unable to delete even after deleting its row, it comes as Line set in use. Now it will be "Record you are deleting is already selected in the Report Line Set" 

7.Financial report fetched based on order by ledger accounts 

1.Enhancement at Financial Report Form :

Report Line Set : In the Type field the system will show the All Dimension field and once the user selects the All Dimension value then the system will show all the Dimension fields that selected at the Accounting Schema.  

Now when the user runs the report then the system will search the records based on the selected dimension. 

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

2.Also,  when user want to set default value as true (for checkbox only) on Financial Report Form parameter, user can set "Is Mandatory" as true during report parameter configuration. 

1. When we Post record for those transaction where Posting Rule is mark as Reference Rule, at that time system update correct window for Accounting fact detail record 

1.Handle Financial Report parameter  display in PostgreSQL for User Elements 

1.Handle Rounding point during creation of Accounting Fact Detail 

1.Table : FRPT_Entity 

Column : FRPT_Table_Acct 

Change In Validation "FRPT_Table" 

2.Table : FRPT_AcctDefault

Column : FRPT_RelatedTo

Change in LOV : Added -> "95 " - Work Center Cost Detail 

3.Display Review Posting on Expense Invoice Window 

1. Financial Report PDF Header Formatting 

2.Handle Zoom from Financial Report Form for GL Journal window 

Dependency Information 

VIENNA Advantage Framework (4.6.1.0) 

Enhancement in the Financial report form: 

1.Multi-Dimensional report can be pulled. The user would be able to select multiple dimensions at the Report lines. 

2.PDF formatting Enhancement. The report would be pulled with color formatting on text.  

1.Handle Transaction for Posting Exception 

1.Handle Gain/Loss on Banking Journal 

1.Bug Fixes for Statement of Account report 

1. Bug Fixes for Source Debit and Credit to be rounded with Standard Precision in Accounting fact Detail 

-Handle Zoom functionality on Financial Report Form 

2.Dependency Information 

- VIENNA Advantage Upgrade 4 (1.0.62.0) 

3.Bug Fixes for Statement of Account report 

1.Create View Table Entry in Module Management for Forex Revaluation Form 

1.Bug Fixes for PostgreSQL 

2.Bug Fixes 

1.Database Changes (Account Default Records to be filtered based on respective "Related To" on every Accounting Default tab) 

2.Introduce Forex Revaluation functionality 

3.On Allocation Document header, we mark Business Partner ID Virtual column as In-Active. Kindly Change the Posting Logic if required or using the same column from header irrespective use from Allocation Document Line. 

Dependency Information ( VIENNA Advantage Framework (4.2.85.0)) 

Enhancement with Posting Logic, 

1.User can restrict the dimension( by using Account Element Tab) on Posting which are enabled on Accounting Schema.  

2.Also user can set priority for dimension from where he want to post the particular dimension (Either from header Or from the Amount Etity record) 

Handle Calculation for different Period Type in Financial Report Form 

Enhancement on Financial Report Form, Provide functionality of selection of Dimension Value on Report line set. When User select any Dimension on Report Line, system will filter data based on selected dimension for the particular row. This version allow filtering data based on row level including parameter and column level. 

1.Created  Default Accounting tab on Revenue Recognition Window 

2.Added "Revenue Recognition" in Related To LOV on Accounting Default  

3.Created new column "Recognize Type" on Accounting Default  

4.Handle Default Accounting record creation for Revenue Recognition 

1.Handle Financial Report Form in PostgreSQL.

2.Handle MatchPO, GRN Posting in PostgreSQL  

1.Handle insertion and updation default account in PostgreSQL

1. Handle Design on 'Financial Report Form' during csv and pdf creation 

1.Introduced organization wise period control. For user manual click here. This Version have dependency on below module: 

-VIENNA Advantage Framework (4.2.39.0) 

-VIENNA Advantage Upgrade 4 (1.0.25.0)

1.Enhancement to give multi search option in the parameters for selection of Organization Units. 

2.If the sequence of Organization parameter is before Organization Unit parameter, then Organization Units are filtered according to the selected Organization. If Organization parameter is not included or if the sequence is after Organization Units, then it will display all the Organization Units.

3.Amount fields are aligned on right side in the report. 

1.Handle Budget control  

2.Enhancement to show beginning balances till the defined period in financial report form. 

3.UI changes 

1.PostgreSQL Database Supported 

1.During Posting,  line id and table id reference will be maintained in Accounting Fact Details. This functionality is supported by Vienna Advantage Upgrade 4 <1.0.18.0>  

2.Post Description from the Document itself, when the description not define on document then pick from the header (Description with Document no) 

3.Enhancement to show sum on summary level accounts. If some sub groups are mapped in the financial report 

1.Copy Default Accounts into Asset Group and Asset From Accounting Schema 

2.Insert or Update Default Accounts from Asset Group to Asset 

3.System will provide the functionality to Post Ledger from amount dimension control rather than to pick from posting logic

4.Message Handle in COA And financial Group 

Bug Fixes on Posting 

Bug Fixes on Posting 

1.Handle conversion defined on posting logic as "Transaction Date table and Transaction date column" 

Bug Fixed: for Translation in COA & Financial Group Form. 

1.Enhancement for providing dimensions on report column set in financial report form. 

2.New process to copy balances to accounting schema. Database changes for this functionality are supported by Vienna Advantage Upgrade 4 <1.0.4.0>. 

1.Bug fixes (Financial Report Form) 

1.Bug fixes (Round set on Discount amount, Total Amount fields according to the currency precision selected on Invoice header) 

2.Bug fixes and Resolved design issues.

1. Bug Fixes on Posting. 

1.Bug Fixes on GL Distribution Form. 

1.Sorting of Reporting Sub Groups on COA & Financial Group Form. 

2.Bug Fixes on COA & Financial Group Form. 

1.Enhancement of GL Distribution Form. This functionality supported by VIENNA Advantage Framework <3.5.52.0>  and VIENNA Advantage Upgrade 3 <1.0.32.0> 

1.Enhancement  of amount dimension control. This functionality supported by VIENNA Advantage Framework <3.5.50.0>  and VIENNA Advantage Upgrade 3 <1.0.31.0> 

1.Populate Posting Message on User Interface. 

2.Transaction to be posted with ZERO amount if any. 

1.Bug Resolution. 

1.Updated css and js files for supporting front end libraries ( jQuery v3.4.1 and Bootstrap v4.3.1). These front end libraries files are available in Vienna Advantage Base files v1.0.9.0 onwards. 

1.Support features to add new default accounts on Business Partner Group and Product category will auto insert default account on Vendor, customer, Employee, Product level. 

1.Bug in GetGernalLedgers function. In case of default account, default account getting the element value id but we necessary Search key. Bug found and resolve. 

2.when amount entity column is null then type casting issue coming.

DB Changes 

- FRPT_LocPosting_Entity –  

Added new list Value -- Org Ref (“O”)  on field “FRPT_Type”

- FRPT_LocEntity_PostingLogic 

Added new field : FRPT_OrgRefEntity

Organization Ref entity indicate the system will post the document line in Organization that is linked with defined column record on its Posting Entity tab. In case of Variance in Organization Debit and Credit total, Intercompany Due from/ To account will be posted. 

1. Handle gain and loss for payment and cash journal. 

2. During conversion, we give priority to conversion type from document line. 

3. Change in method : CreateRealizedGainLoss 

- Formula for calculating gain and loss 

- rounding handling based on costing precision 

- gain and loss to be posted in invoice org 

4.when we did entry on payment allocate – that time payment rate to be calculated as :  

(AllocatedAmt of payment) / (SUM of amount available on allocation line against payment 

1.Get and update Parent link  

2. Get proper Valid combination account for nullify account during gain and loss. 

3. Added LOV Value  in “FRPT_Type” as “Org Type”   

4. During creation of Document line, system will update Organization reference from respective record reference which is to be selected on  Org Ref Entity  

5.when Entity is to be fixed logic -- Posting should be done EVEN qty and amt both are null/ZERO 

a) During creation of Doc line, system will update Organization reference from respective record reference which is to be selected on  Org Ref Entity

b)consolidate record based on master entity and organization

c)when Entity is to be fixed logic -- Posting should be done EVEN qty and amt both are null/ZERO

6. During GetMatchPODiffrence, system was calculate costing which is to be restricted now

7.FRPT_OrgRefEntity : Is used to post fact into defined record organization 

8. Change in “CreatePostingLogics” – get FRPT_OrgRefEntity  data  from FRPT_LocEntity_PostingLogic