© 2013. Ramco Systems Time Tracker 28th March 2013 Ramco Aviation Solution Version 5.8 Enhancement Notification Finance Enhancement Notification © Copyright 2016, Ramco Systems Ltd. www. ramco. com Ramco Aviation Solution DISCLAIMER © 2016 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. TABLE OF CONTENTS WHAT’S NEW IN MAIL IT? ............................................................................................................................... ....... 5 ABILITY TO VIEW CUSTOMER AND SUPPLIER AGEING REPORTS....................................................................................... 5 Background..................................................................................................................... ......................................... 5 Change Details ............................................................................................................................... ......................... 5 WHAT’S NEW IN NOTIONAL CHARGES FOR ORDER DOCUMENTS.......................................................... 10 REQUIREMENT TO ADD NOTIONAL CHARGES IN DELIVERY CHARGES INVOICE .............................................................. 10 Background..................................................................................................................... ....................................... 10 Change Details ............................................................................................................................... ....................... 10 WHAT’S NEW IN SUPPLIER ORDER BASED INVOICE? .................................................................................. 18 ABILITY TO RECORD MULTIPLE INVOICES FOR EXCHANGE PO ....................................................................................... 18 Background..................................................................................................................... ....................................... 18 Change Details ............................................................................................................................... ....................... 18 WHAT’S NEW IN SUPPLIER INVOICING............................................................................................................. 19 REQUIREMENT TO RETRIEVE OPEN DEBIT DOCUMENTS FOR ADJUSTMENT....................................................................... 19 Background..................................................................................................................... ....................................... 19 Change Details ............................................................................................................................... ....................... 19 WHAT’S NEW IN SUPPLIER PREPAYMENT VOUCHER?................................................................................ 21 ABILITY TO CREATE SUPPLIER PREPAYMENT VOUCHER WITH PAY CURRENCY DIFFERENT FROM THAT OF BANK CURRENCY ............................................................................................................................... .................................................... 21 Background..................................................................................................................... ....................................... 21 Change Details ............................................................................................................................... ....................... 21 WHAT’S NEW IN SUPPLIER BANK ACCOUNT INFORMATION.................................................................... 24 ABILITY TO ENCRYPT PAYEE BANK ACCOUNT NO........................................................................................................ 24 Background..................................................................................................................... ....................................... 24 Change Details ............................................................................................................................... ....................... 24 WHAT’S NEW IN CUSTOMER BALANCE ADJUSTMENT?.............................................................................. 26 ABILITY TO ENABLE DEBIT DOCUMENTS FROM ANOTHER GROUP COMPANY IN CUSTOMER BALANCE ADJUSTMENT........ 26 Background..................................................................................................................... ....................................... 26 Change Details ............................................................................................................................... ....................... 26 WHAT’S NEW IN ACCOUNT INQUIRY................................................................................................................. 32 REQUIREMENT TO DISPLAY REFERENCE DOCUMENTS FOR INTER FB JV ......................................................................... 32 Background..................................................................................................................... ....................................... 32 Change Details ............................................................................................................................... ....................... 32 WHAT’S NEW IN CUSTOMER ITEM BASED NOTE........................................................................................... 34 REQUIREMENT TO MODIFY TAXABLE AMOUNT IN CUSTOMER ITEM BASED NOTE........................................................... 34 Background..................................................................................................................... ....................................... 34 Change Details ............................................................................................................................... ....................... 34 WHAT’S NEW IN CUSTOMER SERVICE INVOICE?.......................................................................................... 37 Background..................................................................................................................... ....................................... 37 Change Details ............................................................................................................................... ....................... 37 WHAT’S NEW IN EDK REPORTS RECEIVABLES MANAGEMENT?............................................................. 39 REPORT ON INVOICE / RECEIPT WITH ADDITIONAL INFORMATION.................................................................................. 39 Background..................................................................................................................... ....................................... 39 Change Details ............................................................................................................................... ....................... 39 WHAT’S NEW IN FINANCIAL STATEMENTS?................................................................................................... 42 ABILITY TO VIEW BALANCE SHEET AND INCOME STATEMENT AT DIFFERENT LEVELS.................................................... 42 Background..................................................................................................................... ....................................... 42 Change Details ............................................................................................................................... ....................... 42 WHAT’S NEW IN ASSET CAPITALIZATION?..................................................................................................... 44 ABILITY TO ENABLE INTER FINANCE BOOK CAPITALIZATION OF ASSETS....................................................................... 44 Background..................................................................................................................... ....................................... 44 Change Details ............................................................................................................................... ....................... 44 WHAT’S NEW IN USAGE BASED DEPRECIATION?.......................................................................................... 49 ABILITY TO COMPUTE CME DEPRECIATION FOR COMPONENTS CONSIDERING IN- SERVICE USAGE.................................. 49 Background..................................................................................................................... ....................................... 49 Change Details ............................................................................................................................... ....................... 49 WHAT’S NEW IN ORDER BASED INVOICE?....................................................................................................... 52 ABILITY TO POST THE INVOICE PRICE VARIANCE TO ITSWORK ORDER'S COST.............................................................. 52 Background..................................................................................................................... ....................................... 52 Change Details ............................................................................................................................... ....................... 52 WHAT’S NEW IN REPAIR ORDER AMENDMENT? ........................................................................................... 56 ABILITY TO POST THE REPAIR EXPENSE VARIANCE TO CONSUMPTION........................................................................... 56 Background..................................................................................................................... ....................................... 56 Change Details ............................................................................................................................... ....................... 56 WHAT’S NEW IN COMPANY CONSOLIDATION................................................................................................ 59 REQUIREMENT TO CONSOLIDATE THE COMPANIES WITH DIFFERENT FINANCIAL YEARS ................................................... 59 Background..................................................................................................................... ....................................... 59 Change Details ............................................................................................................................... ....................... 59 Enhancement Notification Page 5 of 61 WHAT’S NEW IN MAIL IT? Ability to view Customer and Supplier Ageing Reports Reference: AHBF- 17144, AHBF- 17561 Background Operational efficiency is one of the key parameters that decide an organization’s performance. One of the factors affecting operational efficiency is the time taken for processing documents. Faster processing of documents can be ensured if it can be done from anywhere. The emergence of Smart Phones and other devices enables us to check mails and stay connected everywhere. Ramco decided to use the availability of mail capability in everyone’s hands to ensure faster operations in the enterprise and the solution of this thought is “ Mail IT”. This is a capability through which users can retrieve the details required or perform the work actions by just dropping a mail to the Ramco M& E, thus ensuring nil delay in operations. In any organization, Accounts Payable ( AP) or Accounts Receivable ( AR) clerk might be required to provide the Supplier and Customer Ageing Reports at any point. A provision is provided to obtain these finance statements using Mail IT capability. Change Details Pre- Requisites: For the enabling of the Mail IT capability, there are few pre- requisites required to be done by the IT admin that are provided below. 1. An Outlook Account should be configured for the RMTB server 2. An add- on, InboxMonitor should be installed in this Outlook Account 3. Workflow Mailer application needs to be installed in the Server 4. In the Workflow Mailer application, provide the following details a) Application Database from where the data should be retrieved or work action should be performed. b) Outlook Account details of the RMTB Server  Note: In case there could be other mails that can be sent to the RMTB server other than those required for Mail IT capability, then define rules to move only the mails related to Mail IT capability to the InboxMonitor folder. The InboxMonitor function should remain running for using the Mail IT capabilities Enhancement Notification Page 6 of 61 Exhibit 1: Identifies the InboxMonitor add- on in the Outlook account of the RMTB server Feature Details: The retrieval of the Customer or Supplier Ageing Reports can be made using the Mail IT capability using the following way. The AP or AR clerk or whomsoever concerned needs to send a mail to the Outlook account of the RMTB server with the subject as “ AGE- S; Supplier#; DD- MMM- YYYY” or “ AGE- C; Customer#; DD- MMM- YYYY” for retrieval of the report as on the requested date which is provided in the subject. The currency in which the report will be retrieved can be configured through a set option ( introduced in Define Process Entities screen under the Entity “ Customer/ Supplier Ageing”) to either the Supplier/ Customer currency or the base currency. If the same Supplier or Customer is available in multiple organization units, then the report will be displaying information pertaining to all the organization units. Configurable options are also introduced in the Define Process Entities screen for the currency in which the report should be retrieved. The following validations shall be carried out for the requestor mail id before sending the report against the request. • The requestor mail ID should be mapped to an user of the application and it should be a mail ID pertaining to the Organization’s domain, for retrieval of reports other than ‘ Customer Ageing Report’. In case the report to be retrieved is Inbox Monitor Add- On in Outlook Enhancement Notification Page 7 of 61 ‘ Customer Ageing Report’, then the mail ID can be an external mail ID provided the option setting in the ‘ Define Process Entities’ permits mail request from external mails and the user who carries the mail id is provided as the contact user in Customer master. • The user should have access rights to “ Supplier Ageing Analysis” or “ Customer Ageing Analysis” screens to retrieve the Supplier Ageing Report or Customer Ageing Report respectively  Note:  User can also use following alias names to retrieve the reports • AGE- S; Supplier Name; DD- MMM- YYYY • AGE- C; Customer Name; DD- MMM- YYYY Exhibit 1: Identifies the Supplier Ageing Report Exhibit 2: Identifies the Customer Ageing Report Enhancement Notification Page 8 of 61 Other Mail IT Capabilities: In addition to the above features, in general the Mail IT capability has the following options, which can be managed through configurable options introduced in the Define Process Entities activity of the Common Master Business component under the Entity Type “ Mail IT” and Entity “ Common”. 1. Provision to send the reply mail to the users who are added in the CC/ BCC list of the request mail a) Process Parameter • Allow automated replies to CC/ BCC List in Mail • If the value is set as ‘ Yes’, the reply mail with the document details shall be sent to users who are kept in the CC or BCC list in the request mail 2. Provision to restrict the time limit for processing of same request ( to avoid spam mails sent to the RMTB server) b) Process Parameter • Set Time limit to process same set of queries • If any value is defined for this parameter, the request mail with the same subject cannot be sent in the given time interval 3. Provision to restrict the retrieval of details against the request mail sent by users outside organization ( External Mails that are not defined in the User details) c) Process Parameter • Allow retrieval of Customer Ageing Summary reports by external users to the organization • If the value is set as “ Allowed”, then the reply mail to the request can be sent to the mail ids which are not defined in the User mapping  Limitations:  The mail reply to the contacts mentioned in BCC is not supported in this release Enhancement Notification Page 9 of 61  If the report is queried using Supplier/ Customer Name, then it shall be ensured that the Code is used for retrieval of detail, provided multiple Supplier/ Customer shares the same name  Note: This feature involves commercials and is not available for all customers. Please contact your Ramco Account Manager. Enhancement Notification Page 10 of 61 WHAT’S NEW IN NOTIONAL CHARGES FOR ORDER DOCUMENTS Requirement to add Notional Charges in Delivery Charges Invoice Reference: AHBF- 17128, AHBF- 17039 Background Freight cost forms a significant part of purchase cost particularly for overseas procurement. In most cases, it is the cost incurred in moving goods from Vendor location to the buyer’s location. It may also include packaging, loading and unloading charges, apart from carriage and insurance costs. When Freight becomes the responsibility of the buyer, Freight Charges are known at a much later stage when the Carrier / Freight Forwarder provides the invoice. With the Freight Costs forming a significant part of Procurement cost, Organizations would want it to be added to the inventory instead of charging it as an expense to the Profit and Loss ( P& L). In a scenario involving overseas procurement, the inventory cost of the part without freight does not reflect the true cost. The requirement is to have an option with which a notional % cost that can be charged to the Inventory for Freight. The notional charges can be set off against the Actual freight cost on receipt of invoice. Example 1 – Transaction with Notional Charge PO Supplier S1 $ 10,000 Freight Supplier S2 $ 500 Notional Charge for S2 $ 500 Change Details 1. Charge Type column is loaded with ‘ Notional’ in the following screens. ( Exhibit 1) Business Process Component Screen 1 Procurement Management Purchase Order Edit Document TCD Details 2 Procurement Management Purchase Order Edit Part Level TCD 3 Procurement Management Blanket Purchase Order Edit Document TCD Details 4 Procurement Management Blanket Purchase Order Edit Part Level TCD 5 Procurement Management Release Slip Edit Document TCD Details 6 Procurement Management Release Slip Edit Part Level TCD Enhancement Notification Page 11 of 61 2. New Editable and Display only controls added in the Create Delivery Charges Invoice, Edit Delivery Charges Invoice and Authorize Delivery Charges Invoice screens. ( Exhibit 2) 3. Help on Way Bill # / Ref. Doc # screen also enhanced with new controls. ( Exhibit 3) 4. Set option is also introduced in Set Finance Process Parameters page for enabling stock correction. ( Exhibit 4) Notional Charges: If the freight vendor and the freight cost is not known at the time of Order creation, Notional Charges ( with an estimated freight cost) can be added in the Order documents PO / RS ( Purchase Order/ Release Slip) at document level or part level to include the freight cost to the Inventory value. These charges can be invoiced through Delivery Charges Invoice ( Payables Management  Supplier Order Based Invoice  Create Delivery Charges Invoice), with reference to way bill # i. e. with Invoice category as “ Way Bill based” or with Goods inward document reference i. e. with invoice category as “ Ref. Doc. Based”. The charge option of the DC Invoice will be “ Order- Notional" in such cases. In case the actual freight cost varies, the DC Invoice can be recorded with variance, which can be posted to the inventory value through stock correction based on option setting. ( Exhibit 4) Payable Charges: If the freight vendor is known and the freight cost is not known at the time of Order creation, Payable Charge ( with an estimated freight cost) can be added in the Order documents PO / RS / RO at document level or part level with the Pay to Supplier for the TCD as the Freight Vendor ( different from that of the Order supplier). These charges can be invoiced through Delivery Charges Invoice ( Payables Management  Supplier Order Based Invoice  Create Delivery Charges Invoice), with reference to way bill # i. e. with Invoice category as “ Way Bill based” or with Goods inward document reference i. e. with invoice category as “ Ref. Doc. Based”. The charge option of the DC Invoice will be “ Order- Payable" in such cases. In case the actual freight cost varies, the DC Invoice can be recorded with variance, which can be posted to the inventory value through stock correction based on an option. ( Exhibit 4) Direct Charges: If no charges are added in the Order documents PO / RS either at document level or part level, these charges can be invoiced through Delivery Charges Invoice ( Payables Management  Supplier Order Based Invoice  Create Delivery Charges Invoice), with reference to way bill # i. e. with the Invoice category as “ Way Bill based” or with Goods inward document reference i. e. with invoice category as “ Ref. Doc. Based”. The charge option of the DC Invoice will be “ Direct" in such cases. Enhancement Notification Page 12 of 61 Based on the actual freight cost, when the DC Invoice is recorded, it can be posted to the inventory value through stock correction based on an option. ( Exhibit 4) Prerequisite for Notional Charges: A new Automatic Post Account Type: “ CHARGE SUSPENSE” has been introduced to account for the notional charges added in the order documents. The value of the notional charge will be accounted to this automatic posting account during Goods Inward confirmation as it not payable to the Supplier and the same will be knocked off once Delivery Charges Invoice is recorded. A new Pre- defined usage “ FRGHTEXP” ( Freight Expense) has been introduced to account for the variance in the Notional/ Freight Charges in the DC Invoice. ( Refer Example 1, 2 and 3 for the accounting details) The break- up information for the balance in the Charge Suspense can be reviewed in the View Account Balance Report ( Book Keeping  Finance Book Processing  View Account Balance) for the Transit Account Type ‘ Charge Suspense’. Exhibit 1: Addition of Charge Type ‘ Notional’ in Order documents.  Note: The above change is done in Purchase Order, Blanket Purchase Order and Release Slip screens. Addition of Charge Type ‘ Notional’ in order documents Enhancement Notification Page 13 of 61 Exhibit 2: Addition of new controls in Create Delivery Charges Invoice screen Exhibit 2: Addition of new controls in Edit Delivery Charges Invoice screen.  Note: Similarly the above change is done in Authorize Delivery Charges Invoice. Addition of new links View PO View Repair Order View Release Slip Newly added controls in ML Addition of new links View PO View Repair Order View Release Slip Newly added controls in ML Enhancement Notification Page 14 of 61 Exhibit 3: Help on Way Bill #/ Ref Doc. # screen in Create Delivery Charges Invoice Exhibit 4: Stock Correction set option in Set Finance Process Parameters page. 1. If the Stock Correction option is set as ‘ Yes’ then the variances ( in case of Order- Notional & Order- Payable) and actual cost ( in case of Direct) will be posted to Inventory provided the stock is available in the warehouse. 2. If Stock Correction option is set as ‘ No’ then the stock correction will not be triggered. Set options introduced for Stock Correction Addition of Charge Type and Way Bill # in header and ML level. Enhancement Notification Page 15 of 61 Accounting Entries for Notional Charges Example 1 Charge Type – Notional Item Cost – USD 10,000 Notional Charge @ 4.5% - USD 450 Conditions Debit Credit Entry at the time of GR ( Acount rule of TCD - Add to Stock) Stock Suspense A/ c USD 10,450 Charge Suspense A/ c USD 450 Supplier Suspense A/ c USD 10,000 Entry at the time of GR ( Acount rule of TCD - Expense off) TCD A/ c USD 450 Stock Suspense A/ c USD 10,000 Charge Suspense A/ c USD 450 Supplier Suspense A/ c USD 10,000 Invoice postings for Notional TCD added at PO. Charge Suspense A/ c USD 450 Supplier Control A/ c USD 450 Invoice with Variance ( Actual Freight > Estimated Freight) Actual Freight USD 500 Estimated Freight USD 450 Charge Suspense A/ c USD 450 Freight Expense A/ c USD 50 ( New Predefined Usage) Supplier Control A/ c USD 500 Invoice with Variance ( Actual Freight < Estimated Freight) Actual Freight USD 300 Estimated Freight USD 450 Charge Suspense A/ c USD 450 Supplier Control A/ c USD 300 Freight Expense A/ c USD 150 ( New Predefined Usage) Example 2 Charge Type – Payable Supplier # - S1, Item Cost – USD 10,000 Pay to Supplier # - S2 Frieght / Delivery Charge - USD 500 Conditions Debit Credit Entry at the time of GR ( Acount rule of TCD - Add to Stock) Stock Suspense A/ c USD 10,500 Supplier Suspense A/ c USD 10,500 Enhancement Notification Page 16 of 61 Entry at the time of GR ( Acount rule of TCD - Expense off) TCD A/ c USD 500 Stock Suspense A/ c USD 10,000 Supplier Suspense A/ c USD 500 Supplier Suspense A/ c USD 10,000 Invoice postings for Pay to Supplier based TCDs added at PO. Supplier Suspense A/ c USD 500 Supplier Control A/ c USD 500 Variance postings of Freight cost ( If Actual freight cost > cost added in PO) Actual freight 600 Supplier Suspense A/ c USD 500 Freight Expense A/ c USD 100 ( New Predefined Usage) Supplier Control A/ c USD 600 Variance Postings of Invoice ( Actual Freight < Cost added in PO), Actual Freight 300 Supplier Suspense A/ c USD 500 Supplier Control A/ c USD 300 Freight Expense A/ c USD 200 ( New Predefined Usage) Example 3 Charge Type – Direct Direct Delivery Charge – USD 500 Conditions Debit Credit Entry at the time of Way Bill or Ref. Doc. Based Invoice Freight Expense A/ c USD 500 ( New Predefined Usage) Supplier Control A/ c USD 500 D Cube Report for Delivery Charges D Cube Report is enabled for the Delivery Charges Invoice. This report is a listing of the delivery charges invoice with line level information. In case stock correction is generated for a DC invoice, the same can also be viewed in this report. A sample output of the D Cube is given below. Enhancement Notification Page 17 of 61  Note: Delivery Charges Invoice can be recorded only in the same currency as that of the Order document. Enhancement Notification Page 18 of 61 WHAT’S NEW IN SUPPLIER ORDER BASED INVOICE? Ability to record multiple invoices for Exchange PO Reference: AHBF- 18360, AHBF- 18970 Background In an Exchange of Parts with the vendor against an Exchange Purchase Order, a flat exchange fee is charged. However at times when a second Invoice is served for Repair Cost of the exchanged Part, facility should be provided to record that Invoice against the same Exchange Purchase Order. The business requirement is to facilitate subsequent Invoice for the repair cost recorded in the Exchange Purchase Order. Change Details Maintain Invoice Screen under Supplier Order Based Invoice is enhanced to record Invoices for the entities ‘ Exchange Fee’ and ‘ Repair Cost’ separately for the same Exchange Purchase Order. The Entity column in the multiline will show up the cost which is being invoiced. ‘ Get Details’ action button is enhanced to retrieve the pending entity ( say Repair Cost) which is to be invoiced. Exhibit 2: Supplier Order Based Invoice  Maintain Invoice Enhancement Notification Page 19 of 61 WHAT’S NEW IN SUPPLIER INVOICING Requirement to retrieve open debit documents for adjustment Reference - AHBF- 16278 Background At the time of recording supplier invoices, there could be some open unapplied debit documents like Prepayment Vouchers, Debit Notes etc., existing for that supplier. Provision must exist for automatic retrieval of such open debit documents pertaining to the supplier for adjustment during creation of adjustment vouchers. Example – Transaction with open Debit Document Supplier Expense Invoice $ 10,000 Prepayment already made to Supplier $ 6,000 Adjustment needed $ 6,000 Change Details A new link Create Adjustment has been added in Create Expense Invoice, Edit Expense Invoice and Authorize Expense Invoice screens under the component Supplier Direct Invoice ( Exhibit 1). The Create Adjustment link has also been added in Maintain Invoice and Match Invoice invoices under the component Supplier Order Based invoice ( Exhibit 3). On launch of the Create Adjustment link from the above screens after authorization of the invoice, all the open unadjusted debit documents for that supplier will be displayed in the Debit Documents multiline for adjustment ( Exhibit 2). The Create Multi Currency Adjustment screen has been enhanced and will now display all the unadjusted debit documents of the same currency for adjustment, if launched from the Invoice screens. The Adjustment vouchers can then be created with required debit documents.  Note: If the Adjustment screens are not permitted for the Invoice users, data level security must be enabled for this link Create Adjustment. Enhancement Notification Page 20 of 61 Exhibit 1 : Addition of the Create Adjustment link in the Create Expense Invoice screen.  Note: Similarly the Create Adjustment link is added in the Edit Expense Invoice and Authorize Expense Invoice screens. Exhibit 2 : Dispay of Open Debit documents in the Create Multi Currency Adjustment screen Addition of the Create Adjustment link. Open Debit docs for the supplier Enhancement Notification Page 21 of 61 WHAT’S NEW IN SUPPLIER PREPAYMENT VOUCHER? Ability to create Supplier prepayment voucher with pay currency different from that of bank currency Reference: AHBG- 94 Background In case of advance payments to vendors in vendor’s currency which is other than our bank currency, facility needs to be provided in the prepayment voucher to select the bank code which of different currency. Currently, if Pay Currency is selected as ‘ USD’ ( for e. g.), then payment can be made only through USD bank. Requirement is to enable creation of Supplier Prepayments vouchers by selecting a Pay Currency different from that of the bank currency. Change Details The restriction to select the Bank Currency same as the Pay Currency is relaxed to enable cross currency payments. New controls; ‘ Bank Currency’, ‘ Pay currency to Bank Exchange Rate’, ‘ Pay Amount in Bank Currency’ and ‘ Bank Currency to Base Exchange rate’ are introduced in Create Prepayment Voucher, Edit Prepayment Voucher and Authorize Prepayment Voucher screens to enable the cross currency payments. Additionally the existing editable field ‘ Exchange Rate’ is renamed as ‘ Pay Curr. to Base Exch. Rate’. Prepayment Voucher • Pay Curr. to Base Exch. Rate: Exchange rate between Pay Currency and Base Currency is retrieved and displayed. This exchange rate can be modified. • Pay Curr. to Bank Exch. Rate: Exchange rate between Pay Currency and Bank Currency is retrieved and displayed. This exchange rate can be modified based on the Bank’s exchange rate as on date. • Bank Currency: The Currency for the Bank / Cash # selected will be displayed in this field. • Pay Amt. in Bank Curr.: Pay amount in terms of bank currency will be displayed after considering the Pay Currency to Bank exchange. • Exchange rate variance arising out of differences in arriving at the base value from ‘ Pay Curr. to Base Exch. Rate’ and ‘ Bank Curr. to Base Exch. Rate’, will be posted to the Exchange Rate Variance account ( i. e. account code mapped to the predefined usage " ERTVAR"). Enhancement Notification Page 22 of 61 • Additional non- mandatory Voucher Category drop- down ( which lists the user defined quick codes defined under the entity Prepayment Voucher Category) is introduced to categorize the prepayment vouchers. Exhibit 1: Create Prepayment Voucher Screen Exhibit 3 : Addition of the Create Adjustment link in the Maintain Invoice screen. New controls are introduced to facilitatecreation of Supplier prepayment voucher with a pay currency different from that of bankcurrency Enhancement Notification Page 23 of 61  Note: Similarly, the Create Adjustment link has also been added in the Match Invoice screen. Addition of the Create Adjustment link. Enhancement Notification Page 24 of 61 WHAT’S NEW IN SUPPLIER BANK ACCOUNT INFORMATION Ability to Encrypt Payee Bank Account No Reference - AHBF- 18664 Background Supplier Bank Account details are specified in the Edit Supplier Bank Information screen in Supplier business component. For Electronic Fund Transfers ( EFT Payments) through the application, this Payee Bank A/ c No. will be referred for making payments. Payee Bank A/ c No. being a sensitive data is required to be encrypted and stored in the database, for security purpose. Change Details A new set option ‘ Encrypt Payee Bank A/ c No in Database’ is added in the Logistics Common Master business component under the category Supplier for encryption of Payee Bank A/ c No in database. This option can be set as “ 0” ( No) or “ 1” ( Yes). If the option is set as “ 1” ( Yes), Payee Bank A/ C No will be encrypted and stored in the database. Exhibit 1 : Set option in Logistics Common Master business component for Encryption of Payee A/ c # New Set Option Enhancement Notification Page 25 of 61 Exhibit 2: Display of Payee Bank A/ c No column in Supplier Master • The “ Payee Bank A/ c No.” entered in the Edit Supplier Bank Information screen in Supplier Master will be stored in an encrypted form in a new field in the database, if the above set option is ‘ Yes’. The existing field where this value is stored will not have any value. • However the “ Payee Bank A/ c No.” will be decrypted and displayed in the Edit Supplier Bank Information and View Supplier Bank Information screens. • If the above set option is ‘ No’, the “ Payee Bank A/ c No.” entered in the Supplier Bank Information in the Supplier Master will be stored normally in the database. Payee Bank A/ c # will be in encrypted form in the database. Enhancement Notification Page 26 of 61 WHAT’S NEW IN CUSTOMER BALANCE ADJUSTMENT? Ability to enable Debit documents from another group company in Customer Balance Adjustment Reference: AHBF- 17710 Background Remittances of funds from common customers of a group of companies could be collected by the bank of one company within the group and matched with the Invoices of the respective group company. This happens when the receivables/ collection function is managed by a common team for the group. Provision to match remittances against invoices must be allowed in the receiving company while creating the receipts and while performing Customer Balance Adjustments. Change Details Set Option – Set Finance Parameter • New process parameters Allow Inter Company transaction in Customer Receipt and Allow Inter Company transactions in Customer Balance Adjustment have been introduced with permitted values 0 for No and 1 for Yes in the Set Finance Process Parameters under Company Level parameter & business process Receivable Management. Exhibit 1: The Set Finance Process Parameters screen Enhancement Notification Page 27 of 61 Customer Receipt – Auto Adjustment The Create Receipt screen has been enhanced to match remittances against Invoices pertaining to other Group Companies. • Retrieval of debit documents from other group companies is enabled through the Finance Book drop- down in the Document Reference section. This combo will be loaded based on the set option and CIM interaction provided. • If Allow Inter Company transaction in Customer Receipt is ‘ Yes’ and if the CIM interaction between the Source Company Organization Unit and the Destination Company Organization Unit between Customer Invoices and Customer Receipts respectively, Active Posting Finance Book of all Group Companies will get loaded. • Data retrieved in the multiline will be based on the Finance Book specified. In multiline new column ‘ Finance Book’ is also included to identify the FB of the debit document. • Customer receipts can be created with the Auto- Adjust option against debit documents from the same Company or from any other company with one company at a time. Receipt cannot be created ( with Auto- Adjust option) against debit documents from multiple Companies at the same time. • In Create Receipt screen, Auto Adjustment can be done only if the receipt currency and debit document’s currency are same. • Accounting will be through the pre- defined usage id ' INTERCOMPFUNDS'. In case of Foreign- Currency adjustment “ Exchange rate” as on Receipt date in the Enhancement Notification Page 28 of 61 login Company will be considered for Exchange rate Variance and will be accounted in debit document’s Company. • For Instance, the customer receipt created in PFB- B1/ OU- B and Debit documents are retrieved from PFB- A1/ OU- A Adjustment Account Posting in Login OU- B & Debit Document's OU- A: Account Dr/ Cr FB/ OU Customer Receipt Bank/ Cash Account Dr PFB- B1/ OU- B Customer Control Account Cr PFB- B1/ OU- B Auto Adjustment Customer Control Account Dr PFB- B1/ OU- B Inter Company Account* Cr PFB- B1/ OU- B Inter Company Account* Dr PFB- A1/ OU- A Customer Control Account Cr PFB- A1/ OU- A * Inter Company Account: Account Code mapped against pre- defined usage id ' INTERCOMPFUNDS' Exhibit 2: The Create Receipt screen Enhancement Notification Page 29 of 61 Customer Balance Adjustment – Multi Currency The Create Multi Currency Adjustment Voucher screen has been enhanced to create adjustment voucher with debit documents from other Group Company, • In the Multi Currency Adjustment screen, for the specified Customer #, debit documents from different Group Company can be retrieved for adjustment based on the set options provided in Set Finance Process Parameters and CIM interaction between Customer Balance Adjustment of the source company and Customer Invoice of the destination company. Debit documents of only one Company can be retrieved & adjusted at a time. • To facilitate retrieval of debit documents from different group company, in debit document’s Help, Billing Point combo is loaded with the list of all Group Companies based on set option. On click of search debit documents gets retrieved in multiline with Finance Book information based on the Billing point & Finance Book specified in search criteria. • Accounting will be through the pre- defined usage id ' INTERCOMPFUNDS'. In case of Foreign- Currency adjustment “ Exchange rate” as on Receipt date in the login Company will be considered for Exchange rate Variance and will be accounted in debit document’s Company. Debit documents from group companies can be retrieved and Auto Adjusted Finance Book from all Group Companies will be loaded based on set option Enhancement Notification Page 30 of 61 • For Instance, Adjustment Voucher created in PFB- B1/ OU- B and Debit documents are retrieved from PFB- A1/ OU- A Adjustment Account Posting in Login OU- B & Debit Document's OU- A: Account Dr/ Cr FB/ OU Customer Control Account Dr PFB- B1/ OU- B Inter Company Account* Cr PFB- B1/ OU- B Inter Company Account* Dr PFB- A1/ OU- A Customer Control Account Cr PFB- A1/ OU- A * Inter Company Account: Account Code mapped against pre- defined usage id ' INTERCOMPFUNDS' Exhibit 3: The Help on Debit Documents screen Billing Point drop- down list box is loaded with all active Group Companies based on a process parameter Enhancement Notification Page 31 of 61 Exhibit 4: The Create Multi Currency Adjustment Voucher screen Debit document from different group company is retrieved & adjusted Enhancement Notification Page 32 of 61 WHAT’S NEW IN ACCOUNT INQUIRY Requirement to display reference documents for Inter FB JV Reference - AHBF- 16265 Background In a Company setup that has multiple finance books or companies under the same group, there may Inter- Finance Book/ Inter- Company transactions through Journal Vouchers ( JV), Expense Invoices etc. Upon authorization of Inter FB JV or Expense Invoices in the origin company/ finance book, Inter FB JV are automatically generated in the destination finance book. Provision is required to display these Inter FB reference documents in the Account Inquiry screen to ensure the documents can be viewed directly on click of the Ref. Doc. # link. Change Details A data hyperlink is enabled for the reference documents - Journal Vouchers and Supplier Expense Invoices for which automatic JV are generated in the Ref. Doc. # column of the Transaction Level Details section. Refer Exhibit - 1. Exhibit - 1: The Account Inquiry screen with the Ref. Doc. # link. . Ref. Doc. # enabled with link for Intercompany and Inter FB Transactions. Enhancement Notification Page 33 of 61 On reviewing the Inter FB account code, by specifying Finance book and From/ To Date for Account Inquiry, The transaction level details including Ref. Doc. # for the Inter FB transaction is displayed. On click of the Ref. Doc # link, the reference document can be viewed. Similarly, the transaction level details including Ref. Doc. # for the Inter- Company account code is displayed. On click of the Ref. Doc # link, the reference document from the other OU can be viewed. Combinations for which Inter Company JV and Inter Company Expense Invoice transactions are given visibility illustrated in the below table: S. No. Transaction # ( OU 1) Ref. Doc. # ( OU 2) 1 Journal Voucher ( auto generated) Inter Company Journal Voucher 2 Journal Voucher ( auto generated) Inter Company Supplier Expense Invoice Enhancement Notification Page 34 of 61 WHAT’S NEW IN CUSTOMER ITEM BASED NOTE Requirement to modify taxable amount in Customer Item Based Note Reference - AHBF- 17715 Background TCDs can be applied to the Customer Item Based Notes ( Debit/ Credit notes). The entire value of Customer Item Based Note may not be taxable. In some cases taxability is determined based on the nature of services rendered, and there is a need to segregate the values as taxable and non- taxable amounts. Similarly, when the Customer Item Based Notes are recorded there may be cases where the entire note value is not taxable with the same percentage of tax. Some items may be exempt from tax or may be taxable at a different percentage. Provision is required to modify the taxable amount so that the appropriate value can be saved as taxable for each tax. Example: Customer Item Based Note with tax exempted items Total Value $ 10,000 Taxable Value $ 8,000 Exempted value $ 2,000 Note value to be taxed $ 8,000 Change Details i. A new set option is introduced in Set Finance Process Parameters page of OU Parameter Setup business component for modification of taxable amount. Refer Exhibit 1. ii. The ‘ Taxable Amount’ column is changed from display only control to editable control in the TCD screens of Create, Edit and Authorize Customer Item Based Note. Refer Exhibit 2. Enhancement Notification Page 35 of 61 Exhibit 1: Set Option in Set Finance Process Parameters screen Exhibit 2: Taxable Amount column in Tax/ Charge/ Discount screen of Create, Edit and Authorize Customer Item base Notebased Note  Note: If the set option ‘ Allow modification of Taxable Amount’ is set as ‘ No’ then modification of Taxable amount will be restricted in Customer Item Based Note.  If the set option ‘ Allow modification of Taxable Amount’ is set as ‘ Yes’ then the taxable amount will be allowed to be modified.  The Taxable amount modified cannot exceed the actual taxable amount. New set option for Taxable Amount modification Taxable Amount is changed as editable control Enhancement Notification Page 36 of 61  On modification of base value of the note, Taxable Amount and Tax Amounts ( in case of % based TCDs) are recomputed provided the taxable amount is not previously modified for that TCD.  The base value of the note cannot be modified below the Taxable amounts in the TCDs.  In case of Flat TCD the TCD value will not change irrespective of taxable amount modification.  Taxable Amount can be modified even for Charges and Discounts. Enhancement Notification Page 37 of 61 WHAT’S NEW IN CUSTOMER SERVICE INVOICE? Ability to Modify the Bill to Customer in Customer Service Invoice & Prepayment Invoice Reference: AHBF- 16797 Background Bill to Customer in Customer Service/ Prepayment Invoice is the bill to customer captured in the customer order. However, a Service/ Prepayment Invoice can be served on another customer different from that of the customer in the customer order. To facilitate this requirement, provision has been made to allow modification of Bill to Customer in customer service invoices, provided the modified customer # is mentioned as bill to customer of the original customer. Change Details Customer Service Invoice – Manage Invoice In the Manage Invoice screen, following enhancement has been made to enable the above requirement, • In the Manage Invoice screen, defaulted Bill to Customer is allowed to be modified with another customer provided the modified customer # is a bill to customer of the Primary customer in the released Customer Order / Invoice. • Once the bill to customer is modified & authorized, the invoice will be processed against the modified customer #. • In Customer Balance Adjustment, an authorized invoice can be retrieved and adjusted against the credit documents of the modified customer. • If a service invoice is authorized with the Auto- Adjust option, the credit documents of the modified customer # will be considered for auto adjustment. Customer Prepayment Invoice – Manage Invoice • If a prepayment invoice is created against a customer order, Bill to Customer is defaulted with Bill to customer of the customer order. In the Manage Invoice screen, defaulted Bill to Customer is allowed to be modified with another customer provided the modified customer # is a bill to customer of the Primary customer in the customer order. Enhancement Notification Page 38 of 61 • Once bill to customer of the prepayment invoice is modified & authorized, it can be adjusted with receipts or credit documents of the modified customer. Exhibit 1: The Manage Invoice screen Bill to Customer is now editable. Enhancement Notification Page 39 of 61 WHAT’S NEW IN EDK REPORTS RECEIVABLES MANAGEMENT? Report on Invoice / Receipt with additional Information Reference: AABI- 564 Background New report to provide Invoice information and Receipt information for a date range with customer, additional categories, additional attributes and contact categories of the customer master. The contact categories can be used for identifying the Customer representatives in the Customer Master. This report provides invoice details and receipt details with the customer representative information which can be used for analysis. For instance, customer representatives can be modelled as Commission Agents in the Customer Master, and with this report, Invoice & receipt information can be analyzed based on the Customer Representatives. Change Details A new report “ Invoice and Receipt Report” is provided under the EDK Reports Receivables Management business component. Refer Exhibit 1. This report provides Invoice information and Receipt information for a date range with additional attributes, additional categories and contact category with the Customer representative information. There are two Report Types “ Invoice” and “ Receipt”, which are two different reports which display the Invoices with revenue and cost information, and Receipts with Invoice information respectively. This report will be displayed for the following documents: 1. Service Invoice 2. Miscellaneous Invoice 3. Debit / Credit Note 4. Prepayment Invoice 5. Pack Slip Invoice 6. Direct Invoice Invoice Report: This report displays the following information relating to Invoice such as Invoice Date, Customer, Invoice #, Revenue, Cost, Taxes, Charges, Discount, Customer Order, Customer PO, additional attributes of the customer and Customer representative Information. Refer Exhibit 2. Receipt Report: This report provides the following information relating to Receipt such as Receipt date, Customer, Receipt Amount, Receipt Mode, Invoice #, Invoice Date, Additional Attributes of Customer and the Customer representative Information. Refer Exhibit 3. Enhancement Notification Page 40 of 61 Exhibit 1: Report Search Input Screen:  Note: Based on the report type selected the Invoice or Receipt report will be generated. Exhibit 2: Invoice Report: Enhancement Notification Page 41 of 61 Exhibit 2: Receipt Report: Enhancement Notification Page 42 of 61 WHAT’S NEW IN FINANCIAL STATEMENTS? Ability to View Balance Sheet and Income Statement at different levels Reference: AHBF- 19186 Background Financial Statements give broader view of the financial position of the company and it is required to perform an online review at any point of time to understand the financial position. Online review of financial statements such as Trial balance, Balance sheet and Income statements with dynamic layout structures along with various groups such as months, quarters, and semi- annual is largely desired and highly critical for the understanding of financial position of the company. Business need is to provide the capability to view the Balance Sheet and Income Statement Semi- Annually, Quarterly and Monthly. Also, a provision to compare them with the previous periods or years is required. Change Details The following controls are added in the Balance Sheet and Income Statements tab of the Review Financial Statements screen of the Finance Book Processing business component in the ‘ Additional Display Options’ section. • Group by o This combo will be loaded with the values ‘ Annual’, ‘ Semi- Annual’, ‘ Quarters’ and ‘ Months’. The statements displayed in the multiline will be displayed according to the level selected in this combo • Comparison o This combo will be loaded with the values ‘ Previous periods’ and ‘ Previous Year’. Based on the value selected, user will be able to review the statements by comparing with the previous finance period or the previous finance year. o The value ‘ Previous Period’ is applicable only if the Group by field is selected as ‘ Annual’ • YTD o The value displayed in the statement shall be displayed Year- To- Date if this check- box is selected Enhancement Notification Page 43 of 61 Exhibit 1: Identifies the Quarterly Balance Sheet Exhibit 2: Identifies the Monthly Income Statement  Limitation: If the YTD is not selected, the value displayed for the given period in the Balance Sheet is the value pertaining to that given period, though the caption of the field has the string “ As on Date”  Note: This feature involves commercials and is not available for all customers. Please contact your Ramco Account Manager. Displays the Quarter applicable Displays the Months applicable Enhancement Notification Page 44 of 61 WHAT’S NEW IN ASSET CAPITALIZATION? Ability to enable Inter Finance Book Capitalization of Assets Reference: AHBC- 1800 Background An aircraft’s holding finance book will account for the maintenance cost for the aircraft. In a business arrangement in which aircraft is owned by one company and leased to another group company ( group companies are modeled as finance books) and aircraft maintenance activities are carried out by the lessee company, the Revenue maintenance costs are borne by the lessee Company and the Capital maintenance costs are capitalized in the Lessor Company. In such situations, the aircraft’s holding finance book must account for the Revenue maintenance cost on the aircraft but the capital maintenance costs are to be capitalized in a different finance book. Currently in capitalizations and amendments, the sources capital documents ( AME, SWO, PO & RO based Invoice) can refer Asset Proposal from same finance book as that of the aircraft’s holding finance book and Capitalizations can be carried out against the same finance book. Requirement to allow Asset Proposals from that of a different finance book in source documents for capitalization. Change Details To address this requirement, capital source documents ( AME, SWO, PO & RO) has been enhanced to refer an Asset Proposal ( CAPEX Proposal) from a different Finance Book. Create and Amend Asset Record screen has been enhanced to retrieve capital documents ( AME, SWO, PO & RO based Invoice) referring to a Finance book, to create Assets with Asset Proposals of another Finance Book. Set options • In the Set Finance Process Parameters screen, a new process parameter Allow Capex Proposal # from different Finance Book in Purchase Order is has been introduced in the multiline with permitted values as 0 for No and 1 for Yes. • The above option will be available for parameter level - Company Level, Business Process - Fixed Asset Management & Category - Asset Planning. Enhancement Notification Page 45 of 61 Exhibit 1: The Set Finance Process Parameters screen Asset Planning – Create Purchase Order • For a purchase order with expense type ‘ Capital’, CAPEX Proposal # of a different finance book other than Warehouse's FB ( in case of a General PO) or ‘ Expense to’ FB ( in case of a Service/ Adhoc PO) is allowed based on the above process parameter value. • Goods Receipt/ Invoice of the Capital PO will be retrieved for capitalization against the proposal specified in the purchase order. • For Instance, a purchase order with expense type ‘ Capital’ is created with CAPEX Proposal # from FB- 2 other than Warehouse's FB ( FB- 1), the account posting for the good receipt will be as follows, Account Dr/ Cr Finance Book CWIP Account Dr FB- 2 Inter FB Account Cr FB- 2 Inter FB Account Dr FB- 1 Supplier Suspense a/ c Cr FB- 1 • For other Capital Documents – AME, SWO & RO, Capex Proposal # from all Active finance books is allowed to be provided. The source documents will be retrieved for capitalization against the proposal specified during AME, SWO & RO creation. • To facilitate selection of Finance Book in the source documents, the Help on Proposal # screen is enhanced with the Finance Book drop- down list box. Proposal # will be retrieved based on Finance book specified in the search criteria. Enhancement Notification Page 46 of 61 Exhibit 2: The Help on Proposal Number screen Asset Capitalization – Create Asset Record • In the Create Asset Record screen, Capital documents ( AME, SWO, PO based GR/ Invoice) from all Finance Book will be retrieved for capitalization based on Finance Book specified in search option. • In the Create Asset Record screen, CAPEX Proposal # is allowed to be modified with the Proposal from different Finance book. • New Asset will be created under the Finance Book of the modified Proposal. • For Instance, If Capital document from FB- 1 is capitalized by modifying CAPEX Proposal # from FB- 2, then the asset will be created in FB- 2 and account posting will be as below, Account Dr/ Cr Finance Book Inter FB Account Dr FB- 1 CWIP Account Cr FB- 1 Asset Account Dr FB- 2 Inter FB Account Cr FB- 2 • Proposal balance updates ( viz. committed and utilized amounts) of both the CAPEX Proposal # will be updated accordingly. Finance Book Combo loading with all active Finance Enhancement Notification Page 47 of 61 Exhibit 3: The Create Asset Record screen Asset Capitalization – Amend Asset Record • In the Amend Asset Record screen, Capital documents ( AME, SWO, PO & RO based Invoice) from all finance books will be retrieved for capitalization. • In the Amend Asset Record screen, Proposal # of the document in the header is allowed to be modified with Proposal # from that of the asset finance book. • Asset # and Proposal # must be from the same Finance Book. • Proposal balance ( viz. committed and utilized amounts) of both CAPEX Proposal # will be updated accordingly. Proposal No. from different FB can be provided Enhancement Notification Page 48 of 61 Exhibit 4: The Amend Asset Record screen Proposal No. from different FB can be modified Asset No & Proposal No Should be from same Finance Book Enhancement Notification Page 49 of 61 WHAT’S NEW IN USAGE BASED DEPRECIATION? Ability to compute CME Depreciation for Components considering In- service usage Reference: AHBG- 337 Background When usage based depreciation is computed for second hand components, the usage attributable to the previous owner is being considered incorrectly, leading to excess depreciation in the first period and relatively lesser value in the succeeding periods. Ability should be provided to consider usage attributable to the previous owner( s) i. e. the Opening Usage of a component and compute depreciation accordingly. Change Details To address this requirement, depreciation computation is being enhanced to consider opening usage ( usage attributable to the previous owner) based on the option set in the Set Finance Parameter activity. Set options • In the Set Finance Parameter screen, on selection of ‘ Parameter Level’ as ' Company Level', ‘ Business Process’ as ' Fixed Asset Management' and, Category as ' Asset Depreciation Processing', a new set option ‘ Consider usage as on In Service Date for CME depreciation computation’ can be viewed in the multiline with Permitted Values as " Enter 0 for No and 1 for Yes"  Note: this option cannot be modified once usage based depreciation is processed for a period. Exhibit 1: Set Finance Process Parameters screen Enhancement Notification Page 50 of 61 Confirm Usage & View Depreciation • In the Confirm Usage and View Depreciation screen, a new column “ Usage – In service date” is introduced in the multiline and the same will be displayed only when the set option “ Consider Opening usage on In Service Date for CME Depreciation computation" is set as ‘ 1’ – Yes. • For the assets retrieved in the multiline, along with the maintenance interval, current usage information etc., Usage as on In- service date from TSN/ TSO value as on In- service date from the Component Records is also retrieved and displayed. • Opening usage as on In- Service date can be modified in Confirm Usage & View Depreciation screen. Once modified, the modified usage will be saved and retrieved during depreciation computation of succeeding periods. • For assets which are depreciated based on “ Usage - Life to Overhaul”, usage as on In- Service date will be considered only in the first Maintenance interval and not in succeeding Maintenance intervals. Depreciation Computation • The formula for the Book Value computation for the Usage Based Depreciation Method will be based on above mentioned set option as follows,  Depreciation = Opening Book value – Book Value*** *** Book Value = [ Asset Cost / Maintenance Interval] * Remaining Usage when the option ‘ Consider usage as on In Service Date for CME depreciation computation’ is set as “ No” *** Book Value = [ Asset Cost / ( Maintenance Interval – Usage In- service date)] * Remaining Usage when the option ‘ Consider usage as on In Service Date for CME depreciation computation’ is set as “ Yes”  Remaining Usage = Maintenance Interval – Actual period’s Cumulative Usage  Usage In- service date = TSN or TSO as on In Service Date Enhancement Notification Page 51 of 61 Exhibit 2: Confirm Usage and View Depreciation screen New Column “ Usage – In Service Date” is introduced Enhancement Notification Page 52 of 61 WHAT’S NEW IN ORDER BASED INVOICE? Ability to Post the Invoice Price variance to its Work Order's Cost Reference: AHBF- 20242 Background Invoice Price Variance arising due to variance in Invoice rate and Order rate is adjusted to Inventory value through automatic Stock Correction ( based on a set option). When parts are procured and the Invoices are recorded with variances, stock correction scheduler routine will increase/ decrease the inventory value for the parts available in Inventory. Stock correction will not happen if the parts are not available in Inventory i. e. parts are already issued to Shop Work Order/ AME. The requirement is to post the Invoice Variance amount of those parts that were issued against Shop Work Order/ AME to its respective consumption/ cost account. Change Details To address this requirement, Stock correction scheduler has been enhanced for parts which are not available in inventory and issued against work order / AME. Only Serial Controlled Part where Stock Correction has failed due to non- availability of stock will be considered. Latest SWO/ AME which is in Closed or Pre- Closed status will be considered for Invoice Rate Variance. Set options • In Set Finance Process Parameter screen, two new set options ‘ Post Invoice Rate Variance to SWOs if part is not available for Stock Correction’ and ‘ Post Invoice Rate Variance to AMEs if part is not available for Stock Correction’ has been introduced in the multiline with Permitted Values as " Enter ' 0' for No & ' 1' for Yes". Enhancement Notification Page 53 of 61 Exhibit 1: “ Set Finance Process Parameter” • The above set option can be provided only when Auto Stock Correction is enabled for Invoice Rate Variance in the Set function Default screen ( i. e. this option ‘ Auto Generate Stock Correction for Invoice Rate Variance’ is defined as “ Yes”.). Stock Correction Scheduler Routine • In Set Function Default in the Order based Invoice if ‘ Post Rate Variance for Expense to’ is set as “ Invoice Price Variance” then the variance amount will be posted to Invoice Price Variance account in all the above scenarios as shown below ( for positive Variance) Account Dr / Cr Invoice Price Variance A/ c Dr Supplier Control account Cr • Once stock correction happens for the parts available in the stock from Invoice Price Variance, the same scheduler routine is enhanced to trace the SWO/ AME against which the part has been issued. ( Part & Serial # invoiced), through Maintenance issue. • If the SWO / AME traced is in ‘ Closed’ status, stock correction scheduler routine will post Invoice Price Variance to its respective consumption account by generating automatic Journal Voucher ( JV) with the Voucher type - " WOADJ" in " Authorized" status. Enhancement Notification Page 54 of 61 • The JV amount is updated in the WO Cost for the Entity " Material Cost" against the respective Task for which part has been Issued/ Consumed. • Account postings for Auto generated JV will be follows, Repair cost Variance Event/ Task Account posting for Variance amount If Set option – ‘ Yes’ Order based Invoice # created with variance amount Part # is issued to SWO# SWO# is in " Closed" Status Stock Correction Scheduler routine Maintenance Consumption A/ c Dr ( SWO - Material Cost) To Invoice Price Variance Order based Invoice # created with variance amount Part # is issued to AME # AME # is in " Closed" Status Stock Correction Scheduler routine Maintenance Consumption A/ c Dr ( AME- Material Cost) To Invoice Price Variance Supplier Order Based Invoice – Reverse Invoice • When the Consumption account is posted by Stock Correction Routine from Invoice Rate Variance and an Order Based Invoice having Invoice Price Variance is reversed, an auto JV is be generated with the reversal effect. • Account Postings of auto JV generated for the parts not available in warehouse on Stock Correction Scheduler will be as follows: Scenario - Invoice Variance Task Account posting for Variance amount If Set option – ‘ Yes’ Order based Invoice# created with variance amount Part# is issued to SWO# SWO# is in " Closed" Status Stock Correction Scheduler routine Invoice Price Variance Dr To Maintenance Consumption A/ c ( SWO - Material Cost) Order based Invoice# created with variance amount Part# is issued to AME# AME# is in " Closed" Status Stock Correction Scheduler routine Invoice Price Variance Dr To Maintenance Consumption A/ c ( AME - Material Cost) • The user would be able to view such JVs generated in View Journal Voucher screen i. e. Automatic JV generated for posting Invoice Rate Variance to WO is retrieved against Voucher Type - " WO Adj - Journal". Enhancement Notification Page 55 of 61 • In case the automatic JV is to be reversed, the same can be done in Reverse Journal Voucher screen, i. e. Automatic JV generated for posting Invoice Rate Variance to Work Order is retrieved against Voucher Type - " WO Adj - Journal" for reversal.  Note: SWO/ AME with expense type “ Revenue” only will be considered for Auto JV.  The variance arising on account of Invoicing of Serial controlled parts only will be considered for posting Invoice Price Variance to Work Order’s cost.  In an ‘ add to stock’ work order, the variance amount will be posted to the Consumption account.  MRO Jobs: the Invoice Price variance posted to COSR- Materials in case of Customer Order based work orders which are having part pricing based on actual issue cost (“ Cost Plus” pricing); the value of the Invoice Price Variance can be added manually as Additional Charges to the Customer Order. Enhancement Notification Page 56 of 61 WHAT’S NEW IN REPAIR ORDER AMENDMENT? Ability to Post the Repair Expense variance to Consumption Reference: AHBF- 20502 Background Maintenance expenses on components / parts and repair costs incurred through external repairs can be added to stock or expensed off based on option setting. In case of Repair Order, the value as per the repair quote will be added to the Inventory value and moved to stock, during confirmation and movement of Repair Receipt. On receipt of Invoice, the amount could be different from Quote value. In such scenario, the Repair order is amended or invoice is authorized with variance. Variance cost is currently posted to Repair Expense Variance not to the Maintenance Consumption account ( Add to stock scenario). Requirement is to post the variance amount to the respective consumption account of the Repair Order. Change Details To address this requirement, following enhancements are done in account postings of Repair cost variance amount during authorization of Repair order amendment ( for stand- alone RO) and RO based Invoice with variance. Set options • In the Set Options activity of the Account Group business component, a new set option “ Accounting Policy for Repair Cost Variance - Internal" is introduced with permitted values as “ Enter ' 0' for Repair Expense Variance & ' 1' for Maint. Consumption". Enhancement Notification Page 57 of 61 Exhibit 1: “ Set Option” screen in Inventory Setup - Account Group  Note: If above option is not set, it will be considered as ' 0' - Repair Expense Variance ( existing functionality). Authorize Repair Order - RO Amendment • On Authorizing stand- alone RO Amendment for Repair cost variance ( Add to stock), Account posting will be based on above set option. If Account Group set option " Accounting Policy for Repair cost Variance - Internal" is set as ' 1' – variance in Repair Cost will be accounted to Maintenance Consumption, for its corresponding Entity ( Exchange Cost or Repair Cost). • Account postings for Repair Cost variance on Authorization of stand- alone RO amendment will be as follows: Scenario - Repair cost Variance Task Account posting for Variance amount If Set option is “ Maint. Consumption” If Set option is “ Repair Expense Variance” Stand- alone Repair Order RO is in " Closed" Status Authorization of RO Amendment Maint. Consumption - RO A/ c Dr To Supplier Suspense – Services Repair Expense Variance A/ c Dr To Supplier Suspense - Services Enhancement Notification Page 58 of 61 Authorization of RO based Invoice – with Variance amount • In Set Function Default in Order based Invoice " Post Rate Variance for Expense to" is set as ' Direct Expense Heads' then variance amount will be posted to Maintenance Consumption or Repair Expense Variance whichever is set in Account Group - Set options. • Account Postings on authorization of RO ( stand- alone) based Invoice with variance amount will be as follows: Scenario - Repair cost Variance Task Account posting for Variance amount If Set option is “ Maint. Consumption” If Set option is “ Repair Expense variance” Stand- alone Repair Order RO is in " Closed" Status Authorization of Invoice with Variance Maint. Consumption - RO A/ c Dr To Supplier Control account Repair Expense Variance A/ c Dr To Supplier Control account Enhancement Notification Page 59 of 61 WHAT’S NEW IN COMPANY CONSOLIDATION Requirement to consolidate the companies with different financial years Reference - AHBF- 18090 Background In an organizational setup there might be companies having parent and child relationship. The financial statements of parent and child companies are consolidated and displayed in the consolidated financial statements. The financial year of the child company must coincide with that of the parent for consolidation purpose. Provision is required to consolidate the financials of parent and Child Company where the financial year of the child company is different from that of the parent and calculate the retained earnings accordingly. Example: Parent and Child companies having different financial years FY of Parent Company Jan 14 to Dec 14 FY of Child Company Apr 14 to Mar 15 • In the above illustration financial year of Parent and Child Company are different and while consolidating financial statement of these companies, system should consider Financials of Child Company pertaining to Jan’ 14 to Dec’ 14 ( i. e., Parent Company’s Financial Year) • Retained earnings for the Consolidated Financial Statement will be computed based on the financial year pertaining to Jan’ 14 to Dec’ 14 ( i. e., Parent Company’s Financial Year) of both the Companies. • By consolidating the financials of group Companies for Parent Company’s Financial Year, Accurate Consolidated results can be generated. Change Details Simulate Company Consolidation screen is enhanced to consolidate the Child Companies based on the financial year of the Parent Company. On selection of the Financial Year and on click of get the Child Companies are listed in the multiline and will be available for simulation of Consolidation. Consolidate Company Screen is enhanced to consolidate the Child Companies based on the financial year of the Parent Company. On selection of the Child Company, the Financial Year of the Parent Company will be retrieved and the balances of the child Company pertaining to such Financial Year will be consolidated to the Parent Company. Enhancement Notification Page 60 of 61 Exhibit 1 – Simulate Company Consolidation Exhibit 2 – Consolidate Company Financial Year of the parent company gets displayed here. Child Company will be listed in the dropdown for Consolidation. © Copyright 2016, Ramco Systems Ltd. www. ramco. com Ramco Aviation Solution 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