Time Tracker 28th March 2013 Ramco Aviation Solution Version 5.7.5 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 WHAT’S NEW IN TAXATION FRAMEWORK........................................................................................................ 6 INTRODUCTION TO MALAYSIAN GST............................................................................................................................ . 6 WHAT’S NEW IN MAINTAIN IDENTIFICATION DETAILS? ............................................................................. 7 REQUIREMENT TO DISPLAY BRN / GST ID NUMBER...................................................................................................... 7 Background..................................................................................................................... ......................................... 7 Change Details ............................................................................................................................... ......................... 7 WHAT’S NEW IN SUPPLIER MANAGE ADDITIONAL OPTIONS? ................................................................. 11 REQUIREMENT TO CAPTURE ADDITIONAL INFORMATION .............................................................................................. 11 Background..................................................................................................................... ....................................... 11 Change Details ............................................................................................................................... ....................... 11 WHAT’S NEW IN TAX ATTRIBUTES?................................................................................................................... 14 REQUIREMENT TO DEFINE MALAYSIAN TAXES ............................................................................................................. 14 Background..................................................................................................................... ....................................... 14 Change Details ............................................................................................................................... ....................... 14 WHAT’S NEW IN SUPPLIER ORDER BASED INVOICE? .................................................................................. 17 REQUIREMENT TO RETRIEVE ORDER LEVEL TCD INFORMATION DETAILS ...................................................................... 17 Background..................................................................................................................... ....................................... 17 Change Details ............................................................................................................................... ....................... 17 WHAT’S NEW IN CUSTOMER DIRECT INVOICE?............................................................................................ 21 REQUIREMENT TO GENERATE TAX ADJUSTMENT JOURNALS ......................................................................................... 21 Background..................................................................................................................... ....................................... 21 Change Details ............................................................................................................................... ....................... 21 WHAT’S NEW IN CUSTOMER INVOICE .............................................................................................................. 23 REQUIREMENT TO GENERATE TAX ADJUSTMENT JOURNALS ......................................................................................... 23 Background..................................................................................................................... ....................................... 23 Change Details ............................................................................................................................... ....................... 23 WHAT’S NEW IN JOURNAL VOUCHER?............................................................................................................. 25 REQUIREMENT TO CREATE TAX ADJUSTMENT JOURNALS MANUALLY............................................................................ 25 Background..................................................................................................................... ....................................... 25 Change Details ............................................................................................................................... ....................... 25 WHAT’S NEW IN BOOK KEEPING? ...................................................................................................................... 29 ENHANCEMENT TO MANAGE TAX INVOICE WINDOW AND TO PASS ADJUSTMENT ENTRIES ............................................. 29 Background..................................................................................................................... ....................................... 29 Change Details ............................................................................................................................... ....................... 29 WHAT’S NEW IN REPORTS - BOOK KEEPING? ................................................................................................ 33 ENHANCEMENT TO REPORT ON TAX TRANSACTIONS - COUNTRY SPECIFIC.................................................................... 33 Background..................................................................................................................... ....................................... 33 Change Details ............................................................................................................................... ....................... 33 WHAT’S NEW IN SUPPLIER DIRECT INVOICES & DEBIT / CREDIT NOTES?........................................... 37 ABILITY TO INHERIT TAXES FROM PURCHASE TAX RULES ............................................................................................. 37 Background..................................................................................................................... ....................................... 37 Change Details ............................................................................................................................... ....................... 37 WHAT’S NEW IN CHECK PAYMENT?.................................................................................................................. 41 ABILITY MANAGE PAYEE NAME........................................................................................................................... ....... 41 Background..................................................................................................................... ....................................... 41 WHAT’S NEW IN SUPPLIER MASTER?................................................................................................................ 42 REQUIREMENT TO CAPTURE ALTERNATE NAME FOR CHECK PRINT................................................................................. 42 Change Details ............................................................................................................................... ....................... 42 WHAT’S NEW IN SUPPLIER PREPAYMENT VOUCHERS?.............................................................................. 45 REQUIREMENT TO CAPTURE A DIFFERENT PAYEE NAME DURING PAYMENT PROCESSING – PREPAYMENT VOUCHER ...... 45 Change Details ............................................................................................................................... ....................... 45 WHAT’S NEW IN SUPPLIER PAY VOUCHERS? ................................................................................................. 47 REQUIREMENT TO CAPTURE A DIFFERENT PAYEE NAME DURING PAYMENT PROCESSING – PAYMENT VOUCHER ............ 47 Change Details ............................................................................................................................... ....................... 47 WHAT’S NEW IN SUNDRY PAYMENT VOUCHERS?......................................................................................... 49 REQUIREMENT TO CAPTURE A DIFFERENT PAYEE NAME DURING PAYMENT PROCESSING - SUNDRY PAYMENT VOUCHER49 Change Details ............................................................................................................................... ....................... 49 WHAT’S NEW IN FINANCE PROCESS PARAMETERS? ................................................................................... 51 NEW COMMON OPTION SETTING SCREEN ..................................................................................................................... 51 Change Details ............................................................................................................................... ....................... 51 WHAT’S NEW IN CHECK SERIES?........................................................................................................................ 53 REQUIREMENT TO MODIFY CHECK NUMBER................................................................................................................. 53 Background..................................................................................................................... ....................................... 53 Change Details ............................................................................................................................... ....................... 53 WHAT’S NEW IN RELEASE BANK PAYMENT?.................................................................................................. 55 REQUIREMENT TO MODIFY CHECK NUMBER ................................................................................................................. 55 Change Details ............................................................................................................................... ....................... 55 WHAT’S NEW IN SUPPLIER BANK INFORMATION?....................................................................................... 57 REQUIREMENT TO ADD ADDITIONAL DETAILS IN SUPPLIER BANK INFORMATION............................................................ 57 Background..................................................................................................................... ....................................... 57 Change Details ............................................................................................................................... ....................... 57 WHAT’S NEW IN MAINTAIN BANK REFERENCE?........................................................................................... 59 REQUIREMENT TO ADD ADDITIONAL DETAILS FOR INTERMEDIARY BANK REFERENCE.................................................... 59 Background..................................................................................................................... ....................................... 59 Change Details ............................................................................................................................... ....................... 59 WHAT’S NEW IN AUDIT TRAIL REPORT – SUPPLIER MASTER? ................................................................ 61 REQUIREMENT TO ADD AUDIT TRAIL FOR THE NEWLY ADDED INFO IN SUPPLIER MASTER............................................... 61 Background..................................................................................................................... ....................................... 61 Change Details ............................................................................................................................... ....................... 61 WHAT’S NEW IN CUSTOMER BALANCE REVALUATION?............................................................................ 63 REQUIREMENT TO DISPLAY ‘ ALL’ IN CONTROL ACCOUNT TYPE.................................................................................... 63 Background..................................................................................................................... ....................................... 63 Change Details ............................................................................................................................... ....................... 63 WHAT’S NEW IN RUN SUPPLIER BALANCE REVALUATION? ..................................................................... 65 REQUIREMENT TO DISPLAY ‘ ALL’ IN CONTROL ACCOUNT TYPE.................................................................................... 65 Background..................................................................................................................... ....................................... 65 Change Details ............................................................................................................................... ....................... 65 WHAT’S NEW IN RUN ACCOUNT BALANCE REVALUATION?..................................................................... 67 REQUIREMENT TO DISPLAY ‘ ALL’ IN CONTROL ACCOUNT TYPE.................................................................................... 67 Background..................................................................................................................... ....................................... 67 Change Details ............................................................................................................................... ....................... 67 Enhancement Notification WHAT’S NEW IN TAXATION FRAMEWORK Introduction to Malaysian GST Goods and Services Tax ( GST) is enforced by Royal Malaysian Customs Department in Malaysia. From April 1, 2015 Malaysian GST comes into effect in Malaysia. This GST is similar to Value Added Tax ( VAT) in other Countries. GST shall be levied and charged on the taxable supply of goods and services made in the course or furtherance of business in Malaysia by a taxable person. GST is also charged on the importation of goods and services. A taxable supply is a supply which is standard rated or zero rated. Exempt and out of scope supplies are not taxable supplies. GST is to be levied and charged on the value of the supply. The Current rate of tax for Standard Rated Supply is 6%. The changes & enhancements with respect to Malaysian GST are covered in this Enhancement Notification. Page 6 of 69 Enhancement Notification WHAT’S NEW IN MAINTAIN IDENTIFICATION DETAILS? Requirement to Display BRN / GST ID Number Reference: AHBF- 7615 Background The companies in Malaysia have a unique identification number called Business Registration Number. In order to capture the business registration number of the company, the Maintain Identification Details screen is enhanced to capture the details under the identifier ‘ Company Identification Reference’. Companies/ Businesses registered for GST with Royal Malaysian Customs will be assigned a GST Registration number. This GST Registration Number can be captured under the identifier ‘ Tax Identification Reference’. Change Details • The Maintain Identification Details screen is prepopulated with a quick code ‘ BRN #’ in Applicable Identification Reference with Business Registration Number in Description column based on the country of the selected Company code. This value will be populated only if the country is Malaysia. Refer Exhibit - 1. • On selection of ‘ Tax Identification Reference’ in Identifier combo it is prepopulated with GST ID No in Applicable Identification Reference column and GST Registration No. in Description column based on the country of the selected Company code. This value will be populated only if the country is Malaysia. Refer Exhibit – 2. • In Create Company and Edit Company screens, ‘ Maintain Identification Details’ is added as a link to launch the screen. Refer Exhibit – 3 & 4. Page 7 of 69 Enhancement Notification Exhibit - 1: Illustrates the ‘ Maintain Identification Details’ screen with “ Business Registration Number” BRN number and description displayed Page 8 of 69 Enhancement Notification Exhibit - 2: Illustrates the ‘ Maintain Identification Details’ Screen with “ GST ID No.” Exhibit – 3: Illustrates the ‘ Create Company’ screen with “ Maintain Identification Details” link. GST Reg. # number and description displayed Maintain Identification Details link Page 9 of 69 Enhancement Notification Exhibit – 4: Illustrates the Edit Company Screen with Maintain Identification Details Link. Maintain Identification Details link Page 10 of 69 Enhancement Notification WHAT’S NEW IN SUPPLIER MANAGE ADDITIONAL OPTIONS? Requirement to Capture Additional Information Reference: AHBF- 7561 Background Requirement to capture additional information for the Suppliers like BRN #, Assesse Type and GST Registration Number in Supplier master, if the tax Country is Malaysia. Change Details New category Malaysian GST is added to Manage Additional Options screen, ( link in Edit location details of Supplier master) provided the country code of the login Company is Malaysia. Parameter column is displayed with Business Registration Number and Assesse Type for the category Malaysian GST. Note: If login Company’s Country code is ‘ Philippines’, ‘ Philippines Tax’ is displayed in category column along with its respective parameter and permitted values. Similarly for the Country code ‘ Thailand’, ‘ THAI TAX Reports’ is displayed in Category column along with its respective parameter and permitted values. New Tax type ‘ Malaysian GST’ is added to Tax type of Supplier Tax Registration Details of Edit Supplier TCD Mapping screen to capture the GST Registration number of supplier. Page 11 of 69 Enhancement Notification Exhibit 1: Illustrates the category ‘ Malaysian GST’ in Manage Additional Options Page 12 of 69 Enhancement Notification Exhibit – 2: Illustrates the screen Edit Supplier TCD Mapping with new Tax Type ‘ Malaysian GST’ New Tax Type ‘ Malaysian GST’ to capture GST Reg. #. Page 13 of 69 Enhancement Notification WHAT’S NEW IN TAX ATTRIBUTES? Requirement to Define Malaysian Taxes Reference: AHBF- 7614 Background Requirement to define Malaysian Taxes in TCD master with the attributes such as nature of supply, nature of transaction, Tax Incidence, 21 days rule, Tax Category and Tax Class. Change Details • New Tax Type “ Malaysian GST” and “ Malaysian WHT” is introduced if the country of the Company is Malaysia. • The Tax Class & Category relating to Malaysian GST is made available in the Tax Attributes based on the Tax type. • New Tax Natures ‘ Recipient – Rev. Chg.’ ( Reverse Charge), ‘ Recipient – Expense’, ‘ Input Tax Expense’ introduced, relevant for the Tax Type ‘ Malaysian GST’ • New display only field to mention the Tax Invoice window: ‘ Tax Invoice Window ( days)' for recognizing the 21 day rule. For the Tax Type Malaysian GST, this field will be displayed with 21. Page 14 of 69 Enhancement Notification Exhibit – 1: Illustrates the Tax Attributes screen Page 15 of 69 Enhancement Notification Exhibit - 2: Illustrates New Tax Categories and Tax Class Page 16 of 69 Enhancement Notification WHAT’S NEW IN SUPPLIER ORDER BASED INVOICE? Requirement to Retrieve order level TCD information details Reference: AHBF- 7654 Background Requirement to retrieve Taxes, with Tax Incidence ‘ On Invoicing’/ ‘ On Payment’ added in the Order document, in Order Based Invoice and to manage accounting for the same at the Invoice level. Additional capability to modify the taxable amount for the Order level TCDs and the Invoice level TCDs. Change Details Order Based Invoice accounting has been enhanced to handle the accounting for TCDs with tax incidence ‘ On Invoicing’/ ‘ On Payment’ inherited from the Order documents. Accounting of Tax happens for order level taxes with incidence ‘ On Invoicing’ / ‘ On Payment’ only at the time of Invoice Accounting Entries: Tax Nature Invoice Posting Payment Posting Payable TCD A/ c Dr. xxx Supplier Control A/ c Cr xxx Supplier Control A/ c Dr. xxx Bank A/ c Cr xxx Recipient - Rev Charge GST ADJ A/ c Dr. xxx ( Usage ID - GSTADJ) Output GST Provision A/ c Cr xxx ( Usage id - SERTAXPROVRM) Note: Tax amount is displayed in Non Payable Taxes of Invoice Value Details cluster in the Maintain Invoice screen Output GST Provision A/ c Dr. xxx ( Usage id - SERTAXPROVRM) TCD ( GST Output) A/ c Cr xxx Note: TCD A/ c is the Account code mapped to the TCD & Variant in the Sales TCD ARD. TCD ( GST Input) A/ c Dr. xxx GST ADJ A/ c Cr. xxx ( Usage ID - GSTADJ) Note: TCD A/ c is the Account code mapped to the TCD & Variant in the Purchase TCD ARD. Page 17 of 69 Enhancement Notification Tax Nature Invoice Posting Payment Posting Recipient - Expense GST ADJ A/ c Dr. xxx ( Usage ID - GSTADJ) Output GST Provision A/ c Cr xxx ( Usage id - SERTAXPROVRM) Note : Tax amount is displayed in Non Payable Taxes of Invoice Value Details cluster Output GST Provision A/ c Dr. xxx ( Usage id - SERTAXPROVRM) TCD ( GST Output) A/ c Cr xxx Note: TCD A/ c is the Account code mapped to the TCD & Variant in the Sales TCD ARD. TCD ( GST Input) A/ c Dr. xxx GST ADJ A/ c Cr xxx ( Usage ID - GSTADJ) Note: TCD A/ c is the Account code mapped to the TCD & Variant in the Purchase TCD ARD. ( this account code should be an Expense or Revenue Account) Input Tax Expense TCD A/ c Dr. xxx Supplier Control ( SCA) A/ c Cr xxx Note: TCD account is an Expense or Revenue account defined in Purchase TCD ARD for the Tax nature Supplier Control A/ c Dr. xxx Bank A/ c Cr xxx New set option has been added in the Set Function Defaults activity of Supplier Order Based Invoice business component: • Allow Modification of Taxable Amount for Order Level Tax? With values ‘ Yes’ or ‘ No’. • Allow Modification of Taxable Amount for Invoice Level TCDs? With values ‘ Yes’ or ‘ No’. • Ref. Date for Tax Invoice Window Calculation ( With GR) with the value ‘ Receipt Date’. • Ref. Date for Tax Invoice Window Calculation ( No GR) with the value ‘ PO Authorization Date’. Modification of Taxable Amount: New column Taxable amount is added in the multiline of Part Order Level T/ C/ D information tab to enable modification of taxable amount of order documents and the existing Taxable Amount column in the Invoice level TCD information tab is made as an editable field. The following options are added in the Set Function Defaults activity to control the modifications to the taxable amounts; Page 18 of 69 Enhancement Notification A. “ Allow Modification of Taxable Amount for Order Level Tax?” Refer Exhibit 1. The set option will be loaded with the values given below: • Yes • No If the Option is set as ‘ Yes’: If the option is set to ‘ Yes’, the taxable amount for TCD codes of tax incidence ‘ On Invoicing’ and “ On Payment’ of Part Order level TCD information tab can be modified to the extent of Actual invoice amount of that invoice line. It cannot be modified to a value greater than actual invoice amount. Taxable amount cannot be modified even though the set option is set as ‘ Yes’ for Tax codes with Tax Incidence ‘ On Delivery’. If the Option is set as ‘ No’: If the option is set to ‘ No’, the existing behavior takes place. User cannot modify taxable amount. B. “ Allow Modification of Taxable Amount for Invoice Level TCDs?” Refer Exhibit 1. The set option will be loaded with the values given below: • Yes • No If the Option is set as ‘ Yes’: If the option is set to ‘ Yes’, the taxable amount for TCD codes of Invoice level TCD information tab can be modified to the extent of Actual invoice amount of that invoice line / document. It cannot be modified to a value greater than actual invoice amount. If the Option is set as ‘ No’: If the option is set to ‘ No’, the existing behavior takes place. User cannot modify taxable amount. Page 19 of 69 Enhancement Notification Exhibit - 1: New Option Setting Exhibit - 2: Illustrates the new column Taxable Amount in Part Order Level TCD information Tab Page 20 of 69 Enhancement Notification WHAT’S NEW IN CUSTOMER DIRECT INVOICE? Requirement to Generate Tax Adjustment Journals Reference: AHBF- 7527 Background Requirement to generate ‘ Tax Adjustment Journal’ for ‘ Packslip Invoice’ and ‘ Ref. Doc. Based Invoice’ based on the reference date. Hence a new set option is added to identify the reference document date which helps in deriving the No. of days of invoice to ensure whether it falls within the 21 days window. Change Details New set option has been added in the Set Function Defaults activity of the Customer Direct Invoice business component: • Ref. Date for Tax Invoice Window calculation ( Packslip) • Ref. Date for Tax Invoice Window calculation ( Ref. Based) Set Function Defaults: • The following option is added in the Set Function Defaults activity: Ref. Date for Tax Invoice Window calculation ( Packslip)' ' Ref. Date for Tax Invoice Window calculation ( Ref. Based).” Refer Exhibit 1. The set option will be loaded with the below- mentioned values: • Ref. Date for Tax Invoice Window calculation ( Packslip) loaded and defaulted with Issue Confirmation Date. • ' Ref. Date for Tax Invoice Window calculation ( Ref Based) loaded and defaulted with Flight Invoice Release Date. Based on the set option the No. of days in Manage Tax Invoice window is computed for tax adjustment journal generation. Page 21 of 69 Enhancement Notification Exhibit - 1: Page 22 of 69 Enhancement Notification WHAT’S NEW IN CUSTOMER INVOICE Requirement to Generate Tax Adjustment Journals Reference: AHBF- 7527 Background Requirement to generate Tax adjustment Journals for Customer Invoice with reference to Aircraft Maintenance Execution document and Shop Work Order. Hence a new set option is added to identity the reference document date which helps in deriving the no. of days of invoice to ensure whether it falls within the 21 days window to avail the credit. Change Details New set option has been added in the Set Function Defaults activity of the Customer Invoice business component: • Ref. Date for Tax Invoice Window calculation ( Aircraft) • Ref. Date for Tax Invoice Window calculation ( Shop) Set Function Defaults: • The following option is added in the Set Function Defaults activity: Ref. Date for Tax Invoice Window calculation ( Aircraft)', ' Ref. Date for Tax Invoice Window calculation ( Shop).” Refer Exhibit 1. The set option will be loaded with the below- mentioned values: • Ref. Date for Tax Invoice Window calculation ( Aircraft) loaded and defaulted with Root Exec. Doc. Closure Date. • ' Ref. Date for Tax Invoice Window calculation ( Shop) loaded and defaulted with Direct Issue Confirmation Date. Page 23 of 69 Enhancement Notification Exhibit - 1: Page 24 of 69 Enhancement Notification WHAT’S NEW IN JOURNAL VOUCHER? Requirement to create Tax Adjustment Journals manually Reference: AHBF- 7676 Background Requirement to create ‘ Tax Adj. Journals’ manually for adjusting taxes. Change Details • New Voucher type ‘ Tax Adj. Journal’ is added. • New columns ‘ T/ C/ D #’,’ Variant #’ & ‘ Taxable Amount’ is added. These columns are visible only if voucher Type is selected as ‘ Tax Adj. Journal’. The columns are not visible for other voucher types. • It is available in Create / Edit/ Authorize/ View Voucher screens. • Ref. Doc. Type is loaded with values Supplier order based Invoice, Customer Packslip Invoice, Customer Ref. Doc. Base Invoice, Customer Invoice if voucher type is selected as ‘ Tax Adj. Journal’. • TCD amount to be adjusted with the Tax Adj. journal is to be entered by the user. • The columns are meant only for data capture and only for reporting purpose. • Journals created through Manage Tax Invoice Window cannot be reversed through Reverse Journal voucher. Page 25 of 69 Enhancement Notification Exhibit - 1: Illustrates Create Journal Voucher Report displaying the voucher Type and the new columns Exhibit - 2: Illustrates Edit Journal Voucher Report displaying the voucher Type and the new columns New Voucher Type ‘ Tax Adj. Journal’ New columns New Voucher Type ‘ Tax Adj. Journal’ New columns Page 26 of 69 Enhancement Notification Exhibit – 3: Illustrates Authorize Journal Voucher screen displaying the voucher Type and the new columns New Voucher Type ‘ Tax Adj. Journal’ New columns Page 27 of 69 Enhancement Notification Exhibit – 4: Illustrates View Journal Voucher displaying the voucher Type and the new columns Exhibit – 5: Illustrates Reverse Journal Voucher displaying the voucher type and the new columns New Voucher Type ‘ Tax Adj. Journal’ New columns New Voucher Type ‘ Tax Adj. Journal’ New columns Page 28 of 69 Enhancement Notification WHAT’S NEW IN BOOK KEEPING? Enhancement to Manage Tax Invoice Window and to pass adjustment entries Reference: AHBF- 7544 Background As per Malaysian GST Statutory Requirement, Tax Invoice is to be issued to Customers within 21 days of the ‘ Point of Sale’/ ‘ Time of Supply’. If it is issued after 21 days, the Tax is liable to be paid on the date of ‘ Point of Sale’/ ‘ Time of Supply’, which might end up in filing a revised return. Similarly Tax Invoice is to be received from the Supplier within 21 days from ‘ Point of Sale’/ ‘ Time of Supply’ to claim the input on the Invoice date. If the Tax Invoice is received from vendor after 21 days the input should be claimed on the ‘ Point of Sale’/ ‘ Time of Supply’. If the Company has already submitted GST Return for the period to Customs Department without reporting the above tax invoice, it means Company has reported the Tax Return INCORRECTLY due to late invoice issued by the supplier. The company cannot claim the Input Tax Credit of the above Tax Invoice in the upcoming period. The company can either file a revised GST return along with fine or forego such Input. Change Details Manage Tax Invoice Window enables users to monitor and review the exceptional Customer/ Supplier Invoices which breach the tax Invoice Window days and to account the Tax on the correct date. Tax invoice enables recording of tax on correct date through Tax adjustment journals by reversing the TCD Input/ Output accounting on Invoice Date & accounting the same on the respective documents original ‘ Point of Sale’/ ‘ Time of Supply’. Key Concepts: • New Component ‘ Tax Invoice Window’ is added to the business process Book Keeping. • New Activity ‘ Manage Tax Invoice Window’ is added to the Component ‘ Tax Invoice Window’. • This activity enables managing tax invoice window for Supplier/ Customer invoices. You can generate tax adjustment journal voucher with reference to the invoices for adjustments to the taxes. • Tax adjustment journal voucher is generated when the tax invoice window is greater than 21 days. It enables retrieval of Authorized ( and above) Supplier/ Customer invoices for generating tax adjustment journal vouchers. Page 29 of 69 Enhancement Notification • Tax Adjustment Journals can also be reversed. Tax Adjustment Journals with status ‘ New’ ‘ Fresh’ ‘ Reverse’ status cannot be reversed, only records with ‘ Completed’ status can be reversed. • Invoices must be defined with TCD codes of Tax Type ‘ Malaysian GST’ in “ Tax Charges & Discount” business component. o Effect JV – Select this option to retrieve the invoice for which tax adjustment journal voucher is yet to be generated. o Review JV - Select this option to retrieve the invoice for which tax adjustment journal voucher is generated. o Pending Invoice – Select this option to retrieve the documents without invoices, to follow up for issuing Invoice to Customer and to receive Invoice from Supplier. • By default, the system displays ‘ Effect JV”. • Status: o If ‘ Context’ is selected as ‘ Effect JV”, the system, lists the values “ New “ and “ Fresh” in the ‘ Status’ drop- down list box and defaults “ New”. o If ‘ Context’ is selected as ‘ Review JV”, the system lists the values “ Completed” and “ Reversed” and defaults “ Completed”. o If ‘ Context’ is selected as “ Pending Invoice”, the system does not list any value in the ‘ Status’ drop- down list box. • Display Option o All – Select this option to retrieve all the documents with tax invoice window lesser than / equal to / greater than 21 days. o Exceptions - Select this option to retrieve all the documents with tax invoice window greater than 21 days. By default, the system displays “ Exceptions”. • No. of Days o The tax invoice windows days which is calculated as follows: No. of Days = Trading Partner Doc. Date - Ref. Date. ( E. g. Customer Invoice Date - Direct Issue Confirmation date) o If Modified Ref. Date is specified, No. of Days is calculated as follows: No. of Days = Trading Partner Doc. Date – Modified Ref. Date o If Trading Partner Doc. Date is not specified, No. of Days is calculated as follows: Page 30 of 69 Enhancement Notification No. of Days = Current Date - Ref. Date o If ' Modified Ref. Date' is later than Invoice Date ( Trading Partner Doc Date) No. of Days is displayed as ' Zero'. • Tax Adjustment Journal is generated on click of Confirm button. • Input Tax: Tax Adj. Journal - Reversal – as on Invoice Date GST Adj. A/ c Dr. TCD A/ c Cr Tax Adj. Journal - Ref. Doc. – as on Ref. date or Modified Ref. Date TCD A/ c Dr. GST Adj. A/ c Cr • Output Tax: Tax Adj. Journal – Reversal – as on Invoice Date TCD A/ c Dr. GST Adj. A/ c Cr Tax Adj. Journal - Ref. Doc. – as on Ref. date or Modified Ref. Date GST Adj. A/ c Dr. TCD A/ c Cr Page 31 of 69 Enhancement Notification Exhibit – 1: Illustrates Manage Tax Invoice Window screen Page 32 of 69 Enhancement Notification WHAT’S NEW IN REPORTS - BOOK KEEPING? Enhancement to Report on Tax Transactions - Country Specific Reference: AHBF- 7544 Background Reporting requirements in Malaysian GST requires two new reports: 1. GST Return File ( TAP File): this is required for filling the GST Monthly/ Quarterly Report to the Royal Malaysian Customs under Tax Access Point ( TAP). This report summarizes the Taxable value and Tax value under each tax head. 2. GAF File: General Audit File: this report is to be produced to the Royal Malaysian Customs on request during audits. This report lists all the transactions with the trading partner details and the Tax involved. It has a listing of all Purchases, all Sales & all GL transactions, with its corresponding tax information, in the form of a Text File, with Bar Delimited separator. Change Details • These reports are positioned under the activity ‘ Report on Tax Transactions - Country Specific’. These reports are available for all Malaysian Companies. Note: only if the Country code of the Company is ‘ Malaysia’, these reports will be enabled in this screen. • The Tax Type dropdown will have the value ‘ Malaysian GST’ in the Search criteria. • Report Type will have the values: ‘ GAF File’ and ‘ GST Return File’ corresponding to the Tax Type. Page 33 of 69 Enhancement Notification Exhibit - 1: Illustrates ‘ Report on Tax Transactions – Country Specific’ screen Page 34 of 69 Enhancement Notification Exhibit - 2: Illustrates GST Return File Page 35 of 69 Enhancement Notification Exhibit - 3: Illustrates GAF File Page 36 of 69 Enhancement Notification WHAT’S NEW IN SUPPLIER DIRECT INVOICES & DEBIT / CREDIT NOTES? Ability to inherit taxes from Purchase Tax Rules Background Taxes can be inherited to the Invoices & Notes currently through Default Tax Keys. Default Tax Keys support only on tax at a time. Other taxes required are manually added in to the Invoices & Notes. This leads to high possibility of Omission of taxes ( especially with- holding taxes.) while recording the Invoice. In order to ease the tax inheritance, a new framework is built through the Purchase Tax Rules, to inherit taxes in to Direct Invoices & Debit Credit Notes. Change Details • A new set option has been added to the Set Function Defaults activity of the Supplier Direct Invoice business component – “ Allow Inheritance of Taxes Based on”. Refer Exhibit 1. • A new set option has been added to the Set Function Defaults activity of the Supplier Debit / Credit Notes business component - “ Allow Inheritance of Taxes Based on”. Refer Exhibit 2. The set option will be loaded with the below mentioned values: • Purchase Tax Rules • Statutory Tax Defaults. If the Set option is set as ‘ Purchase Tax Rules’: If the set option ‘ Allow Inheritance of Taxes Based on’ is set as “ Purchase Tax Rules”, ‘ Default Tax Key’ combo is defaulted with blank value but the same will be loaded with all eligible tax keys. TCDs with Tax rule having applied on as ‘ Document’ in Manage Purchase Tax Rules is retrieved for Invoice/ Notes with document level TCDs. TCDs with Tax rule having applied on as ‘ Line’ in Manage Purchase Tax Rules is retrieved for Invoice / Notes with document level TCDs. • Tax rules which are effective on Supplier’s Invoice Date will be considered for inheritance. ( Refer Exhibit 3). • Tax code and variant of the tax rule should be Active and effective on the Invoice date. Page 37 of 69 Enhancement Notification • The Tax Rule with maximum match will be considered for inheritance. • If more than one exact match is available, then tax rule having least order of preference will be considered for inheritance. • Tax code will be inherited in the specified currency in the Purchase Tax Rules. • Taxes will also be inherited during edit to the Direct Invoices / Notes. If the set option ‘ Allow Inheritance of Taxes Based on’ is set as “ Statutory Tax Defaults” the existing functionality of inheritance of taxes based on the Tax Key is applicable. Page 38 of 69 Enhancement Notification Exhibit 1: Set function defaults of Supplier Direct Invoice Exhibit 2: Set Function Defaults of Supplier Debit / Credit Notes. New Option in Debit Credit Notes New option in Direct Invoices Page 39 of 69 Enhancement Notification Exhibit 3: Illustrates the Purchase Tax Rules Page 40 of 69 Enhancement Notification WHAT’S NEW IN CHECK PAYMENT? Ability Manage Payee Name Reference: AHBC- 1224 / AHBF- 9976 Background Payee Name modification is basically done in order to capture a different name from that of the Supplier Name for Check Printing. For Example, if the Supplier Name is ‘ ABC Inc.’, the name to be mentioned in the check could be M/ s ABC Inc. or entirely a different name based on the business requirement. In certain cases the name in which the Checks are to be issued is identified and approved at the time of Pay Batch Authorization itself. The enhancements with respect to usage of alternate Payee Name during the above scenarios are covered in this Enhancement Notification. Page 41 of 69 Enhancement Notification WHAT’S NEW IN SUPPLIER MASTER? Requirement to capture alternate name for Check Print Change Details • A new optional editable field ‘ Payee Name’ is added in Add Location Details screen in the Supplier Master. Refer Exhibit – 1. • A new optional editable field ‘ Payee Name’ is added in Edit Location Details screen in the Supplier Master. Refer Exhibit – 2. • A new display only field ‘ Payee Name’ is added in View Location Details screen in the Supplier Master. Refer Exhibit – 3. • If Payee Name is specified in the Supplier Master, the same will be defaulted during Check Printing, unless a different name has been specified in Prepayment Vouchers, Pay Batch / Vouchers and Sundry Payment Vouchers. Page 42 of 69 Enhancement Notification Exhibit 1: Illustrates the Add Location Details screen with “ Payee Name” Exhibit 2: Illustrates the Edit Location Details screen with “ Payee Name” New Editable Field Payee Name New Editable field Payee Name Page 43 of 69 Enhancement Notification Exhibit 3: Illustrates the View Location Details screen with “ Payee Name” New display only field Payee Name Page 44 of 69 Enhancement Notification WHAT’S NEW IN SUPPLIER PREPAYMENT VOUCHERS? Requirement to capture a different Payee Name during Payment Processing – Prepayment Voucher Change Details • The “ Edit/ View Payee Info.” link has been added in Create, Edit, Authorize and View Supplier Prepayment Vouchers. • This new page in Exhibit 2 allows us to capture a different Payee Name from that of the Supplier Name before authorization of the Prepayment Voucher. • The Payee Name can be modified based on the Option: “ Allow modification of Payee Name in Prepayment Voucher” is set as ‘ Yes’ in Set Finance Process Parameters activity. • If Payee Name is modified in the Prepayment Voucher, the same will be defaulted during Check Printing. Page 45 of 69 Enhancement Notification Exhibit 1: Illustrates the new link page added Exhibit 2: Illustrates the Edit/ View Payee Information Page, where a different Payee Name can be specified Note: 1. The highlighted column – “ Payee Name”, the Payee Name can be mentioned/ modified. 2. This screen can be accessed from Create / Edit / Authorize and View screens Edit/ View Payee Info. link Page 46 of 69 Enhancement Notification WHAT’S NEW IN SUPPLIER PAY VOUCHERS? Requirement to capture a different Payee Name during Payment Processing – Payment Voucher Change Details • The “ Edit/ View Payee Info.” link has been added in Create, Edit, Authorize and View Regular Pay Batch. • This new page in Exhibit 2 allows us to capture a different Payee Name from that of the Supplier Name before authorization of the Payment Batch/ Vouchers. • The Payee Name can be modified based on the Option: “ Allow modification of Payee Name in Pay Batch” is set as ‘ Yes’ in Set Finance Process Parameters activity. • If Payee Name is modified in the Regular Pay Batch / Voucher, the same will be defaulted during Check Printing. Page 47 of 69 Enhancement Notification Exhibit 1: Exhibit 2: Note: 1. The highlighted column – “ Payee Name”, the Payee Name can be mentioned / modified. 2. This link ‘ Edit/ View Payee Info.” can be accessed from Create / Edit / Authorize and View Pay Batch screens Edit / View Payee Info. link Page 48 of 69 Enhancement Notification WHAT’S NEW IN SUNDRY PAYMENT VOUCHERS? Requirement to capture a different Payee Name during Payment Processing - Sundry Payment Voucher Change Details • The “ Edit/ View Payee Info.” link has been added in Create, Edit, Authorize and View Sundry Payment Vouchers. • This new page in Exhibit 2 allows us to capture a different Payee Name from that of the Payee Name before authorization of the Sundry Payment Vouchers. • The Payee Name can be modified based on the Option: “ Allow modification of Payee Name in Sundry Payment” is set as ‘ Yes’ in Set Finance Process Parameters activity. • If Payee Name is modified in the Prepayment Voucher, the same will be defaulted during Check Printing. Page 49 of 69 Enhancement Notification Exhibit 1: Exhibit 2: Edit/ View Payee Info Link Page 50 of 69 Enhancement Notification WHAT’S NEW IN FINANCE PROCESS PARAMETERS? New Common Option Setting Screen Change Details • A new screen Set Finance Process Parameters is added under the business component OU Parameter Setup to capture the set options relating to this Payee Name modification. • In this screen three new filters have been added to effectively manage the future new options namely ‘ Parameter Level’, ‘ Business Process’ and ‘ Category’. • The Parameter Level combo is loaded with the values – Organization Unit Level and defaulted with Organization Unit Level. • The Business Process Combo is loaded with the values ‘ Blank’ and Payables Management and defaulted with ‘ Blank’. • The Category combo is loaded with the values ‘ Blank’ and Supplier Payment and defaulted with ‘ Blank’. • On screen launch the applicable parameters for the combination Parameter Level - Organization Unit Level, Business Process - ' Blank' and Category - ' Blank' will be displayed. • The Option is to be specified in the “ Value” column against each Process Parameter. Page 51 of 69 Enhancement Notification Exhibit 1: Note: Error Message column to display the errors in the data entry for this option. Page 52 of 69 Enhancement Notification WHAT’S NEW IN CHECK SERIES? Requirement to Modify Check Number Background Check leaves are generally signed and kept by one signatory. In Case of multiple signatories each signatory will have a sign of check leaves. There is a need to skip check numbers in the absence of one of the signatories. Currently system assigns check numbers sequentially. It does not allow to skip check numbers. Hence Release Payment is enhanced to allow skipping of check numbers based on a set option in Check series. Change Details • In Create / Edit Check Series screen a new option ‘ Allow Modification of Check # in Check Print’ check box is added to enable or disable modification of Check number while printing check. • On launch of the Create Check Series screen, the option is always is unchecked. When the ‘ Allow Modification of Check # in Check Print’ check box is checked, the new column ‘ Modified Check #’ in Print Check screen is visible. • If it is unchecked for the check series, the ‘ Modified Check #’ column in Print Check will not be visible. Page 53 of 69 Enhancement Notification Exhibit 1: Exhibit 2: New option ‘ Allow Modification of Check # in Check Print’ New option ‘ Allow Modification of Check # in Check Print’ Page 54 of 69 Enhancement Notification WHAT’S NEW IN RELEASE BANK PAYMENT? Requirement to modify Check Number Change Details • Check Series Information section is moved above the multiline for better context. • The possible Check numbers will be displayed in the Check # column on screen launch itself. • The new column in the multiline – ‘ Modified Check #’, which will be visible only if the check series allows modification of Check # • On Modification of ‘ Check Series #’ / ‘ Single Check?’ the check numbers are refreshed accordingly in multiline in the Check # column. • If Single Check? is “ Yes” and if the Payee and Supplier code are same, single check number of the selected check series is assigned in Check # column of multiline. • If the number of Checks available is less than the number of vouchers retrieved for payment for the selected check series, blank will be displayed in Check # column for those vouchers. • Checks which are in “ Printed / Void / Deleted / Reprinted / Damaged’ statuses are not allowed in ‘ Modified Check #’ column. • Next available check which is not used is displayed in ‘ Next Usable Check #’ of ‘ Check Series Information’ cluster. • Checks which do not belong to the selected check series are not allowed in ‘ Modified Check #’ column. Page 55 of 69 Enhancement Notification Exhibit 5: Check Series Information is moved above the multiline New column ‘ Modified Check Page 56 of 69 Enhancement Notification WHAT’S NEW IN SUPPLIER BANK INFORMATION? Requirement to add additional details in Supplier Bank Information Background Supplier Bank Information allows the user to capture the bank details of the Supplier for Electronic Payment Processing purposes. There were requirements for capturing additional information about Supplier Bank / Intermediary Bank for such payment processing. The additional information added in the Supplier Bank Information are detailed out below. Change Details The following new columns have been added in the Supplier Bank Information screen for capturing the information required for Electronic Payment Processing.  City  State  Country  Zip  Fax  Phone  E- mail  Transit Number  BSB Number  RTGS/ IFSC Code  Sort Code  BIC Code  Routing / ABA / Fed Wire  Remitter ID  Company Bank Code  Company Bank Type  Intermediary Bank Ref.  Contract Reference  Contact Person  User defined details – 1  User defined details – 2  User defined details – 3  User defined details – 4  User defined details – 5 Page 57 of 69 Enhancement Notification Exhibit 1: Displays few of the columns which are added in the Supplier Bank Information Page 58 of 69 Enhancement Notification WHAT’S NEW IN MAINTAIN BANK REFERENCE? Requirement to add additional details for Intermediary Bank Reference Background Bank Reference contains information uniquely identifiable for a Bank. For the Bank Intermediary Bank Reference Identified for the Supplier’s Bank, the Bank Reference information is gathered in the Bank Reference Master. The changes in the Supplier Bank Reference mentioned below. Change Details • The Create Bank Reference screen has been modified as Maintain Bank Reference taking away Edit Bank Reference. • Creation, modification & Inactivation of Bank Reference is now enabled in the same screen. • Maintain Bank Reference is added as a link from the Supplier Bank Information Screen. • Following are the new columns added in the Maintain Bank Reference Screen.  Sort Code  BIC Code  RTGS/ IFSC Code  Transit Number  BSB Number  Routing / ABA / Fedwire  Effective from Date  User defined details - 1  User defined details - 2  User defined details - 3  User defined details - 4  User defined details - 5  Status  Created by  Created Date  Last Modified by  Last Modified date Page 59 of 69 Enhancement Notification Exhibit 1: Exhibit 2: Screen Renamed as ‘ Maintain Bank Reference’ New Inactivate button introduced in the Maintain Screen Some of the newly added columns Link to the Maintain Bank Reference Screen Page 60 of 69 Enhancement Notification WHAT’S NEW IN AUDIT TRAIL REPORT – SUPPLIER MASTER? Requirement to add audit trail for the newly added info in Supplier Master Background Audit Trail Report is used for tracking changes made in the Supplier Bank Information. With the help of this report any modification done in Supplier Bank Information can be traced successfully. For the newly added details in the Supplier Master, Audit Trail has to be enabled. Change Details The following are the details are added in the Audit Trail Report of Supplier Master.  Pay Ref ID  Pay Mode  Address2  Address3  Effective From date  Effective to date  BIC Code  BSB No  City  Country  Bank type  Bank Currency  Bank Ac No  IBAN No  Swift No  National Clearing Code  Bank Name  Address1  Email  Fax  Int. Bank Ref  Phone  Remitter ID  RTGS/ IFSC Code  Sort Code  State  Transit No  Zip  Routing / ABA / Fed wire Page 61 of 69 Enhancement Notification Exhibit 1: Illustrates the Audit Trail Info. for some of the newly added fields Page 62 of 69 Enhancement Notification WHAT’S NEW IN CUSTOMER BALANCE REVALUATION? Requirement to display ‘ All’ in Control Account Type Background Customer Balance Revaluation is carried out for “ Control Account”, “ Prepayment Account” and “ Deposit Account”. The field “ Control Account Type” in Run Customer Balance Revaluation screen currently does not have the value “ All”, to carry out the revaluation for all accounts together. Change Details The control Account Type is loaded with ‘ All’ in order to enable processing of all the Account Codes together. It reduces the clicks for the user instead of selecting individual control account types. Page 63 of 69 Enhancement Notification Exhibit 1: Run Customer Balance Revaluation Exhibit 2: Reverse Customer Balance Revaluation Exhibit 3: View Customer Balance Revaluation New value “ All” is added New value “ All” is added New value “ All” is added Page 64 of 69 Enhancement Notification WHAT’S NEW IN RUN SUPPLIER BALANCE REVALUATION? Requirement to display ‘ All’ in Control Account Type Background Supplier Balance Revaluation is carried out for “ Control Account”, “ Prepayment Account” and “ Deposit Account”. The field “ Control Account Type” in Run Supplier Balance Revaluation screen currently does not have the value “ All”, to carry out the revaluation for all accounts together. Change Details The control Account Type is loaded with ‘ All’ in order to enable processing of all the Account Codes together. It reduces the clicks for the user instead of selecting individual control account types. Page 65 of 69 Enhancement Notification Exhibit 1: Run Supplier Balance Revaluation Exhibit 2: Reverse Supplier Balance Revaluation Exhibit 3: View Supplier Balance Revaluation New value “ All” is added New value “ All” is added New value “ All” is added Page 66 of 69 Enhancement Notification WHAT’S NEW IN RUN ACCOUNT BALANCE REVALUATION? Requirement to display ‘ All’ in Control Account Type Background Account Balance Revaluation is carried out for Asset Accounts and Liability Accounts separately. The field “ Account Group” in Run Account Balance Revaluation screen currently does not have the value “ All”, to carry out the revaluation for all accounts together. Change Details The Account Group is loaded with ‘ All’ in order to enable processing of all the Account Codes together. It reduces the clicks for the user instead of selecting individual control account types. Page 67 of 69 Enhancement Notification Exhibit 1: Run Account Balance Revaluation Exhibit 2: Reverse Account Balance Revaluation Exhibit 3: View Account Balance Revaluation New value “ All” is added New value “ All” is added New value “ All” is added Page 68 of 69 © 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