Wednesday, April 15, 2015

Release Notes for Sage UBS

Content This release notes covers the Progressive Enhancement for Sage UBS

Version 9.9.1.19 Release date: 12th April 2015

 Progressive Enhancements 

Improvement on Invoice, Credit Note & Debit Note layout 

Additional fields added to the standard templates as requested 

Sales 
  1. Customer GST registration no 
  2. Agent 
  3. Currency rate with 4 decimals 
Purchase 
  1. Supplier GST registration no 
  2. Currency rate with 4 decimals   

 Improvement on Cash Sales – Tax invoice

 For walk-in customers (you selected cash account), you can enter the name, address & GST registration number as below

Sales Credit Note & Sales Debit Note

Purchase – Miscellaneous charges

Miscellaneous charges are enabled for Purchase entries screens.

Regenerate Malaysia Tax codes 

If your data file is updated from old version (below 9.9.1.x), the Singapore tax codes are already exists in the tax maintenance table. You can now click on the [Regenerate Malaysia Tax Code] in the Tax Maintenance screen. System will remove all Singapore Tax Codes and regenerate Malaysia Tax Codes into the tax table.  
Please note that if you have linked a GL account to tax code as below, you will need to re-do the linkage after regenerate the Malaysia tax codes.

Version 9.9.1.18      Release date: 4th April 2015 

Progressive Enhancements

Improvement on Invoice, Credit Note & Debit Note layout 

The document layouts have been adjusted to be able to fit more item lines in 1 page.  

Version 9.9.1.17      Release date: 03rd April 2015 

Progressive Enhancements  

Posting with same Tax Code and Major Industry Code 

Previously, when doing Posting, system will post all the item lines as per transaction. Now, it has been enhanced to merge all lines if same tax code and same major industry code. Scenario as below:
 i. Transactions with SAME tax code but DIFFERENT major industry code --> Show entry in separate line
 ii. Transactions with DIFFERENT tax code but SAME major industry code --> Show entry in separate line 
iii. Transactions with SAME tax code and SAME major industry code --> Merge entry and show in one line 

Sage UBS One – Supplier Invoice 

Supplier Invoice transaction entry is now made available in SageUBS One license. You now can check all the Supplier Invoice reports as well. 

Sales CN/DN and Purchase CN/DN – Update from Invoice and Update from Supplier Invoice

 Under Malaysia GST requirement, related Credit Note or Debit Note must be link to an invoice. To ensure all Credit Note and Debit Note must be link to an invoice, you can set as below: 

Setting screen 

Entry Screen
i) Purchase DN
 ii) Purchase CN 
iii) Sale DN
iv) Sale CN

Monday, April 13, 2015

Release Notes for Sage Payroll & HRMS 2015

This release notes covers the Progressive Enhancement in Payroll & HRMS 2015

Version 9.9.1.5      Release date: 27th February 2015

 Landing page

 a) After logout from landing page, page will be returning to login screen instead of exiting system.
 b) List view of company

 CDAC, Eurasian Association, SINDA (For Singapore Edition only)

 a) CDAC, ECF and SINDA are calculated using gross pay, including Basic rate, Allowances, Commission, Bonus, OT Pay, etc. 

b) In the case of more than one payment (1st half > 2nd half > Bonus > Commission) for the month, the deduction amount always use total deduction minus deduction already paid out in the previous payment.

 e.g. 1st half > 2nd half > Bonus > Commission 
CDAC, ECF, SINDA of 2nd half = Total contribution (1st + 2nd half) – contribution already paid out in 1st half
CDAC, ECF, SINDA of Bonus = Total contribution (1st + 2nd half + Bonus) – contribution already paid out in 1st and 2nd half

Version 9.9.1.3     Release date: 26th January 2015 

PCB 2015

The PCB for Returning Expert Program and Knowledge Worker is now updated to the latest formula.

Manage user 

In version 9.9.1.0 – 9.9.1.2 , the user management screen was disabled for maintenance purpose. Now this function is made available. 

