Time Tracker 28th March 2013 Ramco Aviation Solution Version 5.7.6 Enhancement Notification Finance Enhancement Notification © Copyright 2015, Ramco Systems Ltd. www. ramco. com Ramco Aviation Solution DISCLAIMER © 2015 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 W H A T ’ S N E W I N A C C O U N T S P A Y A B L E H U B ?.................................................................................................... 6 P R O V I S I O N I N A P H U B T O E N A B L E V A R I O U S U S E R A C T I O N S L I K E E D I T / A U T H O R I Z E / H O L D R E L E A S E T A S K S B A S E D O N U S E R R I G H T S P R O V I D E D.............................................................................................................................. ................................ 6 Background..................................................................................................................... ......................................... 6 Change Details ............................................................................................................................... ......................... 6 REVIEW FINANCIAL STATEMENTS – AN OVERVIEW..................................................................................... 9 REQUIREMENT TO DRILL DOWN TO TRANSACTIONS FROM THE FINANCIAL STATEMENTS FOR ANALYSIS ................................ 9 Background..................................................................................................................... ......................................... 9 Change Details ............................................................................................................................... ......................... 9 WHAT’S NEW IN JOURNAL VOUCHER?............................................................................................................. 20 ABILITY TO RECORD INTER COMPANY JOURNAL ENTRIES ................................................................................................. 20 Background..................................................................................................................... ....................................... 20 Change Details ............................................................................................................................... ....................... 20 WHAT’S NEW IN SUPPLIER DIRECT INVOICE? ............................................................................................... 22 ABILITY TO TRANSFER EXPENSES FROM ONE COMPANY TO ANOTHER................................................................................. 22 Background..................................................................................................................... ....................................... 22 Change Details ............................................................................................................................... ....................... 22 WHAT’S NEW IN INTER BANK TRANSFER? ...................................................................................................... 24 REQUIREMENT TO TRANSFER FUNDS FROM ONE COMPANY TO ANOTHER ............................................................................ 24 Background..................................................................................................................... ....................................... 24 Change Details ............................................................................................................................... ....................... 24 PRE- REQUISITES FOR THE ABOVE FEATURES............................................................................................... 26 DEFINITION OF ACCOUNT CODE FOR INTER COMPANY TRANSACTIONS.............................................................................. 26 Background..................................................................................................................... ....................................... 26 Change Details ............................................................................................................................... ....................... 26 OPTION TO BE SET FOR ENABLING THIS FEATURE:.............................................................................................................. 27 Background..................................................................................................................... ....................................... 27 Change Details ............................................................................................................................... ....................... 27 W H A T ’ S N E W I N L A B O R C O S T I N G ? .................................................................................................................... 29 R E Q U I R E M E N T T O M A I N T A I N A N D U S E D I F F E R E N T I A L R A T E S F O R L A B O R C O S T I N G ............................................................ 29 Background..................................................................................................................... ....................................... 29 Change Details ............................................................................................................................... ....................... 29 WHAT’S NEW IN THE TAXATION FRAMEWORK? .......................................................................................... 33 ABILITY TO MANAGE RECIPIENT LIABLE TAXES IN US SALES TAX................................................................................... 33 Background..................................................................................................................... ....................................... 33 Change Details ............................................................................................................................... ....................... 33 WHAT’S NEW IN SUPPLIER INVOICING?........................................................................................................... 35 ABILITY TO MANAGE ACCOUNTING FOR RECIPIENT TAX.................................................................................................... 35 Background..................................................................................................................... ....................................... 35 Change Details ............................................................................................................................... ....................... 35 WHAT’S NEW IN SUPPLIER INVOICING............................................................................................................. 36 REQUIREMENT TO POST THE DIFFERENCES TO ROUNDING OFF ACCOUNT ........................................................................... 36 Background..................................................................................................................... ....................................... 36 Change Details ............................................................................................................................... ....................... 36 W H A T ’ S N E W I N R E P O R T S - R E C E I V A B L E S M A N A G E M E N T ? ..................................................................... 39 C U S T O M E R O R D E R P R O F I T A B I L I T Y R E P O R T...................................................................................................................... 39 Background..................................................................................................................... ....................................... 39 Change Details ............................................................................................................................... ....................... 39 WHAT’S NEW IN REPORTS- PAYABLES MANAGEMENT? ............................................................................ 42 THREE WAY ANALYSIS REPORT ............................................................................................................................... ....... 42 Background..................................................................................................................... ....................................... 42 Change Details ............................................................................................................................... ....................... 42 Report Output ............................................................................................................................... ......................... 42 WHAT’S NEW IN REPORTS?....................................................................................................................... ........... 44 REPORT ON WORK ORDERS WITH PART SHIPPED BUT NOT CLOSED.................................................................................... 44 Background..................................................................................................................... ....................................... 44 Change Details ............................................................................................................................... ....................... 44 WHAT’S NEW IN CUSTOMER AGEING? ............................................................................................................. 45 REQUIREMENT TO COMPUTE AGEING FOR CREDIT DOCUMENTS........................................................................................ 45 Background..................................................................................................................... ....................................... 45 Change Details ............................................................................................................................... ....................... 45 R E Q U I R E M E N T T O C O M P U T E A G E I N G B A S E D O N A D D I T I O N A L C A T E G O R I E S A N D A T T R I B U T E S A N D I N V O I C E D A T E............. 46 Background..................................................................................................................... ....................................... 46 Change Details ............................................................................................................................... ....................... 47 REQUIREMENT TO HAVE ADDITIONAL VISIBILITY TO DISPLAY TOTALS.............................................................................. 49 Background..................................................................................................................... ....................................... 49 Change Details ............................................................................................................................... ....................... 49 W H A T ’ S N E W I N S U P P L I E R A G E I N G ?................................................................................................................. 51 R E Q U I R E M E N T T O C O M P U T E A G E I N G F O R D E B I T D O C U M E N T S.......................................................................................... 51 Background..................................................................................................................... ....................................... 51 Change Details ............................................................................................................................... ....................... 51 R E Q U I R E M E N T T O H A V E A D D I T I O N A L V I S I B I L I T Y T O D I S P L A Y T O T A L S .............................................................................. 52 Background..................................................................................................................... ....................................... 52 Change Details ............................................................................................................................... ....................... 52 WHAT’S NEW IN EDK- REPORTS RECEIVABLES MANAGEMENT?............................................................ 55 ABILITY TO GENERATE CUSTOMER REMITTANCE ADVICE REPORT WITH REPORTING CURRENCY ....................................... 55 Background..................................................................................................................... ....................................... 55 Change Details ............................................................................................................................... ....................... 55 WHAT’S NEW IN REPORTS- RECEIVABLES MANAGEMENT? ..................................................................... 59 NEW REPORT TO VIEW CUSTOMER BALANCE ADJUSTMENTS............................................................................................ 59 Background..................................................................................................................... ....................................... 59 Change Details ............................................................................................................................... ....................... 59 WHAT’S NEW IN REPORTS- BOOK KEEPING? ................................................................................................. 62 ACCOUNT DISTRIBUTION REPORT – BY ACCOUNT CODE .................................................................................................. 62 Background..................................................................................................................... ....................................... 62 Change Details ............................................................................................................................... ....................... 62 Report Output ............................................................................................................................... ......................... 62 WHAT’S NEW IN REPORTS - RECEIVABLES MANAGEMENT? .................................................................... 65 ENHANCEMENTS IN CUSTOMER STATEMENT REPORT TO DISPLAY ADDITIONAL INFORMATION........................................... 65 Background..................................................................................................................... ....................................... 65 Change Details ............................................................................................................................... ....................... 65 Enhancement Notification W H A T ’ S N E W I N A C C O U N T S P A Y A B L E H U B ? P r o v i s i o n i n A P H u b t o e n a b l e v a r i o u s u s e r a c t i o n s l i k e e d i t / a u t h o r i z e / h o l d r e l e a s e t a s k s b a s e d o n u s e r r i g h t s p r o v i d e d Reference: AHBF- 12762 Background AP Hub is a new interactive Workspace to manage all AP Invoices and Notes ( One stop landing page for all Vendor Bills). It is compact and consolidated across various document types to reduce traversals to multiple screens. It enables bulk processing ( Authorization, Matching, Reversals, Hold, Release, Delete and so on) of Invoices and Notes across document types. Users can personalize by controlling the documents appearing in this HUB using the User Preferences provision. Additionally, payments can be initiated from this HUB through the Ezee Pay option. This enhancement is about enabling the action buttons which are possible for the user who is accessing this HUB based on the next – best action possible on the document. Based on the user- activity access, the action buttons will be enabled. Change Details  The following changes have been introduced, in order to enable the User Access Rights for the AP Hub activity:  Based on the status of document selected by the user for processing the action buttons, namely Authorize, Match, Return, Delete, Reverse, Hold, Release, Pay will be Enabled / Disabled.  Additionally, based on the user – activity access, the action buttons will restrict the user from executing the next possible action.  The changes hold good for Bulk Invoice Processing and Single Invoice Processing. Page 6 of 67 Enhancement Notification Exhibit 1: Status based enable / disable of buttons - Bulk Invoice Scenario 1: When Matched is selected by the user, the next possible action is enabled and other actions are disabled in Bulk invoice processing. Exhibit 2: Status based Enable / Disable of action buttons – Single Invoice Scenario 2: When invoice in ‘ Authorized’ status is selected by the user, the next possible actions enabled / disable in Single Invoice Processing. For Matched documents, next possible actions – ‘ Authorize’ , ‘ Return’, ‘ Delete’ buttons are enabled and other actions – ‘ Match’, ‘ Reverse’, ‘ Hold’ , ‘ Release’ are disabled For Authorized documents , next possible actions – ‘ Reverse’ , ‘ Hold’, ‘ Pay’ buttons are and enabled and other actions – ‘ Authorize’, ‘ Match’, ‘ Return’ , ‘ Delete’, ‘ Release’ are disabled. Page 7 of 67 Enhancement Notification Exhibit 3: User access right based display of tree and action buttons Scenario 3: When the user has activity access only for View Invoice and Hold / Release Invoice for all components.  Note: This feature involves commercials and is not available for all customers. Please contact your Ramco Account Manager. For a user having access only for View Invoice, and Hold / Release Invoice, all other action buttons have been disabled. Since only documents with held status are fetched, ‘ Hold’ button is also disabled and only ‘ Release’ button is enabled. Page 8 of 67 Enhancement Notification REVIEW FINANCIAL STATEMENTS – AN OVERVIEW Requirement to drill down to transactions from the financial Statements for analysis Reference: AHBF- 12189 Background  Financial Statements give broader view of the financial position of the company and it is always a requirement to perform an online review at any point in 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  Additionally, ability to drilldown from these financial statements to the transaction level for a detailed analysis and review is required.  Ability to perform adhoc analysis for an Account Code, at a cost center level or analysis code level etc., is required.  This enhancement explains the new Financial Statement Drilldown capability Change Details  A new activity Review Financial Statements is introduced under component Finance Book Processing to facilitate online review of financial statements i. e. Trial balance, Balance Sheet, Income Statement along with a feature to drill down till transaction level from this screen itself.  It caters to the need of generating reports for different periods dynamically along with the option of generating the report with or without ‘ Net Balances’ ( for Trial Balance).  In case of Balance Sheet and Income Statements this enhancement provides the feature of using pre/ user defined layouts.  Apart from review of different financial statements, it provides user the facility to perform adhoc querying with group by capability. A wide range of information is retrieved by providing a particular range of ‘ Account Codes’, ‘ Cost Center’ or combination of both. Drag and drop feature is introduced in this adhoc to enable ‘ Group By’. User can drag and drop a column to perform financial analysis. Page 9 of 67 Enhancement Notification Exhibit 1: Review Financial Statements screen Financial Statements This section depicts the different options available for the purpose of review: Trial Balance, Balance Sheet, Income Statement and Adhoc are available as buttons. Click of these buttons enables search criteria for each of the buttons as applicable. Income Statement ( MAC) will be disabled for the current release and will be enabled in future releases. Refer Exhibit 2. Exhibit 2: Options to choose different financial statements Trial Balance By default, on screen launch, Trial Balance report will be displayed in the multiline below, based on the default search criteria, which can be changed further. On click of ‘ Show Details’ the Trial Balance report will be displayed for the specified search criteria. Trial Balance can be extracted on any date by specifying the ‘ As On’ date in the ‘ Period Horizon’ drop- down list box. Financial Period end dates are additionally loaded for extracting trial balance on such period dates. Refer Exhibit 3 & 4. Page 10 of 67 Enhancement Notification Exhibit 3: Trial Balance Search criteria Exhibit 4: Trial Balance without Net balances in ‘ Annual’ format Additional Display Options in Trial Balance: Group by: User has been provided with the feature of trend analysis which can be done by fetching the trial balance for different periodicity with the help of ‘ Group by’ option. It facilitates generation of trial balance on annual, semiannual, quarterly and monthly basis Refer Exhibit 5, 6, 7 & 8 Net Balance: It provides the user with the option of analyzing the trial balance in two ways:- Net balance Unchecked: The trial balance will be displayed with ‘ Debit’ and ‘ Credit’ balances separately in two different columns Net balance Checked: The trial balance will be displayed showing ‘ Net balance’ of ( Debit - Credit) instead of showing ‘ Debit’ and ‘ Credit’ balances separately in two different columns. ‘ Debit’ balances will be displayed as positive figures and ‘ Credit’ balances will be displayed as negative figure. Refer Exhibit 9 Page 11 of 67 Enhancement Notification Exhibit 5: Additional display options Exhibit 6: Trial Balance with ‘ Semiannual’ option selected in ‘ Group by’ Exhibit 7: Trial Balance with ‘ Quarters’ option selected in ‘ Group by’ Option to display trial balance with or without net balances Trial balance showing data in ‘ Quarters’ format Trial balance showing data in ‘ Semi Annual’ format Option to show trial balance for different periodicity Page 12 of 67 Enhancement Notification Exhibit 8: Trial Balance with ‘ Months’ option selected in ‘ Group by’ Exhibit 9: Trial Balance with net balance Drill Down till the transaction Amounts will be displayed as a link against Account Codes in all the financial Statements above. By clicking the link, user can see the transaction listing screen with all the relevant transactions that made up that value, with all the Account Code level information like Cost Center, Analysis Code etc. Opening and closing balances will not be enabled with a link. Refer Exhibit 10 Exhibit 10: Amount link for Account Inquiry Trial balance with net balances Trial balance showing data in ‘ Months’ format Amount link in ‘ Movement’ column on click of it transaction listing pop- up will be displayed Page 13 of 67 Enhancement Notification Account inquiry within the same screen and transaction page On opening of Account Inquiry it will show all the relevant information for the given Account Code along with the ‘ Transaction No.’ as a data hyperlink on click of which the ‘ Transaction Page’ will be launched. Refer Exhibit 11 & 12 Exhibit 11: Account Inquiry information within the Review Financial Statement screen Exhibit 12: Transaction Page Transaction no. as data hyperlink on click of it transaction page will appear Transaction page will be displayed within the same screen on click of the ‘ Transaction no.’ Page 14 of 67 Enhancement Notification Balance Sheet This provides online reviewing of Balance Sheet. On click of ‘ Balance Sheet’ button search criteria for balance sheet will be displayed. On click of ‘ Show Details’ the user will get balance sheet in a tree format in the multiline at schedule levels based on the Balance Sheet ‘ Layout ID’ and other search criteria provided by the user. On further expanding schedules, it will show Account Codes mapped under it. Amount link against Account Code will be enabled; on click of it, account inquiry transaction listing will appear Additional search criteria for balance sheet has been disabled for this release. Refer Exhibit 13, 14 & 15 Exhibit 13: Balance Sheet search criteria Exhibit 14: Balance Sheet in tree format at Schedule level Balance Sheet at Schedules level Balance Sheet in tree form User/ Pre defined Balance sheet layout ID will be loaded here based on which balance sheet will be loaded in the multiline Option to search for all Schedules/ Groups or for a specific Schedules/ Groups Page 15 of 67 Enhancement Notification Exhibit 15: Balance Sheet displaying account codes and amount link Income Statement  This provides online review of Income statement in the application; on click of ‘ Income Statement’ button search criteria applicable for it will be displayed. On click of ‘ Show details’ Income Statement will be displayed in tree form in the multiline at schedule levels based on the Income Statement ‘ Layout ID’ and other search criteria provided by the user.  On further expanding schedules, it will show account codes mapped under it.  The ‘ Amount’ link against Account Code will be enabled, on click of it, Account Inquiry pop up will appear  Additional search criteria’s for Income Statement has been disabled for this release. Refer Exhibit 16, 17 & 18 Exhibit 16: Income Statement Search criteria On expanding of schedules account codes under it will be displayed Amount link against account code will be enabled on click of it account inquiry pop up will open as explained in Exhibit 11 Page 16 of 67 Enhancement Notification Exhibit 17: Income Statement at Schedule level Exhibit 18: Income Statement at Schedule level Adhoc Search  It provides the user the benefit of doing ‘ Adhoc’ querying. Feature of adhoc search is enabled where the user can retrieve wide range of information such as Fin Year, Finance book, Analysis Code, Sub Analysis Code, Amount etc. by providing a particular/ range of ‘ Account code’, ‘ Cost center’ or combination of both, or the user can retrieve information for all account codes at one go by giving a blank search. Refer Exhibit 19  Group by option in the multiline is a new feature which provides drag and drop facility through which the user can form a custom tree for his analysis. For example, if the cost centers and the data under it need to be analyzed, then cost center can be dragged and dropped in the ‘ Group By’ area. By Income Statement at Schedules level Income Statement in tree form On expanding of schedules account codes under it will be displayed Amount link against account code will be enabled on click of it account inquiry pop up will open as explained in exhibit 11 Page 17 of 67 Enhancement Notification doing this all the cost centers will form a tree in the multiline and by expanding it the relevant data pertaining to those cost centers can be viewed. Refer Exhibit 20 Exhibit 19: Adhoc search criteria Exhibit 20: Adhoc search results Option to Search for a particular ‘ Account code’ or range of ‘ Account codes’ Option to Search for a particular ‘ Cost center’ or range of ‘ Cost centers’ Search result showing various relevant information pertaining to the account code Page 18 of 67 Enhancement Notification Exhibit 21: Adhoc search results showing ‘ Group by’ feature Note: This feature involves commercials and is not available for all customers. Please contact your Ramco Account Manager. ‘ Group by’ area where column heading can be dropped to form a tree in the multiline, in this exhibit cost center and Analysis Desc. has been dropped to form a tree based on Cost Center and Analysis Desc under it Custom tree based on cost centers. On expanding it Analysis Desc. will be displayed below as they both have been dropped in the ‘ Group by’ zone to form a tree Amount link against Account Code will be enabled; on click of it Account Inquiry will appear within the same screen as explained in Exhibit 11 Page 19 of 67 Enhancement Notification WHAT’S NEW IN JOURNAL VOUCHER? Ability to record Inter Company Journal Entries Reference: AHBF- 12031 Background Balance transfers can happen during month / year ends between accounts of group companies managed by the same Finance / Accounts team for various reasons, like for example some common expenses incurred that are transferred from one group company to another requires journal entries are to be recorded both in the Source Company and Destination Company ( or) the Target Company manually. Provision to automatically post this responding journal entry in the Destination company should be enabled. Change Details A new voucher type ‘ Inter Company’ is introduced in Journal Vouchers Refer Exhibit 1. For the voucher type ‘ Inter Company’, the Destination Finance Book column in the multiline will be enabled with all the finance books from the group Companies ( group Company: all companies viz. Parent / Child / Peers to a Company).  To create an ‘ Inter Company’ Journal Voucher, specify the account code( s) ( of the source Company) from which balance is transferred and specify the ‘ Destination Finance Book’, ‘ Destination Account Code’ etc., of the company to which the balance is to be transferred in another line.  On authorization of the Inter Company Journal Voucher, an automatic journal entry in Authorized status is generated in the Destination Finance Book( s).  The currency of the Destination Account Code field can be same as the transaction currency or base currency of the Destination Finance Book’s Company. Page 20 of 67 Enhancement Notification Exhibit 1: New Voucher Type in Journal Voucher New Voucher Type “ Inter Company” is added Finance Book & Account Code of Group Company Page 21 of 67 Enhancement Notification WHAT’S NEW IN SUPPLIER DIRECT INVOICE? Ability to transfer expenses from one company to another Reference: AHBF- 12103 Background Supplier expense bills recorded in a company might be of common expenses for the group companies. For example, when rental expenses are recorded, it could belong to all the companies in the group situated in the same building. Later it should be allocated to the respective Companies. Provision to allocate the expenses to the respective companies while the expense bills are being recorded is enabled. Change Details ‘ Destination Finance Book’ column in the ‘ Expense Invoice’ multiline is to be enabled with all the finance books from the group Companies. Refer Exhibit 1.  To create an ‘ Inter Company’ Expense Invoice, specify the ‘ Destination Finance Book’ and the ‘ Destination Usage ID’ ( Expense account of the destination company).  On authorization of the Expense Invoice, an automatic journal entry in ‘ Authorized’ status is generated in the Destination Finance Books to the extent of the expense transferred.  Destination Usage ID ( Account Code’s currency) can be same as the Expense Invoice currency or base Currency of the Destination Finance Book’s Company.  TCDs added to the Inter Company Expense Invoice will be accounted in the Source Company only when the Option ‘ Statutory Tax Computation and Accounting” is set as “ Required’ in the Company Parameter Setup. Page 22 of 67 Enhancement Notification Exhibit 1: Inter Company Supplier Expense Invoice Finance Book & Usage ID of Group Company Page 23 of 67 Enhancement Notification WHAT’S NEW IN INTER BANK TRANSFER? Requirement to transfer funds from one company to another Reference: AHBF- 12115 Background Fund transfers might happen between banks of the group companies. Fund transfer payment is to be recorded for the bank of the source company and the fund transfer receipt is to be recorded for the Destination Company’s bank. Provision to automate the receipt transaction in the Destination Companies bank is to be enabled when transfers are between the group companies. Change Details Sundry Payment Voucher – Inter Bank Transfer has been enhanced to automate the Receipt in the target Company. Transferee FB will be enabled with all Finance Books of the group Companies and the Transferee Bank Code to display the bank codes from the transferee Company. Two new controls ‘ Pay to Transferee Bank Exch. Rate’ – for the exchange rate between the Pay Currency and the Transferee Bank exchange rate and ‘ Receipt Amt. ( Receipt Bank Curr.)’ – to display the Receipt Amount in the transferee Bank’s currency.  To create an Inter- bank fund transfer across companies, choose the finance book of the group company in the Transferee FB drop- down list box and choose the Bank Code to which the fund is to be transferred.  The exchange rate between the Pay Currency and the Transferee Bank currency is arrived and displayed based on which the Receipt amount is computed.  On releasing the payment, Sundry Receipt voucher for the Transferee Bank Code will be generated in ‘ Authorized’ status in the Transferee Company. Page 24 of 67 Enhancement Notification Exhibit 1: Create Inter Bank Transfer Finance Books of Group Companies New control: Exchange Rate - Pay Currency to Transferee Bank Codes of the transferee FB New control: Receipt Amount to display the receipt Amount for the Transferee Bank Page 25 of 67 Enhancement Notification PRE- REQUISITES FOR THE ABOVE FEATURES Definition of Account Code for Inter Company transactions Background Account Codes between Source Company and the Destination Company and vice versa have to be defined to perform the above Inter FB transaction across companies. Provision is to be made to define these account codes. Change Details New Pre- defined Usages “ INTERCOMP- GEN” ( for Inter Company Journal Vouchers and Inter Company Supplier Expense Invoices) and “ INTERCOMP- FUNDS” ( for Inter Company fund transfers) have been introduced. Additional Account Definition has been enhanced to enable definition for the above pre- defined usages.  To define Account Code for the above Pre- defined Usages, select the Finance Book of the Source Company in the header and the Destination Finance Book, Destination Company in the multiline and specify the Account Code.  This Account Code should be in the Base Currency of the login Company. Exhibit 1: Create Additional Account Definition Page 26 of 67 Enhancement Notification Option to be set for enabling this feature: Background To enable Inter Company Transactions in the Journal Voucher, Supplier Expense Invoice and Sundry Payment Voucher, an option has to be set in the Set Finance Process Parameters page. Change Details New Options are introduced in the Set Finance Process Parameters:  Allow Inter Company transactions in Journal Voucher: Set this option as “ 1” ( Yes), to enable Inter Company Transactions in Journal Vouchers  Allow Inter Company transactions in Supplier Direct Invoice Set this option as “ 1” ( Yes), to enable Inter Company Transactions in Supplier Expense Invoice  Allow Inter Company transactions in Sundry Payment Set this option as “ 1” ( Yes), to enable Inter Company Transactions in Sundry Payment Vouchers Exhibit 1: Set Options introduced Note that in addition to this option, CIM interaction needs to be enabled between the Source Company Organization Unit and the Destination Company Organization Unit between:  Journal Voucher - Journal Voucher of the Source and the Journal voucher of Destination Page 27 of 67 Enhancement Notification  Supplier Expense Invoice - Supplier Direct Invoice of the Source & the Journal Voucher of the Destination  Sundry Payment - Sundry Payment Voucher of Source and Sundry Receipt Voucher of the Destination.  Note: The ARI report on ' Elimination for Consolidation' will not list the Inter Company Transactions generated through Journal Vouchers, Supplier Expense Invoices and Sundry Payment. Voiding of the inter- bank transfer in the ‘ transferor company’ will not auto reverse the sundry receipt in the ‘ transferee company’. It has to be done manually. Page 28 of 67 Enhancement Notification W H A T ’ S N E W I N L A B O R C O S T I N G ? R e q u i r e m e n t t o m a i n t a i n a n d u s e d i f f e r e n t i a l r a t e s f o r L a b o r C o s t i n g Reference – AHBF- 13064 Background Labor Cost today is a full burden rate and is a standard for Job Code/ Skill Code. In order to compute Labor Cost based on Employee Base Rate from HR and Additional Overhead Costs and to define Overhead Rates that are varying within a department other than Standard Overhead Rates, differential Job Rating is needed. Also, maintenance of correct cost information for Labor ( with break- up of actual cost and Burden Rate) is required for Government Audit purpose. Change Details  A new set option to set the Base Rate is introduced in the Account Group Component ( Exhibit 1)  Similarly a new screen’ Maintain Overhead Rates for Labor Costing’ is introduced in the Account Group Component ( Exhibit 2)  A new entity ‘ Labor Costing overhead Type’ is introduced in the Quick Code Master ( Exhibit 3). Exhibit 1: Set Option for Base Rate in Account Group Component Set Options introduced for Base Rate and Overhead% applicability. Page 29 of 67 Enhancement Notification Exhibit 2: Maintain Overhead Rates for Labor Costing Exhibit 3: New Entity Labor Costing Overhead Type in Quick Code Screen New Screen designed for defining Labor Rates Quick Codes defined under the Entity ‘ Labor Costing Overhead Type’ Page 30 of 67 Enhancement Notification Set Options introduced in Account Group Component:  Base Rate for Labor Costing Based On Option setting is introduced to define the Base Rate for Labor Cost Computation, with values ‘ Standard Job/ Skill Rate’ ( existing behavior) and ‘ Base Rate from HRMS’ is newly implemented. The Common Labor Cost Computation logic is enhanced to compute Labor rate based on this option. If the Option is Base Rate from HRMS, the Base Rate of an Employee who is booking timesheet should be derived from the HRMS Base Rate.  Overhead% Applicability on Base Rate Additional Option for applicability of Overhead % on top of Base Rate is introduced. Overhead % definition can be enabled at a Department Level or a Cost Center Level Maintain Labor Rates for Job Costing:  A new screen Maintain Overhead Rates for Labor Costing to capture the Overhead Percentages applicable for each Department or Cost Center is introduced with an effectivity date.  The Common Labor Cost Computation logic is enhanced to consider the Overhead % defined in the new screen for the Employee's Department or Employee's Cost Center.  Note: When Timesheet is booked by an employee, for accounting the cost, his base rate should be derived from HRMS, and the Overhead % is to be applied based on his Department.  If the Overhead basis is Cost Center, first the Cost Center associated to the Employee is to be considered. if there is no Cost Center at that level, then the Cost Center should be derived from the Department of the Employee. The % defined for the said Cost Center is to be used for arriving at the Overhead rate. Example 1 – Transaction with Additional Overheads Base Rate for Employee 100$/ hr Department OH % 15% Company OH % 10% Total Labor Cost 125$/ hr  Note: In the above example the Additional Overheads% will be applied on Base Rate. The Overhead % will never be computed on compounded value. Page 31 of 67 Enhancement Notification Labor Costing Entity in Quick Code screen:  A new entity ‘ Labor Costing Overhead Type’ introduced in Quick Codes.  The Value defined in the Quick Code screen will get loaded in the Overhead Type combo of Maintain Labor Rates for Job Costing. Page 32 of 67 Enhancement Notification WHAT’S NEW IN THE TAXATION FRAMEWORK? Ability to Manage Recipient Liable Taxes in US Sales Tax Reference: AHBF- 13345 Background When a buyer procures items from another state and when the seller from the other state does not have nexus with the buyer’s state, the buyer may be assessed for the “ Use Tax” of such sale. The buyer is liable for such tax. Therefore, a provision to account for the use tax is enabled. Change Details  New Tax Type: ‘ US Sales Tax’ is introduced, if the Country of the Company is United States. ( Refer Exhibit 1)  Applicability ‘ Purchase’ and ‘ Sales’ is applicable for the tax type: US Sales Tax.  Tax Incidence ‘ On Invoicing’ is enabled.  New Tax Nature: ‘ Recipient – Expense’ is introduced to manage the use tax scenario, in addition to Tax Nature “ Payable”.  Note: Tax Attributes are applicable only if the option: ‘ Statutory Tax Computation and Accounting Required’ under Company Parameter setup is set as “ Yes”. Page 33 of 67 Enhancement Notification Exhibit 1: Tax Attributes in the Specify Tax Attributes screen New Tax Type: “ US Sales Tax” New Tax Nature: “ Recipient- Expense” Page 34 of 67 Enhancement Notification WHAT’S NEW IN SUPPLIER INVOICING? Ability to manage accounting for Recipient Tax Reference: AHBF- 12115 Background Provision is made to account for Tax when the buyer is liable for the sales tax while recording Supplier Invoice. Change Details Supplier Order Based Invoice, Supplier Direct Invoice and Supplier Debit/ Credit Notes are enhanced to enable accounting for the Recipient Liable Taxes. For the recipient liable taxes added in the Invoice, the tax portion is not liable to be paid to the supplier and the same will be accounted to the TCD Account Code itself. The Tax amount will be debited to the Account Code mapped in the ‘ TCD Account Definition’ available in the Create Payable Account Definition page, which can be mapped to an Expense/ Revenue Account. The tax amount will be credited to the Account Code mapped in the ‘ TCD Account Definition’ available in the Create Receivables Account Definition page. The table below depicts the accounting entries for the Recipient – Expense TCDs added in Invoices and Notes. Document Accounting entry Supplier Order Based Invoice with 10% Sales Tax Debit: Supplier Suspense Account 100 Credit: Supplier Control Account 100 Debit: Sales Tax ( Purchase) 10 Credit: Sales Tax ( Sales) 10 Supplier Direct Invoice with 10% Sales Tax Debit: Usage ID - Account 100 Credit: Supplier Control Account 100 Debit: Sales Tax ( Purchase) 10 Credit: Sales Tax ( Sales) 10 Supplier Item Based Note with 10% Sales Tax Debit: Supplier Control Account 100 Credit: Usage ID - Account 100 Debit: Sales Tax ( Sales) 10 Credit: Sales Tax ( Purchase) 10 Page 35 of 67 Enhancement Notification WHAT’S NEW IN SUPPLIER INVOICING Requirement to post the differences to Rounding off Account Reference – AHBF- 11177 Background When recording Supplier Invoices, there may be minor differences arising between the Supplier Invoice Amount ( as per physical Invoice) and Total Invoice Amount ( as computed in the Invoicing screen) due to rounding off ( Refer Example 1). These differences are adjusted manually by addition a Discount/ Charge mapped to a Rounding off Account as the case may be. Provision should be provided to post such differences automatically to these discount/ charge, if the same is within the tolerance. Example 1 – Transaction with Tax Basic Value of the Invoice $ 18,517.34 VAT @ 25% $ 4,629.34 Supplier Invoice Amount $ 23,146.50 Total Invoice Amount $ 23,146.68  Note: In order to record the above Invoice, a discount TCD is to be added to the tune of $ 0.18 to match the invoice amount with the Supplier Invoice amount. Change Details A new set option for capturing the rounding off tolerance and the default discount and charge TCD for Supplier Direct Invoice ( Exhibit 1) and Supplier Order Based Invoice ( Exhibit 2) has been introduced in Set Finance Process Parameters page under ‘ OU Parameter Setup’ business component. If Supplier Invoice Amount is greater than the Invoice amount, and the difference is within the Tolerance, rounding off difference will be posted to Charge TCD. If Supplier Invoice Amount is less than the invoice amount, and the difference is within the Tolerance, rounding off difference will get posted to Discount TCD. Page 36 of 67 Enhancement Notification Exhibit 1 Set Finance Process Parameters - Supplier Expense Invoice Exhibit 2 Set Finance Process Parameters for Supplier Order Based Invoice Set Options introduced in Set Finance Process Parameters screen:  Rounding Off: Range for the difference between Supplier Invoice Amount and Total Invoice Amount This is the range within which the difference between the Supplier Invoice Amount and the Total Invoice Amount will be allowed. A Discount/ Charge ( which is set in the subsequent options) will be automatically added for the difference during Authorization. The range entered should be a positive numeric value. For Example: If the tolerance given is 1 Supplier Invoice Amount 1000.00 Total Invoice Amount 1000.05 Note: For the tolerance of ‘ 1’, a range of + 1 to - 1 will be considered for rounding off. In this case, the difference is 0.05, which is within the Tolerance, a default Discount TCD will be added to the Invoice during Authorization. Set Options introduced in ‘ Set Finance Process Parameters’ screen Set Options introduced in Set Finance Process Parameters Page 37 of 67 Enhancement Notification  Rounding Off: Default Charge Code for Positive Difference ( Supplier Invoice Amount > Total Invoice Amount) This option is for defining the Charge TCD and Variant in case of positive difference ( when Supplier Invoice Amount is greater than Total Invoice Amount). The TCD Code must be of type ‘ Charge’ and the basis must be ‘ Flat’.  Rounding Off: Default Discount Code for Negative Difference ( Total Invoice Amount > Supplier Invoice Amount) This option is for defining the Discount TCD and the Variant in case of negative difference ( when Total Invoice Amount is greater than Supplier Invoice Amount). The TCD Code must be of type ‘ Discount’ and the basis must be ‘ Flat’.  Rounding Off: Default Cost Center for Charge/ Discount Code The Default Cost Center to which the Charge/ Discount will be accounted in the Invoice. Page 38 of 67 Enhancement Notification W H A T ’ S N E W I N R E P O R T S - R E C E I V A B L E S M A N A G E M E N T ? C u s t o m e r O r d e r P r o f i t a b i l i t y R e p o r t Reference: AHBC- 1677 Background This report provides the profitability at each Customer Order level in addition to the ability to review cost at a Work Order task level. Parts and resources utilized against each task can be further analyzed in order to review the cost booked against a customer job. Based on the level at which the details are required, revenue or cost can be extracted either at summary, detailed or entity level cost. Change Details A new screen has been introduced to fetch a report with Customer Order and its revenue and cost details. Report Output Report output can be divided into following details:  Summary Level: The summarized information of each of the Customer Order would be available with details of the contract, revenue, cost, profit, margin, and execution and billing status and break up of revenue and cost into materials, labour, other resources and external services.  Detailed: This report type gives information about the Profitability at each task level for a Customer Order. It displays total revenue earned, cost incurred and margin against each task.  Entity Level Cost: This report type gives information about the cost incurred at each entity for a task. It displays material cost of the Part # used, quantity, rate, skill, other resource cost along with the number of hours booked and the rate. Page 39 of 67 Enhancement Notification Exhibit 1: Input Screen Exhibit 2: Report Output - Summary Exhibit 3: Report Output – Detailed Page 40 of 67 Enhancement Notification Exhibit 4: Report Output – Entity Level Page 41 of 67 Enhancement Notification WHAT’S NEW IN REPORTS- PAYABLES MANAGEMENT? Three Way Analysis Report Reference: AHBC- 1651 Background This report provides a consolidated view of Purchase Order, Goods Receipt and Order Based Invoice. The order to cash cycle against each purchase order is displayed with details for analysis and reporting purposes. Change Details A new screen has been introduced to fetch a new excel report with Purchase Order along with its Goods Receipts and Invoice and Payment Information. Report Output Report output is explained as follows:  Purchase Order Details: Line level detail for a given purchase order will be available with the information like PO Line #, Part #, Part Description, Quantity, Unit Price and Value.  Goods Receipt Details: All the Goods Receipts ( GR) created for a purchase order will be displayed in the report with the information like GR #, GR Date, GR Receipt Qty, GR Moved Qty, Back Order Qty, GR Rejection Qty, GR Receipt Value and GR Moved Value.  Supplier Invoice Details: All Invoices recorded for PO- GR will be displayed in the report with the information like Supplier Invoice #, Supplier Invoice Date and Invoice Value.  Payment Information: Latest payment information for the corresponding invoice will be displayed in the report. Page 42 of 67 Enhancement Notification Exhibit 1: Input Screen Exhibit 2: Report Output Page 43 of 67 Enhancement Notification WHAT’S NEW IN REPORTS? Report on Work Orders with Part Shipped but not closed Reference: AHBC- 1680 Background This report provides a list of all Customer Work Orders, for which part has been shipped to the customer but the work order has not been closed. For instance, this report lists the work orders for which repair/ overhaul has been completed on the part and main core part has been shipped to customer, but the work order has not been closed. This report helps in identifying such work orders for which job is completed but cost is not booked yet. Change Details A new Dcube report has been introduced to fetch all the work orders wherein the part has been shipped to the customer but work order has not been closed. Report Output Based on the date on which report is launched, a list of all the Shop Work Orders with reference to Customer Order for which main core part has been shipped to customer, but work orders have not been closed will be listed. Report will include details like Shop Work Order #, Customer #, Customer Name, Part #, Shipment Date, Closed Date and so on. ( Refer Exhibit 1 for sample output). Exhibit 1: Report Output Page 44 of 67 Enhancement Notification WHAT’S NEW IN CUSTOMER AGEING? Requirement to Compute Ageing for Credit Documents Reference – AHBF- 9969 Background In Customer Ageing Analysis report, credit documents like Customer Prepayment Invoices / Credit Notes etc., are not generally aged since there are no pay terms or due dates attached to it. Currently, these documents find place in the current bucket of the ageing reports as a negative value. The requirement is to compute age for these credit documents based on the reference documents for which these credit documents are created or based on the pay term of the customer. Change Details  A new set option ‘ Display ageing of Credit documents in Customer Ageing Report’ is introduced in Set Finance Process Parameters page in OU Parameters Setup for enabling the ageing for Credit Documents. ( Exhibit 1)  If this option is set as ‘ Yes’, credit documents are aged based on its respective reference documents and are displayed in the appropriate ageing bucket similar to that of its reference documents as negative value. ( Exhibit 2)  In case the credit documents does not have reference to any debit document, the ageing will be calculated based on the pay term associated to that Customer in Customer master.  If this option is set as ‘ No’, the credit documents will be displayed in the current bucket as a negative value ( existing functionality). Exhibit 1: Set Option for Customer Ageing Set Option introduced in Set Finance Process Parameters for Customer Ageing Page 45 of 67 Enhancement Notification Exhibit 2: Credit Documents Displayed in Customer Ageing Analysis Report R e q u i r e m e n t t o C o m p u t e A g e i n g b a s e d o n A d d i t i o n a l C a t e g o r i e s a n d A t t r i b u t e s a n d I n v o i c e d a t e Reference – AHBF- 9969 Background Ability to compute ageing based on the invoice date ( document date) instead of due date and classify invoices in appropriate bucket is required as an additional option for ageing for analysis purposes. In addition, more flexibility of Customer Ageing based on Additional Categories, Attributes and contact categories of the Customer master is required for various purposes. The Customer Ageing Analysis Report screen currently does not have the required search options. This screen has been enhanced in order to extract report with the above options. Credit Documents displayed in Ageing Bucket. Page 46 of 67 Enhancement Notification Change Details  The following controls have been added in the Customer Ageing Analysis Report page for the Display Currency option “ Tran and Base Currency”. ( Exhibit 3) • Age Based on • Additional Attributes • Addl. Search by  The Age Based on combo will be loaded with ‘ Invoice Date’ and ‘ Due date’ and defaulted with Due Date. If “ Due date” is selected in the search option, the ageing will be computed as per the due dates derived based on anchor dates of the respective documents ( existing functionality). If “ Invoice date” is selected, the ageing will be computed based on the respective document date ( new functionality). E. g. If an Invoice date is 1- Oct- 15 and the ageing report is extracted on 15- Oct- 15, it will be appearing in 0- 30 bucket in ageing.  The Additional Attributes combo will be loaded from the values defined for the additional categories ( 1st combo), additional attribute ( 2nd combo) and its value ( 3rd combo) in the Customer master  Edit Customer Additional Information screen.  Customers can be classified based on these additional attributes selected in the customer master. These additional attributes are given as a search criteria for ageing report. Based on the search criteria values selected for these controls, ageing report will be generated for those customer which are classified with the selected attributes.  In addition, Addl. Search by combo will be loaded with Contact category ( 1st combo) as a search option, which will have the list of contact categories such as CSR and other user defined contact categories ( 2nd combo) and the contact persons ( 3rd combo) will be loaded in the third combo.  Customers can be identified with the various internal contact persons for various roles in Customer master. Customer master contains this contact information with CSR ( Customer Service Representative) as a preloaded contact category against which the employee name ( the Contact persons) can be assigned.  Ageing can be extracted based the contact categories. The Customer Ageing Analysis Report ( Tran and Base – Summary and Detailed Report) is enhanced to display the Additional Columns – Additional Attributes and Contact Category if selected in the search option. ( Exhibit 4) Page 47 of 67 Enhancement Notification Exhibit 3: Customer Ageing Analysis Report Page with Additional Attributes Exhibit 4: Customer Ageing Analysis Report with additional attributes Additional Attributes introduced for Customer Ageing Two Additional Columns displayed in Ageing. Page 48 of 67 Enhancement Notification Requirement to have Additional visibility to Display Totals Reference – AHBF- 9969 Background The requirement to give visibility to currency information in the sub totals and grand totals in the Customer Ageing Report. Change Details  The transaction Currency is displayed at the header level in both the Summary and Detailed Customer Ageing Reports. The changes are done for the report types namely Tran Currency, Base Currency. The totals in the report will have visibility to currency information. ( Exhibits 5 to 7) Exhibit 5: Customer Ageing Summary Report – Transaction Currency Transaction Currency displayed in header Displayed as Total of TRADE in CAD. Page 49 of 67 Enhancement Notification Exhibit 6: Customer Ageing Summary Report – Base Currency Exhibit 7: Customer Ageing Summary and Detailed Report – Tran and Base Currency Display of Base Currency Display of Base Currency Displayed as Total of TRADE in CAD. Page 50 of 67 Enhancement Notification W H A T ’ S N E W I N S U P P L I E R A G E I N G ? R e q u i r e m e n t t o C o m p u t e A g e i n g f o r D e b i t D o c u m e n t s Reference – AHBF- 11504 Background In Supplier Ageing Analysis report, debit documents like Prepayment Vouchers / Debit Notes etc., are not generally aged since there are no pay terms or due dates attached to it. Currently, these documents find place in the current bucket of the Ageing Report as a negative value. The requirement is to compute age for these debit documents based on the pay term of the Supplier or based on the reference documents for which the debit documents are created or Change Details  A new set option “ Display ageing of debit documents in Supplier Ageing Report” is introduced in Set Finance Process Parameters page in OU Parameters Setup for enabling the ageing for Debit Documents. ( Exhibit 1)  If this option is set as ‘ Yes’, debit documents are aged based on its respective reference documents and are displayed in the appropriate ageing bucket similar to that of its reference documents as negative value. ( Exhibit 2)  In case the debit documents do not have reference to any credit document, the ageing will be calculated based on the pay term associated to that Supplier in Supplier master.  If this option is set as ‘ No’, the debit documents will be displayed in the current bucket as a negative value ( existing functionality). Exhibit 1: Set Option Introduced for Supplier Ageing Set Option introduced for Supplier Ageing Page 51 of 67 Enhancement Notification Exhibit 2: Debit documents displayed in Supplier Ageing Report R e q u i r e m e n t t o h a v e A d d i t i o n a l v i s i b i l i t y t o d i s p l a y T o t a l s Reference - AHBF- 9969 Background Requirement to give visibility to currency information in the sub totals and grand totals in Supplier Ageing Report. Change Details The transaction Currency is displayed at the header level in both the Summary and Detailed Supplier Ageing Reports. The changes are done for the report types namely Tran Currency, Base Currency. The totals in the report will have visibility to currency information. ( Exhibits 3 to 6) Debit Documents getting displayed in Ageing. Page 52 of 67 Enhancement Notification Exhibit 3: Supplier Ageing Detailed Report – Transaction Currency. Exhibit 4: Supplier Ageing Summary Report – Transaction Currency. Transaction Currency displayed in Header Displayed as Grand Total of TRADE in USD. Transaction Currency displayed in Header Displayed as Grand Total of INTERCO in CAD. Page 53 of 67 Enhancement Notification Exhibit 5: Supplier Ageing Summary Report – Base Currency. Exhibit 6: Supplier Ageing Summary and Detailed Report – Tansaction and Base Currency. Base Currency displayed in header Base Currency displayed in header Grand Total of INTERCO in CAD Page 54 of 67 Enhancement Notification WHAT’S NEW IN EDK- REPORTS RECEIVABLES MANAGEMENT? Ability to generate Customer Remittance Advice report with Reporting Currency Reference: AHBF- 11680 Background The Customer Remittance Advice Report represents the amount due from the Customer, with a listing of Invoices and Notes of that customer. Invoices might have been raised in various currencies for a customer. But the customer might request for a due amount in terms of a single currency which they prefer. The current Remittance Advice Report does not depict the amount due in single currency. This enhancement enables the user to extract such report in the chosen currency. Change Details The ‘ Currency’ field in the Search Criteria of the Customer Remittance Advice Report in the EDK Reports – Receivables Management business component enables retrieval of invoices in the transaction currency, hence has been renamed as ‘ Transaction Currency’. Now, in addition to the above, users can specify a currency for displaying the balances of retrieved invoices in the report. To achieve this, the ‘ Reporting Currency’ field has been added in Search Criteria. Exhibit 1: Enhanced Customer Remittance Advice Note screen  Note: Ensure that Exchange Rate is defined for Transaction Currency and Reporting Currency combination at the time of printing Report. Currency field is renamed as Transaction Reporting currency field is newly added Page 55 of 67 Enhancement Notification If Remittance Advice Statement is generated with Reporting Currency selected, the report will have new reporting structure as follows: 1) New column Doc. Currency that displays the currency used in respective document/ transaction, 2) New column Balance in Doc. Currency explicitly displays the debit credit balance amount in respective document currency, 3) New column Exchange Rate to display the exchange rate for conversion of document/ transaction currency to reporting currency, and 4) New Column Balance in Reporting Currency to explicitly displays the debit credit balance amount in respective reporting currency chosen by user. Page 56 of 67 Enhancement Notification Exhibit 2: New report structure of Customer Remittance Advice Statement Exhibit 3: Existing report format of Customer Remittance Advice Statement Page 57 of 67 Enhancement Notification Existing Remittance Advice Report: ( this report will be launched if reporting currency is not selected Page 58 of 67 Enhancement Notification WHAT’S NEW IN REPORTS- RECEIVABLES MANAGEMENT? New Report to View Customer Balance Adjustments Reference: AHBC- 1652 Background This report provides details of adjustments made through Customer Balance Adjustments. It provides the complete settlement detail of a customer document with the corresponding debit or credit document. Change Details A new screen has been introduced to fetch the adjustments made between different documents against a customer. Report Output The below- mentioned two different report outputs will be available based on input criteria in Report Type. 1. Invoice: Report output will give the list of debit documents like Customer Invoice, Customer Debit Notes and its corresponding adjustment information. Adjustment information will include credit document against which such debit documents are adjusted along with the adjustment voucher number. 2. Receipt: Report output will give the list of credit documents like Customer Receipts, Customer Credit Notes and its corresponding adjustment information. Adjustment information will include debit document against which such credit documents are adjusted along with adjustment voucher number. Page 59 of 67 Enhancement Notification Exhibit 1: Input screen On click of ‘ View Customer Balance Adjustment’ pushbutton, report will be launched. Based on selection of ‘ Report Type’ in input screen two different reports can be launched. Exhibit 2: Report Output – Invoice Report Type will be loaded with Invoice and Receipt Page 60 of 67 Enhancement Notification Exhibit 3: Report Output – Receipt Page 61 of 67 Enhancement Notification WHAT’S NEW IN REPORTS- BOOK KEEPING? Account Distribution Report – By Account Code Reference: AHBC- 1221 Background This report provides all the account postings for the given search criteria. Details of all transactions pertaining to an Account Code along with multiple chart field details and part details if available are displayed against the transaction. Change Details A new screen has been introduced to fetch the accounting along with information on Cost Centers, Analysis Codes, and Supplier/ Customer Details. Report Output Two reports will be available which will give account postings for selected search criteria.  Summary: This report will give account postings for the given period and Account Code and amounts will be grouped based on Cost Center, Analysis Code, Sub Analysis Code and Customer/ Supplier. This report will not provide information at each transaction level.  Detail: This report will give all the account postings for the Account Code for the given period. There will be no grouping unlike Summary Report. Information will be available at each transaction level with information like Cost Center, Analysis Code, and Sub- analysis Code. Additional information will be available in Detail Report like Part #, Part Description, UOM, Quantity and Rate. This additional information will be displayed only if the transaction involves any Part and is available in the account postings. Page 62 of 67 Enhancement Notification Exhibit 1: Input screen Exhibit 2: Report Summary Page 63 of 67 Enhancement Notification Exhibit 3: Report Detailed Page 64 of 67 Enhancement Notification WHAT’S NEW IN REPORTS - RECEIVABLES MANAGEMENT? Enhancements in Customer Statement Report to display additional information Reference: AHBF- 11670 Background The requirement was raised in Customer Statement reports to display additional information like transaction- level remarks and currency information in the Balance Amount Grand total for ease of reference. Change Details Customer Statement Report of the Reports – Receivables Management business component has been enhanced as follows: 1) New transaction level Remark field is introduced 2) ‘ Grand Total in ( Currency)’ field is introduced to display Grand Total of Credit and Debit amounts of transactions. 3) Rephrased existing field ‘ Balance Due From / To Customer’ to display with respective currency wordings as ‘ Balance Due From / To Customer in CAD / USD / etc. Page 65 of 67 Enhancement Notification Exhibit 1: Enhanced Customer Statement Report displaying additional information  Note: Auto- replenishment initiated while modifying Minimum Qty./ Reorder Qty. in Warehouse Planning Parameter screen will also default stock status based on above process parameter.  Note: Currency Name displayed in above highlighted fields will consider Currency chosen by user during Customer Statement report generation in Customer Statement screen. The system considers Base Currency of the company if user had selected Currency as ‘ All’ during report generation. New column New label Rephrased field to display respective currency name Page 66 of 67 © Copyright 2015, 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