Tuesday, May 26, 2015

UBS System E-learning

In this section, you will learn how to setup & maintain Sage UBS : 
  1. Location to download the installer and steps to install the system. 
  2. Setting up client-server environment (if need to). 
  3. Activate license, deactivate license, reactivate license. 
  4. Backup data & restore data. 
  5. Create new user and assign the access rights. 
  6. Understand how online update works. 
  7. Migrate data from lower version of Sage UBS (version 9.1 and above).  

I would like to download the installer and install the system


I would like to activate license / deactivate & reactivate license


I would like to learn how to link client PC to server
 


I would like to backup / restore data
 


I would like to add new user / update user profile / assign user access rights


I would like to understand how to get my system updated


I would like migrate data from lower version of Sage UBS (9.1 and above)    
 

Wednesday, April 15, 2015

Release Notes for Sage UBS

Content This release notes covers the Progressive Enhancement for Sage UBS

Version 9.9.2.1      Release date: 20th May 2015 

Progressive Enhancements  

Inventory & Billing - Validation of Tax Code 

GST Classification is now enhanced to have checking based on different transaction type. For example, system is not allowed to proceed when you select PURCHSE tax code in SALES transaction, either key in manually or select from the list. 


Taxable Amount

Taxable amount of a transaction with same reference number but different SALES GL Account is now can be sum into same line and show in GST Report. 


GST Dash Board – Current Taxable Period 

Current Taxable period will be updated to next period after click on [Save as new version] button in GST Return
 Note: 
Current taxable period will only be updated for every first version saved for GST submission for the particular taxable period.


Journal Description

Journal Description in TFM is now enhanced to follow the transaction description in Inventory & billing. 
 Inventory and Billing:



Accounting:


User Access Right – GST Report 

You now can set the user right for accessing GST Report screen. With this enhancement, GST Report can be prevented from viewing by unauthorized person. 


Inventory & Billing – GST Classification

GST Classification is now disabled from Transfer, Adjustment – Increase and Adjustment – Decrease entry screen.


GST Audit File 

S line of the Sales transaction in Transaction File Maintenance is now can be shown in GAF.

GST Bad Debt Journal (AR) and GST Bad Debt Journal (AP)

GST Bad Debt Journal (AR) and GST Bad Debt Journal (AP) entry screen is now available in SageUBS Accounting One license.  

Version 9.9.2.0     Release date: 13th May 2015

Progressive Enhancements  

Print Control

 The print control feature is meant to help you to have a better control of your business source documents at different stages.
 

 When the transaction is still open for editing, you can choose to preview for checking purpose.

When the transaction is finalized and confirmed, you can choose to final print the document. A final-print document is no longer editable. Adjustments must be made via the issuance of a credit note or a debit note.

Once a document is on final-print status, subsequent reprint will have “Duplicate” watermark

This new enhancement only available in entries screen below: 

  1. Invoice
  2. Cash Sale
  3. Sale Credit Note
  4. Sale Debit Note 

Auto populate tax code in Transaction File Maintenance 

You can now map tax code to GL account, either in GST Wizard or General Ledger Maintenance. When creating new transaction, tax code will be populated automatically based on the mapping you have done. For example, map tax code “TX” to EXPENSES GL account. When creating new transaction by using Quick entry, tax code “TX” will be populated automatically when the selected subaccount is EXPENSES. 


GST-03 – Part C: Major Industry Code

New green button is added for user to click in to view the transactions contributed to the amount.

Consistency Update Program – Date Range

Consistency Update Program is now enhanced to key any date range instead of the start date must be greater than 01/04/2015 
Note: 
System can ONLY fix those transaction which are posted from 01 April 2015 onwards  

GST Detail – Company Registration Number & GST Registration Number 

Company Registration Number & GST Registration Number is now change to nonmandatory field in GST Details screen. Changes had been made in entries screen below: 
  1. Transaction File Maintenance 
  2. Sundry Expenses 
  3. Sundry Expenses Accrual 

Inventory & Billing - Discount amount field

Discount amount field will be disable IF 3 level discount setting is enabled. 
Setting:


Entry Screen:

Version 9.9.1.24      Release date: 07th May 2015

Progressive Enhancements 

Improvement on Quick Entry

  1. Auto populate Purchase tax / Sales tax GL account
    • Sales or Debtor GL is selected at master account --> Sales Tax GL will be auto populate
    • Purchase, Expenses or Creditor GL is selected at master account --> Purchase Tax GL will be auto populated
  2. Auto populate Tax codes based on the default Supply tax code and Purchase tax code set at Administrative Tools > Setting 3  Auto populate
     
  3. Taxable Sales / Taxable Purchase amount
  4. Auto populate the Bill Type
  5. No GST Classification for Debtor / Creditor / Bank / Cash GL 
  6. [Tax yet to be added] renamed as [GST Exclusive] 
  7. GST Classification – only active Tax codes are shown 

 Improvement in Transaction File Maintenance

  1. Major industry code field will be shown at Output Tax GL only 
  2. No GST Classification for Debtor / Creditor / Bank / Cash GL 
  3. [Tax yet to be added] renamed as [GST Exclusive 
  4. GST Classification –only active Tax codes are shown  

 Knowledge base for GST related transactions entry via Transaction File Maintenance 

To ensure correct production of GST-03 and GST report, you will need to make the transactions are entered in the correct way in Transaction File maintenance. Please refer to this article for more details. 
http://knowledge.sage.my/index.php?/article/AA-05617/0/Sage-UBS-Transaction-FileMaintenance.htm 

GST Return – Part C: Additional Information 

Edit button will be enabled IF there is Output Tax value in “Other” field. With this enhancement, you can assign the output tax value to respective Major Industry code if you did not set it during transaction entry.

Data Recovery

Data Recovery tool is now enhanced to recalculate the incorrect tax amount for the transaction which linked from POS to Inventory & Billing.

GST Wizard – GST General Ledger Accounts

System is now allow you to re-map GST General Ledger Accounts (as image below) when click on the    buton for those accounts which:  
  1.  The Account field is EMPTY
  2. The Account field is 0000/000


Goods and Service Tax Report

New filtering is now enabled at Goods and Service Tax Report screen as image below

File Organisation

There should be no GST tax code link to debtor, creditor, bank and cash GL in the transaction file maintenance. So, instead removing the tax codes manually for history data, a new function - [Clean up tax code for debtor\creditor\bank\cash] is added in the File Organisation to help you to clean up the GST tax codes linked to debtor, creditor, bank and cash GL.

 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