CDAC, Eurasian Association, SINDA

Individual monthly contribution rate to CDAC Fund, ECF and SINDA fund has been updated. 

Version 9.9.1.0      Release date: 14th January 2015

Sage Payroll 2015 

Installation Sage Payroll 2015 installation includes installation of Sage Payroll 2015 and Sage HRMS. System will auto create data folder in Sage HRMS for every existing company found in Sage Puayroll. 

 
New Landing Page 

After login to the system, you will come to new landing page, you can : 
o Access the company 
o Create New Company 
o Edit Company Logo, directory folder 
o Delete Company 
o Manage License
o Manage User in Control Panel 
o Select company to enter Payroll or HRMS module.

Important notes:

1. For Windows 8, sometimes it will block the system from updating the company list causing no company listed in the landing page. So, when 1st time login, if system is unable to update the company table, system will prompt the below message. You must run the steps mentioned in this message for 1 time. 
 2. If previously you have both Payroll and HRMS, but you did not link the data folders, by default, system will only show all companies in your Payroll system, you will need to manually link the data folders by clicking the icon below the company logo.

New Simplified Interface (For Malaysia edition only) 

In Sage Payroll 2015, you will have to option to switch to the new simplified interface with : 
o Guided processing flow for 1st half pay, 2nd half pay, Commission and Bonus
o End to end process from add pay, process pay, print payment reports to month end process in a centralized menu 
o Reprocess pay function without deleting previous pay
o View calculation breakdown for EPF, SOCSO and PCB 
o Employee listing with alphabetical, gender & status grouping 
 

PCB 2015 

a) Income Tax for Resident Individual 
  •      Individual income tax rate will be reduced by 1 to 3 percentage points.  
  •      Individual income tax will be restructured whereby the chargeable income subject to the maximum rate will be increase from exceeding RM100,000 to exceeding RM400,000.
  •      The maximum tax rate for year 2014 at 26% will be reduced to 24%, 24.5% and 25%. 

b) Income Tax for Non - Resident Individual  
  •      Non – resident individuals’ income tax rate would be reduced by 1% from 26% to 25%. 

c) Increase in Deduction for Medical Expenses Incurred For Serious Diseases  
  •      The deduction for medical expenses incurred for serious disease be increased to RM6,000. 

d) Increase in Deduction For Disable Child  
  •      The deduction be increased to RM6,000. 

e) Increase in Deduction For Purchase Of Basic Supporting Equipment For The Disabled  
  •      The deduction be increased to RM6,000. 

Reference: 
http://www.hasil.gov.my/goindex.php?kump=5&skum=3&posi=1&unit=5100&sequ=6

 Important notes:

Due to the latest MTD calculation using computerized calculation for 2015 is only announced on 06/01/2015, thus, the PCB for Returning Expert Program and Knowledge Worker will be remained as 15% as for now. 
The formula will be updated accordingly in the next online update.


CPF Contribution Rate Change (For Singapore) 

CPF contribution rates are increased from 1 January 2015: 
a) Increase in Employer’s CPF Contribution Rates For employees aged 50 years and below or above 65 years, the employer contribution rates are increased by 1 percentage point. For employees aged above 50 to 55 years or above 55 to 65 years, the employer contribution rates are increased by 2 and 1.5 percentage points respectively.  

b) Increase in Employee’s CPF Contribution Rates For employees aged above 50 to 55 years, the employee contribution rates are increased by 0.5 percentage point. For those earning wages of >$500 to <$750, the contribution rates continue to be phased-in. The increase in CPF contribution is allocated to the Ordinary Account. 

The increase in the CPF contribution rates does not apply to graduated employer and employee rates for first or second year Singapore Permanent Residents (SPR) and their employers. From 2015, the CPF Annual Limit is increased to $31,450. The Ordinary Wage Ceiling remains unchanged. 

Reference: 
http://mycpf.cpf.gov.sg/Employers/Gen-Info/cpf-Contri/CPF_Contribution_Rate_Booklets.htm

