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