Time Tracker 28th March 2013 Ramco  Aviation  Solution Version  5.7.2  Enhancement  Notification  Finance DISCLAIMER © 2014 Ramco Systems Ltd. All rights reserved. All trademarks acknowledged. This document is published by Ramco Systems Ltd. without any warranty. No part of this document may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose without the written permission of Ramco Systems Limited. Improvements and changes to this text necessitated by typographical errors, inaccuracies of current information or improvements to software programs and/ or equipment, may be made by Ramco Systems Limited, at any time and without notice. Such changes will, however, be incorporated into new editions of this document. Any hard copies of this document are to be regarded as temporary reference copies only. The documentation has been provided for the entire Aviation solution, although only a part of the entire solution may be deployed at the customer site, in accordance with the license agreement between the customer and Ramco Systems Limited. Therefore, the documentation made available to the customer may refer to features that are not present in the solution purchased / deployed at the customer site. © Copyright 2014, Ramco Systems Ltd. www. ramco. com Ramco Aviation Solution TABLE OF CONTENTS WHAT’S NEW IN SUPPLIER PAYMENT? ............................................................................................................... 5  REQUIREMENT TO ENHANCE PAYMENT VOUCHER REPORT ............................................................................................. 5  Background ............................................................................................................................... ............................... 5  Change Details ............................................................................................................................... ......................... 5  WHAT’S NEW IN SUPPLIER PAYMENTS & SUPPLIER ORDER BASED INVOICE? .................................. 10  REQUIREMENT TO ENHANCE PREPAYMENT VOUCHERS ................................................................................................. 10  Background ............................................................................................................................... ............................. 10  Change Details ............................................................................................................................... ....................... 10  REQUIREMENT TO ENHANCE MAINTAIN INVOICE .......................................................................................................... 12  Background ............................................................................................................................... ............................. 12  Change Details ............................................................................................................................... ....................... 12  WHAT’S NEW IN SUPPLIER PAYMENT? ............................................................................................................. 14  REQUIREMENT TO ENHANCE PAYMENT VOUCHER REPORT ........................................................................................... 14  Background ............................................................................................................................... ............................. 14  Change Details ............................................................................................................................... ....................... 14  WHAT’S NEW IN SUNDRY PAYMENT? ................................................................................................................ 20  REQUIREMENT TO PRINT SUNDRY PAYMENT VOUCHERS ............................................................................................... 20  Background ............................................................................................................................... ............................. 20  Change Details ............................................................................................................................... ....................... 20  WHAT’S NEW IN EDK REPORTS PAYABLES MANAGEMENT? .................................................................... 27  REQUIREMENT TO ENHANCE REMITTANCE ADVICE REPORT ......................................................................................... 27  Background ............................................................................................................................... ............................. 27  Change Details ............................................................................................................................... ....................... 27  WHAT’S NEW IN CUSTOMER SERVICE INVOICE? .......................................................................................... 30  REQUIREMENT TO MODIFY THE TAXABLE AMOUNT ....................................................................................................... 30  Background ............................................................................................................................... ............................. 30  Change Details ............................................................................................................................... ....................... 30  WHAT’S NEW IN ASSET PLANNING? ................................................................................................................... 32  REQUIREMENT TO MANAGE BUDGETS FOR CAPITAL PROJECTS ACROSS YEARS ............................................................. 32  Background ............................................................................................................................... ............................. 32  Change Details ............................................................................................................................... ....................... 32  WHAT’S NEW IN ASSET CAPITALIZATION? ..................................................................................................... 37  REQUIREMENT TO CREATE ASSET NO. WITH LEADING ZEROS ( RUNNING NO.) ................................................................ 37  Background ............................................................................................................................... ............................. 37  Change Details ............................................................................................................................... ....................... 37  WHAT’S NEW IN COST AND PROFITABILITY REPORTING FRAMEWORK? ........................................... 39  Background ............................................................................................................................... ............................. 39  BULK PRINTING OF MANAGEMENT REPORTS ................................................................................................................. 40  Background ............................................................................................................................... ............................. 40  Change Details ............................................................................................................................... ....................... 40  NEW SCREEN TO MANAGE COST ELEMENT STRUCTURE ................................................................................................ 44  Background ............................................................................................................................... ............................. 44  Change Details ............................................................................................................................... ....................... 44  NEW SCREEN TO MANAGE COST COLUMN STRUCTURE: ............................................................................................... 50  Background ............................................................................................................................... ............................. 50  Change Details ............................................................................................................................... ....................... 50  NEW SCREEN TO MANAGE FORMULA: .......................................................................................................................... 53  Background ............................................................................................................................... ............................. 53  Change Details ............................................................................................................................... ....................... 53  NEW SCREEN TO MANAGE COST AND PROFITABILITY REPORT TEMPLATE: ................................................................... 55  Background ............................................................................................................................... ............................. 55  Change Details ............................................................................................................................... ....................... 55  WHAT’S NEW IN WORKSPACE? ........................................................................................................................... 57  REQUIREMENT TO ENHANCE WORKSPACE WITH USER PREFERENCE .............................................................................. 57  Background ............................................................................................................................... ............................. 57  Change Details ............................................................................................................................... ....................... 57  Enhancement Notification Page 5 of 61 WHAT’S NEW IN SUPPLIER PAYMENT? Requirement to Enhance Payment Voucher Report Reference: AHBF- 3020 / AHBC- 1202 Background Previously print option was not available for printing prepayment vouchers. Prepayment vouchers are now included in Payment Voucher Report with the heading ‘ Prepayment Voucher’. This facility helps to extract the Pay Voucher for prepayment as well as deposit vouchers. This will be useful for internal authorization for Advance Payments / Deposits made to suppliers. Change Details The ‘ Print’ button is added in Create Prepayment Voucher, Edit Prepayment Voucher and select page of View Pay Batch / Voucher. Withheld Tax will be displayed if the Statutory Tax and Accounting is applicable. Pay mode to be displayed in the header, each pay mode will be displayed as a separate group. Prepared by / Reviewed by/ Approved by will be displayed if ‘ Applicability’ is set as a set option. Report can be launched in Portrait / Landscape based on set option. To change the set options – Contact Ramco Support. Enhancement Notification Exhibit - 1: Illustrates Create Prepayment Voucher screen with Print button. Exhibit - 2: Illustrates Edit Prepayment voucher screen with Print button Page 6 of 61 Enhancement Notification Page 7 of 61 Exhibit - 3: Illustrates select page of View Pay Batch / Voucher screen with Print button. Enhancement Notification Exhibit - 5: Illustrates the report of Prepayment Voucher. Page 8 of 61 Enhancement Notification Page 9 of 61 Exhibit - 6: Illustrates report of Deposit Voucher. Enhancement Notification WHAT’S NEW IN SUPPLIER PAYMENTS & SUPPLIER ORDER BASED INVOICE? Requirement to Enhance Prepayment Vouchers Reference: AHBF- 2968/ AHBC- 1204 Background In scenarios where Advance Payments to Suppliers are to be made more than the Order value, for the reason that Charges are not being added in the Order documents, and 100% of the order value is to be paid to the Supplier, currently there is no provision to make such payments with the Order reference in the Prepayment Voucher. Also in scenarios where advance payments are to be made to Suppliers even when in the Order document, advance payable is “ No” Prepayment Vouchers cannot be created with Order Reference. The business requirement is to make advance payments to Suppliers even the Order Document does not provide for. Change Details In order to address the Business Need, a new Option is introduced in the Set Function Defaults of the Supplier Payment. If this option is switched ‘ On’, the above requirement will be satisfied. If this option is switched ‘ Off’, the existing functionality prevails - User will not be able to create prepayment vouchers with Order Reference unless the Order Document provides for. Set option ‘ Override Order Advance Applicability Terms & Conditions’ is added to set function defaults of Supplier payment. The above option can also be viewed in view function defaults. Page 10 of 61 Enhancement Notification Page 11 of 61 E xhibit – 1: Illustrates set option Override Order Advance Applicability Terms & Conditions Enhancement Notification Requirement to Enhance Maintain Invoice Reference: AHBF- 2968/ AHBC- 1204 Background In scenarios where Advance Payments to Suppliers are made to the extent of 100% of the Order Value against the order reference and the actual Supplier Invoice is recorded for that Order, an additional step of manually adjusting the Invoice and the Prepayment Voucher is involved. In that case there is a possibility of missing out to adjust this Prepayment and Invoice. Even in other cases, where the partial advance payments are made, the adjustment of the Prepayment Voucher with the Invoice has to be done manually. The business requirement is to automatically adjust the Order Invoice with the Prepayment Voucher with Order Reference thereby reducing a manual step. Change Details To cater to the above business need and to provide improved usability, a new option setting ‘ Basis for Auto Adjustment’ is introduced. If the Option is set to “ Order Specific Open Prepayments”, all paid Prepayment Vouchers for the Order document will get adjusted with the Supplier Order Based Invoice to the extent of the voucher amount applicable to the Order, provided the combo value ‘ Auto Adjust’ in the Supplier Order Based Invoice is selected as “ Yes” for that Invoice. If the Option is set to “ All Open Debit Docs.”, when the ‘ Auto Adjust’ in the Supplier Order Based Invoice is selected as “ Yes”, all the Open debit documents for that supplier will be adjusted against the Order Invoice. In addition, provision is given to auto default the ‘ Auto Adjust’ combo with either “ Yes” or “ No” for ease of using this Auto Adjustment Feature. Set option ‘ Basis for Auto Adjustment” with values “ Order specific Open Prepayments”/ “ All Open Debit Docs.” are added to the set function defaults of Maintain Invoice. Set option ‘ Default ‘ Auto Adjust’ in Maintain Invoice with’ is added to set function defaults of Supplier Order Based invoice. Single Currency Adjustment voucher in ‘ Authorized’ status is generated on auto adjustment of invoice. Adjustment can be made only with order based open prepayment vouchers if the set option ‘ Basis for Auto Adjustment’ is set to ‘ Order specific open prepayments. Page 12 of 61 Enhancement Notification Page 13 of 61 Exhibit - 2: llustrates set option Basis for Auto Adjustment and the set option Default Auto Adjust’ in Maintain Invoice with. Enhancement Notification Page 14 of 61 WHAT’S NEW IN SUPPLIER PAYMENT? Requirement to Enhance Payment Voucher Report Reference: AHBF- 3020 / AHBC- 1202 Background Previously print option was not available for printing prepayment vouchers. Prepayment vouchers are now included in Payment Voucher Report with the heading ‘ Prepayment Voucher’. This facility helps to extract the Pay Voucher for prepayment and deposit vouchers. This will be useful for internal authorization for Advance Payments / Deposits made to suppliers. Change Details Print button is added in Create Prepayment Voucher, Edit Prepayment Voucher and select page of View Pay Batch / Voucher. Withheld Tax will be displayed if the Statutory Tax and Accounting is applicable. Pay mode to be displayed in the header, each pay mode will be displayed as a separate group. Prepared by / Reviewed by/ Approved by will be displayed if ‘ Applicability’ is set as a set option. Report can be launched in Portrait / Landscape based on set option. To change the set options – Contact Ramco Support. Enhancement Notification Page 15 of 61 Exhibit - 1: Illustrates Create Prepayment Voucher screen with Print button. Enhancement Notification Exhibit - 2: Illustrates Edit Prepayment voucher screen with Print button Page 16 of 61 Enhancement Notification Page 17 of 61 Exhibit - 3: Illustrates select page of View Pay Batch / Voucher screen with Print button. Enhancement Notification Exhibit - 5: Illustrates the report of Prepayment Voucher. Page 18 of 61 Enhancement Notification Page 19 of 61 Exhibit - 6: Illustrates report of Deposit Voucher. Enhancement Notification Page 20 of 61 WHAT’S NEW IN SUNDRY PAYMENT? Requirement to Print Sundry Payment Vouchers Reference: AHBF- 2962 / AHBC- 1201 Background Previously print option was not available for Sundry Payment vouchers. Sundry payment vouchers which are created for non- standard Supplier Payments will now have ‘ Print option which helps in internal verification and authorization of Sundry Payments. Change Details Print button is added in Create Voucher, Edit Voucher, Authorize Voucher, Select Voucher and View Voucher screens. In the Create Voucher screen, ‘ Ref. Doc.#’ is added as an editable field where user can enter reference number if any for the Sundry Payment Vouchers. In the Edit Voucher screen the existing ‘ Ref. Doc. #’ field is made editable for enabling modification. The report is displayed with the heading ‘ Sundry Payment Vouchers’ for sundry payment vouchers and ‘ Inter Bank Transfer Voucher’ for sundry payment vouchers of type ‘ Interbank transfer.’. Payee is displayed in ‘ Pay to supplier name’ column in the report Ref. Doc. # is displayed in ‘ Supplier Document’ column of payment voucher report. Pay to Supplier Code, Credit Doc. #, Supplier Document Date, Due Date, Payable Tax Amt., and Withheld Tax Amt. columns will be displayed as blank in the report. Report is not displayed for sundry payment vouchers in ‘ Deleted’, ‘ Reversed’ or ‘ Void’ status. Enhancement Notification Page 21 of 61 Exhibit - 1: Illustrates Create Voucher screen with Print button and Ref. Doc. #. Page 22 of 61 Enhancement Notification Exhibit - 2: Illustrates Edit Voucher screen with Print button and Ref. Doc #. Enhancement Notification Page 23 of 61 Exhibit - 3: Illustrates Authorize Voucher screen with Print button and Ref. Doc. # Page 24 of 61 Enhancement Notification Exhibit – 4: Illustrates select page of View voucher screen with Print button Exhibit- 5: Illustrates view voucher screen with Print button. Enhancement Notification Page 25 of 61 Exhibit- 5a: Enhancement Notification Exhibit - 6: Illustrates the Payment voucher report for Sundry Payment Voucher. Page 26 of 61 Enhancement Notification Page 27 of 61 WHAT’S NEW IN EDK REPORTS PAYABLES MANAGEMENT? Requirement to Enhance Remittance Advice Report Reference: AHBF- 1915/ AHBC- 1188 Background Sundry Payment Vouchers do not form part of Remittance Advice Reports which is extracted and used as payment advice for Supplier Payments. Currently only Payment Vouchers and Prepayment Vouchers are forming part of this Remittance Advice Report. The requirement is to display Sundry Payment vouchers in Remittance Advice Report. Change Details Sundry Payment vouchers are included in Remittance Advice Report. Payee will be displayed in Supplier Name. Address captured in payee details is displayed in the address section. Sundry payment vouchers of type Inter Bank Transfer are not displayed in Remittance Advice Report. Sundry payment vouchers generated for bank charges will be displayed in this report. The document for which the Bank Charges is generated will be displayed in ‘ Your Ref. No’ column. Enhancement Notification Exhibit - 1: Illustrates Remittance Advice Report with Sundry Payment vouchers. Page 28 of 61 Enhancement Notification Page 29 of 61 Exhibit - 2: Illustrates the Remittance Advice Report with sundry payment vouchers generated for Bank Charges. Page 30 of 61 WHAT’S NEW IN CUSTOMER SERVICE INVOICE? Requirement to modify the Taxable Amount Reference: AHBF- 3079 / AHBC- 1174 Background When Customer Service Invoice is generated for Aircraft Maintenance services, there are scenarios where services delivered on foreign flights are not taxable. In some cases, when a single Invoice is raised for services done on both foreign and domestic flights, it is not possible to identify the foreign / domestic flight segregation. Hence a standard percentage of invoice value is considered as taxable. Also, in scenarios where tax is not applicable on the full value of Materials or Resources etc., there is a requirement to apply the taxes only on a portion of it. In order to satisfy the above requirement, the ‘ Taxable Amount’ column of Customer Invoice is made as editable, so that tax can be applied on the required portion of invoice / entity based on a parameter. Change Details Set option ‘ Allow modification of Taxable amount’ is added to Set Function Defaults activity of the Customer Invoice business component. The above option can be viewed in the View Function Defaults screen. The ‘ Taxable Amount’ column of ‘ T/ C/ D Details’ tab is made editable based on the above option. Validation if ‘ Taxable Amount’ exceeds the actual Taxable Amount. On modification of base value of the Invoice, Taxable Amount and Tax Amounts ( in case of % based TCDs) are recomputed provided the taxable amount is not previously modified for that Tax. Taxable amount modification is applicable for the Customer Service Invoice ( Regular), Order Based Prepayment Invoices and Direct Prepayment invoice. Taxable Amount column can be modified even for Charges and Discounts. Enhancement Notification Page 31 of 61 Exhibit – 1: Illustrates set option ‘ Allow modification of Taxable Amount’ in Set Function Defaults Exhibit - 2: Illustrates Taxable Amount in T/ C/ D Details Tab. Page 32 of 61 WHAT’S NEW IN ASSET PLANNING? Requirement to Manage Budgets for Capital Projects across Years Reference: AHBF- 3817 / AHBC- 1183 Background For huge Capital Projects spanning across multiple years, budgets are approved for the entire tenure of the project, with year- wise allocation. Therefore, there is a need to capture the year- wise allocated budget amount and control the cost of the project within the approved budget amount for each year. In such cases, there is a need to manage Capital Projects represented by Asset Proposals over a number of years. E. g. Capital Project: Building an aircraft. Change Details Non Requirement Based Budget is enhanced to capture the information at an Asset Class level whether the budget is allocable across years or not. The Asset Proposal framework is enhanced to capture whether the proposal is allocable across years or not and if allocable across years, the break- up of such budget allocation for each year. New ARI reports ‘ Allocated vs Capital Spend” Summary and Detailed reports showing the Proposal Allocated Amount and the Actual Amount spend at summary and detail level with transaction details are also included. Asset Budget ( Non Requirement Budget) screen is enhanced to record allocable across years in budget information for each asset class with a new column ‘ Allocable across Years?’ Asset Proposal is enhanced to record whether the Proposal is ‘ Allocable across Years?’ The existing ‘ Proposal Amount’ column is renamed as ‘ Accrued Proposed Cost’. A new column ‘ Total Proposed Cost’ is added to record the total proposed cost of the budget. A new screen ‘ Maintain Year- wise Allocation’ is available as a link in asset proposal to record year- wise break up of proposal. Accrued Proposed Cost to be amended each year with the cumulative budget approved value. Enhancement Notification Page 33 of 61 A new ARI report ‘ Allocated Vs Actual Spend’ is developed to view summary as well as details of transactions. The Maintain Year- wise Allocation screen is launched only if ‘ Allocable across years’ is set as ‘ Yes’ for the proposal. At Any point in time, the cost accounted to Capital Work In Progress ( CWIP) should not exceed the Accrued Proposed Cost. Exhibit – 1: Illustrates the new column ‘ Allocable across Years?’ in Asset Budget Page 34 of 61 Exhibit - 2: Illustrates ‘ Allocable across Years?' ‘ and the new column in Asset Proposal Exhibit – 2a: Enhancement Notification Page 35 of 61 Exhibit – 3: Illustrates the Maintain Year- wise Allocation screen. Exhibit- 4: Illustrates the ARI report Budget Vs Actual Spend – Summary Exhibit- 5: Illustrates Budget Vs Actual Spend - Detail report. Page 36 of 61 Enhancement Notification Page 37 of 61 WHAT’S NEW IN ASSET CAPITALIZATION? Requirement to create Asset No. with leading zeros ( Running No.) Reference: AHBF- 2324 / AHBC- 1191 Background The asset number is generated as ‘ Asset Class - Running #’. The Running # starts with ‘ 1’. The requirement is to generate Asset No. ( Running #) with the required number of digits with the empty digits having leading zeros so that the Asset Numbers are standard with the same number of digits. Change Details A set option has been added as ‘ ASSET DIGITS’. If the above set option is blank, then the Asset # would be created from 1. If the set option is set up to 5, then the Asset # would be generated such that the Running # is created for the given No. of digits. For Example if the Asset Class is ‘ Engine’ and the above set option is set to 3, then the Asset No. would be created as Engine- 001. If the set option for the Prefix of OU is also set, then the Asset No would be created as OUPrefix- Engine- 001. Since the Asset Number can be of Maximum 18 digits only, additional validation has been added in Create Asset Class such that the Asset Class is created to the maximum characters. The maximum characters are determined considering the following condition: The No of characters in ( OU Prefix) + ( Asset Class) + ( 2 Hyphens) does not exceed 18 characters. Exhibit 1: Asset # created with the set option as 3 Page 38 of 61 Enhancement Notification Page 39 of 61 WHAT’S NEW IN COST AND PROFITABILITY REPORTING FRAMEWORK? Background Cost & Profitability Reports were generally managed as a customization for customers as there will be various specific requirements like report Layout, report Columns, reports for Multiple Cost Element & Cost Center Structure combinations etc. Bulk Printing of Management Reports based on the combination of CE Structure & CC Structure was not viable. Each Report with the combination of CE Structure & CC Structure was generated one by one. The creation and modification CE Structure screen was also cumbersome with several steps and with inherent usability issues. The columns for the Reports were not configurable and the same were fixed. Hence, as part of this feature the whole Cost and Profitability Reporting Framework has been revamped. The business requirement is to address the usability issues for generating Cost and Profitability Reports, ability to generate the same in bulk and ability to configure and manage the various constituents required for the cost and profitability reports with ease. The following are the major changes done: Manage Cost Element Structure – New Screen to Create/ Modify Cost Element Structure instead of the old Create Cost Element Structure. Manage Cost Column Structure – New Screen to define Cost Column Structure. Manage Formula – New Screen to Define Formula Manage Cost and Profitability Report Template – New Screen to Define Report IDs Generate Cost and Profitability Reports – New Screen for printing single Report as well as for Bulk Printing of Reports. Page 40 of 61 Bulk printing of Management Reports Reference: AHBF- 3704 / AHBC- 1185 Background Cost and Profitability Reporting requirements were managed through the existing ‘ Cost Center Profitability Reports’. The report is extracted for a combination of CE Structure and CC Structure, with or without budget reference. When there are many CE Structures and Cost Center Structures, multiple reports with a combination of these structures cannot be extracted at the same time or by a single click. Each report has to be extracted one by one, which was time consuming. To ease the extraction of reports, Cost and Profitability Reporting framework was enhanced to extract multiple reports. Option to bulk print the reports offline is introduced. Change Details In Order to Address the Business Need, a new screen Generate Cost and Profitability Reports has been added to the component Reports – Management Accounting. Cost and Profitability Reports can be generated for the combination of Cost Element Structure, Cost Column Structure, Cost Center Structure and other attributes of the Report. The user can use Excel Export/ Import to give the details for the Reports Search Criterion. Report IDs can be used to get the saved combination for the given Report IDs. Offline Report Save: On selection of Offline Report Save, the user can proceed to generate Cost/ Profit reports in Offline mode for many combinations at the same time. The ‘ Report Type’ can be selected by the user as “ Bulk” or “ Individual”. If Bulk is selected, the reports would be generated individually and consolidated as a single report in PDF format. On click of Save, Run # would be generated. Once the status of the Run # is completed, ‘ File Name’ link in the header would be enabled and the user can click the link to view the report. If ‘ Report Type’ is selected as “ Individual”, the ‘ File Name’ in the Multiline would be enabled. Exhibit – I Enhancement Notification Page 41 of 61 On Screen Launch of Reports: On selection of Online Report Save, the user can generate the Cost/ Profit Report for the combination specified in the multiline, for single line at a time. After entering the details in the Multiline, on click of Print the Report would be generated and launched ‘ On- screen’. Exhibit - II Exhibit – III Significance of the Columns in Generate Reports: • Report ID: This column is not mandatory, if Report ID is entered, the details given in the Report ID would be retrieved. • Report Description: This column displays the Report Description for the Report ID. Report Description will be shown as the ‘ Report title’ for the report generated. Page 42 of 61 • CE Structure ID: The report would be generated for the given CE Structure ID. In the absence of Report ID & Description, CE Structure Description will be shown as ‘ Report title’ for the report generated. • Col. Structure ID: The report would be generated for the given Column Structure ID. • CC Structure ID: The report would be generated for the given CC Structure ID. • Finance Book: The values in the Report would be for the Finance Book specified in this column. • Financial Year: The values in the Report would be displayed for the given Financial Year. • Financial Period: The values in the Report would be displayed for the given Financial Period. • CE Display level: This column enables to modify the report output as to the level at which the CE Structure is displayed. This column is not mandatory. If the user selects a level, then the Elements at the selected level plus the levels below it would be displayed from a CE Structure ID. • CC Entry level: This field is not mandatory. The output for the Cost Centers and Group Cost Centers above the given level in the CC Structure ID would be displayed. • CC Structure level: This field is not mandatory. The output for the Cost Centers and Group Cost Centers for the given level in the CC Structure ID would be displayed. Enhancement Notification Page 43 of 61 • CC Report Option: If Group CC is selected in the CC Report Option, only the Group Cost Centers would be displayed in the Report. If Detail CC is selected in this column then all the detail cost centers in the CC Structure ID would be displayed in the report. • Group CC: If a Group Cost Center is specified, then the Report would be displayed only for the specified Group Cost Center. • Cost Center: If a Cost Center is specified, then the Report would be displayed only for the given Cost Center. • Budget #: If Budget data is referred for the Report, then the Budget # from this column would be referred for the Budget data. • Version #: The specified version of the Budget would be referred for the Report. • Incl. Allocation: If Include Allocation is selected as “ Yes”, then the allocated values for the given Allocation Type would be considered for the Report. • Allocation Type: The user can select the Allocation Type in this column. • Display Amount In: In this column the user can specify how the values in the report should appear ( Actuals or Thousands or Billion or Million). • File Name: The link to the Report would be displayed in this column, when Report Type is selected as Individual. Page 44 of 61 New Screen to Manage Cost Element Structure Reference: AHBF- 2875 / AHBC- 744 Background Cost Element Structures represented by a Structure ID, captures the report detail element within a Cost/ Profitability Report. The existing screen Create Cost Element Structure is very cumbersome with several steps. Also the user was not able to visualize the Cost Element Structure with many levels. Managing the modification in the Cost Element Structure and usage of Formulae was not easy. Additional attributes like inclusion of a line, making a particular element to be displayed in bold were not possible. The business requirement is to address the usability issues in creation and modification of Cost Element Structure, with an ability to visualize the Structure and embed formulae in the same. Change Details In order to address the business need, a new screen Manage Cost Element Structure is developed. The screen has been positioned under the Cost Setup business component and can be launched using the activity Manage Cost Element Structure. The Cost Element Structure represented by a Cost Element Structure ID with multiple Elements grouped in to a structure, is the structure or description which would appear in the Cost and Profitability Report. CE Structure ID and Description can be given in the Cost Element Structure Information. To View the Existing CE Structure ID, the CE Structure ID can be given and ‘ On Enter’ of CE Structure ID, the existing CE Structure ID will be displayed. Copy from option is given to copy an Existing CE Structure and create a New Structure and Modify for the changes. Formula can be used to specify an arithmetical operation between schedules/ groups. Exhibit IV The Definition of Cost Element Structure is divided in to Layout information and Element Relationship. Enhancement Notification Page 45 of 61 Creation of Layout Information: In the Layout Information section, the Cost Element Structure Layout Information can be given / modified in the multiline. The description given in the Elements columns would appear in the Cost and Profitability Report in the same order as per the Sequence #. Multiline export/ import can be used to import the Elements and create a new CE Structure ID. On save, the Cost Element Structure is also represented using a Tree. The Tree enables the user to visualize the Cost Element Structure, especially when the structure has multiple levels. Elements can also be deleted using the Tree. On click of an Element in the Tree, the particular Element and its children are displayed in the multiline for review and modification. This helps the user to add, modify rearrange the elements within a group. In order to define formula, the link to Manage Formula is given in the Formula Column, for the element types “ Formula”. Exhibit- V Shows the Layout Information of a Cost Element Structure Significance of the Columns in the Layout Section o Seq # : This column enables the user to identify, the order in which the Elements are to be displayed in the Report. The Seq # need not be continuous. User can give Seq # with intervals to enable easy addition of elements. Page 46 of 61 o Element: The Elements are the description that appears in the Cost and Profitability Reports as given in this column. o Element Type: Element Type refers to the Nature of the Element which can be Group – this are Elements that has one or more Elements under it. Schedule – these are the Elements to which the Cost Elements are mapped. Group total – this element displays the total for a Group. There can be only one Group Total for a Group. Formula – this element allows the user to define a formula for the element in Manage Formula screen. The formula can be defined with one or more elements in the CE Structure ID. Format Text – this element displays the text given in the element column while printing the Cost and Profitability Report. Format Page break – this element breaks the report in page and displays the subsequent elements in the next page. Format Line - this element displays a line across the values column in the Report. o Display: This value selected in this column specifies, whether the element should be displayed/ visible in the report or not. o Parent Element: The Element entered in this column specifies under which group the element is classified. The Element specified in this column should be a valid Element of the type Group. o Variable: This column displays a unique Row Identifier which can be referred while defining formula. Enhancement Notification Page 47 of 61 o Formula: This column displays a link, if the Element in the row is of the type Formula. This link points to the Manage Formula screen, where a formula can be specified for the Element. o Element Nature: The Value selected in this column helps to arrive at the natural balance of the Element. This is applicable for Groups and Schedules. o Reverse Sign: If ‘ Yes’ is selected in this column, arrived value for the Row is multiplied by - 1. o Format: The Format of the Element to be displayed as Bold, Underline can be given in this column. o Formula Display: This column displays the Formula defined for the Row. Mapping of Cost Elements to the Schedules: In the Element Relationship Section, the cost elements can be mapped to the Elements of the Type ‘ Schedule’. The multiline export and import can be used to map multiple Cost Elements to the Schedules, when ‘ All Schedules’/ ‘ Unmapped’ are selected in the Schedules combo. This section works in two ways: a) Work on “ All Schedules” or “ Unmapped”: to specify the Cost Elements and its corresponding Schedule heading for all the Cost Elements at one go. b) Work on Specific Schedule: Add or Delete a Cost Element from a Schedule by retrieving the information for that particular schedule alone. When a particular Schedule is selected in the Schedule combo, the cost elements can be mapped only to the selected schedule. The Cost Elements mapped to the schedule are shown under the respective Schedule in the Tree. Cost Element Relationship can also be unmapped using the tree delete button. The ‘ Unmapped’ represents the cost elements that are not mapped to any Schedule for the given CE Structure ID. Page 48 of 61 Exhibit VI Displays the Cost Elements mapped to the Schedules. S o Cost Elements: T he Cost Elements a Description: T his column displcolumn. Schedules T his columnSchedules C specified here. P Three Predefined Cost Element StructureLayout Structure in the Set Parameters defined Cost Element Structure in the Set Parameters, then the user can proceed to Map the Cost Elements to the Pre- defined Structure in this screen. While Creating New Enhancement Notification Page 49 of 61 Account Codes, the schedules for the default cost element Structure can be mapped to the new Account Codes created. xhibit VII Pre- defined CE Structure ID set as Default in Set Parameters. E Displays the Page 50 of 61 New Screen to Manage Cost Column Structure: Reference: AHBF- 3361 / AHBC- 1226 Background The Columns in the Cost Center Profitability Report were not configurable by the User. Customizations were done for the Customers for managing different column structures other than the default column structure. Business Requirement is to configure the Columns dynamically for the Cost and Profitability Reports. Change Details In order to address the Business Need, a new screen Manage Cost Column Structure is developed. The screen has been positioned under the component Cost Setup and can be launched using the activity Manage Cost Column Structure. The details of the Column Name and how the data has to be derived for each column can be specified by the user in this screen. The user can also classify a column as a Formula Column and derive values based on the other columns in the Report. The formula can either involve one or more columns in the Column Structure ID or involve an element and a Column from the CE Structure ID. A New Cost Column Structure can be created when New is selected in the Column Structure ID Combo. Pre – defined Column Structure can be viewed when Pre - defined is selected in the Column Structure ID Combo. User – defined Column Structure can be viewed/ modified when User – defined is selected in the Column Structure ID Combo. Enhancement Notification Page 51 of 61 Exhibit VIII Displays a six column structure. Significance of the Columns in the Create Cost Column Structure: • Column ID: Column ID is displayed in this column. User can verify which column has been used in the formula using this Column ID. • Column Name: The Name specified here appears in the Report as Column Headings. • Source Info: The user can specify whether the data displayed in the column is based on Actuals or Budget or Formula. • Data Based on: The user can specify whether the data for the column to be displayed is for the Period or from the start of the year till the end of the Period selected. The user can also specify if the column is a Formula column or not, and whether the formula involves only columns or columns as well as elements. • Qty/ Value: The user can specify whether the data for the column to be taken from quantity data or value data. • Formula: The link to define Column formula would be displayed in this column. • Formula Display: If formula is defined for the column, then the defined formula would be displayed here. Page 52 of 61 Enhancement Notification Page 53 of 61 New Screen to Manage Formula: Reference: AHBF- 3606 / AHBC- 1187 Background Provision to include Formula within a CE Structure or Column Structure was not available previously. Formulae were managed as customization for the Customers for generating Cost and Profitability Reports. Business Requirement is to develop a new screen to define formula for CE Structure ID, Column Structure ID and Report ID. Change Details In order to address the Business Need, a new screen Manage Formula is added under the component Cost Setup. Formula – CE Structure ID Formula for a CE Structure ID can be defined for the elements whose element type is formula. It can be defined using the Elements, Groups, Schedules or Formula itself. Formula – Column Structure ID Formula for a Column Structure ID can be defined for the elements whose data based on is given as ‘ Formula - Column level’. Formula – Report ID Formula for a Report ID should be defined, when the Report ID uses a Column Structure ID, which has a Column - Element level formula. Elements of the type Group, Schedule and Formula of the CE Structure ID as well as the Columns of the Column Structure ID can be used to define the formula for the column. Exhibit IX Displays a formula defined for a CE Structure ID. Page 54 of 61 Enhancement Notification Page 55 of 61 New Screen to Manage Cost and Profitability Report Template: Reference: AHBF- 3625 / AHBC- 1185 Background The users had to give the combination for CE Structure ID, Column Structure ID and CC Structure ID and other attributes every time for generating a Cost and Profitability Report. Ability to configure a Report Template using CE Structure ID and CC Structure ID and reuse the same was not available and the combinations have to be given every time the report is extracted. User can save time if the frequently used combinations are saved and reused while generating the Report. Business Requirement is to develop a new screen to define Report Template using the CE Structure ID, CC Structure ID and Column Structure ID, with additional filter attributes, so that these templates are easily referred for extracting Reports. Change Details In order to address the Business Need, a new screen Manage Cost and Profitability Report Templates is added under the component Cost Setup. This activity facilitates the user to create a Report ID for the combination of CE Structure ID, Column Structure ID and CC Structure ID and other attributes for which the Cost and Profitability Report has to be generated. User can also retrieve/ modify/ activate/ inactivate a Report ID already created. Multiple Report Templates can be created and managed with the combination of the CE, CC, and Column Structures. If a Column in the Report refers to a formula involving a Column and an Element, then the formula has to be defined against a Report ID. The Report ID once saved can be used in the Cost and Profitability Reports to fetch the saved data. The user can view and modify the saved Report IDs by using Search. Exhibit X Displays the Report IDs created. Page 56 of 61 Enhancement Notification Page 57 of 61 WHAT’S NEW INWORKSPACE? Requirement to Enhance Workspace with User Preference Reference: AHBF- 2362 / AHBC- 967 Background The data relating to Suppliers and Customers displayed in Finance WorkSpaces were managed through backend parameters. If there is a change in the same, users have to approach Ramco Support. The requirement was to bring this option in the screen for users to configure the same. Change Details The Manage Screen Defaults & Preferences screen helps to set preferences for user roles to Order Based Invoice WorkSpace and Receivables Management WorkSpace. It restricts the user to access only the specific supplier / customer data set in the respective WorkSpaces’ Manage Screen Defaults & Preferences screen. Manage Screen Defaults & Preferences is used for setting user preferences Icon is added in Order Based Invoice WorkSpace to link the above screen. Icon is added in the Receivables Management WorkSpace to link the above screen. Option is available to specify specific Supplier / Customers list or Supplier / Customer Account Groups or Customer Groups as the list of Supplier / Customers for the WorkSpaces. Option to map mapping All Supplier or All Customers is also available Exhibit - 1: Illustrates the User Preference Icon placement in Order Based Invoice workspace. Page 58 of 61 Enhancement Notification Page 59 of 61 Exhibit - 2: Illustrates the Manage Screen Defaults & Preferences screen of Order Based Invoice User Preference. Exhibit - 2: Illustrates the Manage Screen Defaults & Preferences screen of Receivables Management User Preference. Applicability and critical validations in the screen: 1 . The system saves only the values specified in ‘ Permitted Value’ for the preferences. 2. The corresponding documents of the values set in the Manage screen Defaults & Preferences are retrieved in the Order Based Invoice Workspace / Receivables Management workspace. 3. This screen helps to set preferences for the user roles. Page 60 of 61 Corporate  Office  and  R& D  Center  Ramco  Systems  Limited,   64,   Sardar  Patel  Road,   Taramani,   Chennai  –   600  113,   India  Office  +   91  44  2235  4510  /   3090  4000  Fax        + 91  44  2235  2884  Website  ‐   www. ramco. com © Copyright 2014, Ramco Systems Ltd. www. ramco. com Ramco Aviation Solution