Saturday, April 11, 2015

Progressive Enhancement of GST

 This release notes covers the Progressive Enhancement of GST


Version 9.9.1.18     Release date: 4 th April 2015 

Progressive Enhancements 

Improvement on Invoice, Credit Note & Debit Note layout  

The document layouts have been adjusted to be able to fit more item lines in 1 page.

Version 9.9.1.17     Release date: 03rd April 2015 

Progressive Enhancements 

Posting with same Tax Code and Major Industry Code 

Previously, when doing Posting, system will post all the item lines as per transaction. Now, it has been enhanced to merge all lines if same tax code and same major industry code. Scenario as below:
 i. Transactions with SAME tax code but DIFFERENT major industry code --> Show entry in separate line
 ii. Transactions with DIFFERENT tax code but SAME major industry code --> Show entry in separate line 
iii. Transactions with SAME tax code and SAME major industry code --> Merge entry and show in one line 


Sage UBS One – Supplier Invoice 

Supplier Invoice transaction entry is now made available in SageUBS One license. You now can check all the Supplier Invoice reports as well. 

Sales CN/DN and Purchase CN/DN – Update from Invoice and Update from Supplier Invoice

 Under Malaysia GST requirement, related Credit Note or Debit Note must be link to an invoice. To ensure all Credit Note and Debit Note must be link to an invoice, you can set as below: 

Setting screen 

Entry Screen
i) Purchase DN
 ii) Purchase CN 
iii) Sale DN
iv) Sale CN

Version 9.9.1.16     Release date: 01st April 2015 

Progressive Enhancements 

Payment (including Sundry Expenses) & Receipt 

Previously, you are only able to select Bank GL account in Payment & receipt screen. Now it has been enhanced to include Cash GL account.

 Data integrity enhancement 

Now, transactions posted from Inventory & Billing and Point of Sales (POS) are not editable. This is to ensure data integrity for proper GST reporting purpose.

Consistency enhancement 

If Malaysia GST is enabled, [With per item tax] is applied to all entry screen. You will not be able to specify the type of transaction to apply like before. 

Version 9.9.1.15      Release date: 01st April 2015 

Progressive Enhancements 

Tax Invoice for GST Relief

If you are supply item to a taxable person given GST relief under Item 3, Schedule A of GST (relief) Order 2014, please select the below templates from the [Report] folder 
Tax Invoice --> ICBIL#02_GSTRELIEF
Credit note --> ICBIL#04_GSTRELIEF
Debit note --> ICBIL#05_GSTRELIEF


GST Taxable Period

There are GST registration company which having 3 months taxable period, but the 1st taxable period is less than 3 months.

 In the below example, the 1 st taxable period is only 1 month.

GST Return – GST-03 Form 

The “Draft” watermark in the GST-03 form has been removed.

Enhancement on Tax Invoice, Credit Note, Debit Note 

If there are more than 5 items in the transaction, please select the template with “_more” 


Database Optimizer Tool 

Previously, there are many cases of corrupted index file causing error message such as “Variable xxx not found”. With the database optimizer tool, when system detected the error, the data optimizer tool will be triggered, please run the tool to allow it to repair the corrupted index file. 

Backup before upgrade data file

 System has been enhanced to always backup the data file before upgrading of data file. 

Version 9.9.1.14      Release date: 25 th March 2015 

Progressive Enhancements

 Fix for “Housekeeping in Progress” message If you encounter the message “Housekeeping in Progress” message, you can click on the refresh button at the select application screen, after that you should be able to access the system normally. 

Sundry Expenses (Accrual) 

After you received the invoiced for sundry expenses, sometimes you would like to enter the transaction for input tax claim purpose, charge the expenses to an accrual account, and settle the payment later. Now you can use the Sundry expenses (accrual) entry screen to enter the transaction. It is accessible via Transactions > Sundry expenses (accrual).

Version 9.9.1.13     Release date: 24th March 2015

Progressive Enhancements


