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