GST Inclusive / Exclusive at Entry screen

With this enhancement, you will be able to set the GST to be calculated based on GST exclusive / GST inclusive in the entry screen.

For example, at system level, you have set in the General setup that GST amount to be calculated based on GST exclusive. But during transaction, for a particular invoice, you want the GST amount to be calculated based on GST inclusive method, you just need to set the as GST inclusive at the body before you start selecting the items.



GST Return – Major Industry Code

The GST Return report is enhanced to be able to calculate the breakdown Value of Output Tax in accordance with the Major Industries Code.

To ensure accurate calculation, please make sure that you have map the correct major industry code to each item via Item maintenance or Item group maintenance. If you specified the major industry code at Item group, remember to link each item to its respective item group.



GST Wizard – Map GL account to Tax code

The GST Wizard has been enhanced to allow mapping of GL account to Tax code. For example, to map GL expenses GL account to “BL” tax code.



GST Return – Support versioning

After GST Return (GST-03) is submitted to JKDM, you are still able to resubmit as amendment before the submission due if there is any amendment need, e.g. adjustments, missed out transactions etc.

Now, GST Return report is enhanced to support versioning after submission. This means after the GST Return report with “S” status, you can re-generate it and it is tracked by version number. And for subsequent version, “Amendment” will be checked.


Sales Invoice – Update from DO

Under Malaysia GST requirement, tax invoice must be issued within 21 days after the goods is delivered, else the time of supply will be moved to the goods delivery date.
To ensure all sales invoice must be link to a delivery order, you can set [INV – Always mark update from DO].


Setting screen

 

Entry screen

 

Version 9.9.1.12     Release date:  2nd March 2015 

Progressive Enhancements  

 Purchase Debit Note & Purchase Credit Note 

 Previously, purchase debit note and purchase credit note are entered in Sage UBS accounting only as double entries.  

Malaysia GST requires purchase debit note and purchase credit note must be linked to at least 1 supplier invoice. So, Sage UBS Inventory & Billing has been enhanced to provide the purchase debit note and purchase credit note entry screens. You can also print the purchase debit note and purchase credit note after saved.   



Default GST Tax Code in Purchases and Sales entry screens  

For purchases entry screen, the default GST tax code checking is via the hierarchy below : 
Supplier --> Item --> Item group --> Tax Code Setting in Administrative Tools 
 

For sales entry screen, the default GST tax code checking is via the hierarchy below :
Address --> Customer --> Item --> Item group --> Tax Code Setting in Administrative Tools 

Please note that, due to the delivery address is using remark 0 – 4 at the header, and the remarks can used for any other purposes other than delivery address. So, you must always select the [With delivery address] to indicate that there is delivery address, before you click [Body] or select [Update from…].  
 

Self billed invoice – Supplier listing

Now, only suppliers with RMCD approval number maintained will be shown in the Supplier list.  

21 days rule 

When run the GST Return wizard (GST-03), system will check for any un-invoice delivery order. You are given the options to  
a) Exit from the wizard and generate the invoice accordingly for those delivery orders 
b) GST Return wizard will calculate the output tax for the delivery orders.  

To make sure the financial entries are generated and posted to the correct GL account, you must create the Accrued debtor & Invoice to be issued GL accounts and do the mapping in Accounting > GST Settings. If the mapping is not available, system will inform you to do the mapping accordingly when do posting of invoice from Sage UBS Inventory & Billing. 



Import from CSV  

If you are using other Billing system, and using Sage UBS Accounting for GST reporting, now, you can import billing transactions into Sage UBS Accounting with CSV format, for GAF’s section [P] and [S] purpose.  

If you would like to understand the structure of the CSV file, in Sage UBS Inventory & Billing, go to Periodic > Export / Import > E.I. Housekeeping, select 9. LIST STRUCTURE – ARTRAN.DBF, 59. LIST STRUCTURE – ICTRAN.DBF and 40. LIST STRUCTURE – GLPOST9.DBF, click apply to view or print structure.  


To do posting of journal entries from the Billing system into Sage UBS Accounting, go to Periodic > Export / Import > Import from CSV, select 1. IMPORT FROM GLPOST9.CSV.

 
To import the billing transactions into Sage UBS Accounting, go to Periodic > Export / Import > Import from CSV, select 5. IMPORT FROM ARTRAN9 CSV and ICTRAN9.CSV. These 2 files must be imported together.   


Version 9.9.1.11     Release date:  06th February 2015

 Progressive Enhancements 

Major Industry Code Maintenance – Edit button

Edit button is now made available in Major Industry Code Maintenance screen to allow you to modify the description of existing major industry code.

 

GST-03 Wizard – Part 5

The Nationality field is now enhanced to be a dropdown list selection.  It is a mandatory field.  
a) If Nationality is Malaysia, Identity card no is required.
b) If Nationality is non-Malaysia, Passport no is required.    

Sundry Expenses

Sundry Expenses is now made available ONLY if Malaysia GST setting is ON.  


Version 9.9.1.9     Release date:  19th January 2015 

Progressive Enhancements 

ECE Control Board

ECE Control Board will be shown if country setting is NOT Malaysia (MY), either in Accounting or Inventory & Billing.     

Major Industry Code

Major Industry Code setting is now made available ONLY if country setting is Malaysia (MY)   


Version 9.9.1.8     Release date:  16th January 2015 

Progressive Enhancements 

GST Wizard – Tax Code and Major Industry Code

You can now maintains the tax code to General Ledger Accounts in GST Wizard – General Ledger Accounts. Mapping the major industry code to the Item Group & individual items also made available in the GST Wizard, Item Maintenance and Group Maintenance as well.  

Important Note:

 Currently, mapping Tax Code and Major Industry Code is ONLY ready for setup purposes. Enhancement to the transactions entry screen for handling both of these functions will be made available in the next release.
 
Enhancement for the GST Return to properly display the amount with different major industry code will also made available in next release.   



Pricing Strategy – Inclusive and Exclusive handling

Tax-Inclusive and Tax- Exclusive handling for the transaction is now made available in Inventory & Billing. You can now set the option in Company Profile to apply in your business.  

Tax – inclusive 

Meaning: the amount of tax paid is already included in the base price Example: Product Price GST  Tax- Inclusive computation Selling Price  RM100.00 6%  RM94.34 + 5.66 = RM100.00 

Tax – exclusive 

Meaning: the amount of tax paid is on top of the base price 
Example: Product Price        GST      Tax- Inclusive computation     Selling Price  
                 RM100.00              6%            RM100 + 6.00                     = RM106.00  
 

Sundry Expenses – Goods and Service Tax Report & GST Audit File (GAF) 

Goods and Service Tax report & GST Audit File (GAF) is now enhanced to properly display the sundry expenses transaction.
  

Foreign Currency Tax Invoice, Credit Note & Debit Note 

New report template for foreign currency transaction is now made available in Invoice, Credit Note, Debit Note and Cash Sale entries screen.

 Simplified Tax Invoice

Simplified Tax Invoice is now made available in Cash Sale entry screen.   

 General Ledger Accounts

General Ledger Accounts in the GST Wizard is now change label name to GST – General Ledger Accounts.   

Sage Connect – On & Off

You can now enable or disable Sage Connect by clicking on [Sage Connect Status].   

Version 9.9.1.6 Release date: 09th December 2014

Progressive Enhancements

Sundry Expenses

You can now enter sundry expenses via the Payment entry screen.

For example, you made the payment of water, electricity and sewerage bills at POSMalaysia.Even though the payment is made to POS Malaysia but you can specify the supplier,invoice number, invoice date etc for each expense via the [GST details] button.


Goods and Service Tax report & GST Audit File (GAF) will be enhanced to properlydisplay the sundry expenses transaction in the next release.

Version 9.9.1.5      Release date: 09th December 2014

Progressive Enhancements

GST Dashboard – 21 Days Rule

New GST dashboard is now made available in Inventory & Billing system. It will display the list of un-invoice delivery orders and un-invoice goods receive note. You can select the delivery order / goods receive note and generate the respective invoice.

The GST Dashboard in Accounting has been enhanced to display the list on un-invoiced Delivery orders as well.


GST handling for un-invoice delivery orders more than 21 days in GST Return wizard with proper GST output tax reversal entries when an invoice is being issued will be made available in the next release.


Supplier Invoice, Supplier Invoice + GRN

Supplier Invoice entry screen has been enhanced to be able to update from GRN.
Supplier Invoice + GRN entry also has been enhanced to be able to update from Purchase Order.


Version 9.9.1.4     Release date: 20th November 2014

Progressive Enhancements

Tax Code Maintenance – Edit Button

Edit button is now made available in Tax Code Maintenance screen. With the Edit button, you can easily maintain all essential data elements such as Description of the Tax Code, Tax Percentage, Transaction Type, Tax Method, A/C No and Status of the Tax code.

Version 9.9.1.3     Release date: 10th November 2014

Progressive Enhancements

Post to Accounting – 1 step posting

Previously, you will need to manually export the transactions, after that import intoDaccount. For GST Audit file generation purpose, you will only need to export the billing dataand import into accounting as well.

Now, Sage UBS 2015 has been enhanced to consolidate all these functions into 1 stepposting.


Default User ID and Password

For 1st time installation, you may not know the default User ID and Password to login to thesystem.

Now, the default User ID and Password is shown on the login page. For security purpose, youare encourage to change the password after 1st time login.


Remember last login ID

Sage UBS 2015 has been enhanced to remember user last login ID. You will just need to clickon the MySageID /User Name field and a list of login ID will be shown for you to select.

Data Migration from previous version (9.1 to 9.9.0.x)

A new data migration function is made available in this version to help you to migrate datafrom previous version (9.1 to 9.9.0.x). Company setting and user login details will bemigrated as well.

If the Inventory & Billing data folder and Accounting data already linked, those data folderwill be auto linked after the data migration. If the If the Inventory & Billing data folder andAccounting data are not linked, you will be able to link them during data migration as well.


Data migration from version 8.x will be in the next phase.


Change Company Logo

“Update Logo” link is now made available in Select Company screen to provide you a faster way to change the company logo.

GST Setup Wizard

GST Made Simple – With the GST Setup Wizard, you easily maintain all essential data elements such as GL accounts, Tax Codes, Customer, Supplier, Item group and Item for proper GST reporting. 


Version 9.9.1.2     Release date: 15th October 2014

Progressive Enhancements

Remove GST Verification Report and GAF Verification Report

Currently, GST Verification Report and GAF Verification Report Menu is meant for Singapore users. Thus, remove both features from Malaysia GST Report menu.

Change Password Button

“Change Password” Button is now made available in user management screen to address the following requirements:1. Allow Administrator to change password for user.2. If Sage ID is not activated, show [Change Password] button for Administrator to change password.3. If Sage ID is activated, disable [Change Password] button and unable change password for the user.

Update from DO

Update from DO option is now enabled for user to link DO to the invoice.

Folder Directory Enhancement

This enhancement provides flexibility in allowing users to map different network drives to respective Accounting folder and Inventory & Billing folder. Now the information in Accounting and Inventory & Billing are able to be linked, even with both folders saved in different network locations. 

Version 9.9.1.1      Release date: 15th September 2014

Progressive Enhancements

Malaysia & Singapore GST – Only body discount & body tax

To fulfill the requirement of GST Audit file to display the taxable amount (after discount) and GST amount for every item line in the invoice / credit note / debit note, when Malaysia or Singapore GST is enabled, only body discount & body tax are available.

Version 9.9.1.0      Release date: 07th August 2014

Progressive Enhancements

Malaysia GST compliance

Sage UBS 2015 version 9.9.1.0 is compliance with Malaysia GST requirements. Please visit sageubs.sage.my for details.