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. 

Thursday, April 09, 2015

Sage BSM 2015 Launched

Sage BSM 2015 is launched supporting the latest GST requirements. New Features were applied  to Building Services Maintenance in order to meet the demand of GST 2015. However, New Features  of BSM includes:

  • Support Malaysian GST Tax Codes.
  • Support of default Inclusive or Exclusive Pricing method.
  • Support for Full Tax Invoice.
  • Support for Sage Smart GST. Map default tax code to Charges, Expenses and Late Charge.


  • Support for Online Update for continuous updates with GST changes over time.
  • Support Online License Activation.
  • Support for posting to Sage UBS to complete the GAF and GST-03. Posting are by each invoice details and not a summary posting.

Thursday, April 02, 2015

Sage UBS 2015 - Housekeeping in progress, not allow to proceed

Encounter the message “Housekeeping in Progress” message when accessing Sage UBS

Click on the refresh button at the select application screen, after that you should be able to access the system normally.
Note: This fix is only available from Sage UBS 2015 version 9.9.1.14 onwards.

Wednesday, April 01, 2015

UBS Utility

Some utility functions in UBS system will be learned in this section 
  1. Enter journal entry via quick entry. 
  2. Maintain and process recurring journal entries 
  3. Recode master data codes. 
  4. Maintain and apply user-defined fields. 
  5. Customize report templates. 
  6. How to check out & check in mobile license. 
  7. How to set up connected services. 



I would like to enter journal entries via quick entry


I have entries that repeat every month, e.g. asset depreciation journal entry, I would like to maintain recurring journal entries
 


I would like to change the code of come master data, e.g. GL account, Item, Supplier, Customer etc
 


 I need extra informations on my billing, I would like to use user-defined fields to enter those extra information


I would like to customized some document template, e.g. order, invoice etc to suite my business


I need to work outside the office, I need to install mobile license into my mobile workstation


I would like to receive updates on business via SMS, email etc using connected services
      

Tuesday, March 17, 2015

E-learninig on UBS Inventory

Record the key steps in the inventory management will be learned in this section
  1. Add / Update item.
  2. Add / Update location
  3. Understand various costing methods available in the system.
  4. Enter opening stock.
  5. Perform inventory adjustment, inventory transfer & inventory issue.
  6. Enter item assembly.
  7. Learn how to keep track inventory movement, inventory aging etc.

I would like to add new item / update existing item
 


I would like to add new location / update existing location 
 


 I would like to understand various costing methods available and set it up accordingly


I would like to enter opening stock


I found descrepancy between the quantity in the system and my physical stock, I would like to make inventory adjustment
 


I would like to issue out goods for internal use, for display purpose, loan item to staff etc.
 

  
   I would like to perform the production of assembly goods.
 


I would like to keep track of my inventory movement, inventory aging etc

Monday, March 16, 2015

Banking & Cash flow E-learning

Record the key steps in the banking & cash flow will be explained in this section
  1. Maintain bank / cash / credit card account.
  2. Explore the banking task flow.
  3. Enter sundry expenses transaction via payment entry.
  4. Enter fund transfer & reimbursement transaction.
  5. Enter payment & print cheque.
  6. Perform bank reconciliation.
I would like to add new bank / cash / credit card account or update existing bank / cash / credit card account


I would like to manage my cash flow via the banking task flow 


I would like to enter sundry expenses and payment transaction


I would like to transfer cash from bank to cash or cash to bank, as well as bank to bank


I would like to enter payment & print cheque


I would like to match the transactions in system against my bank statement via the bank reconciliation





Wednesday, March 11, 2015

SAGE UBS Customer & Sales

Record the key steps in the sales cycle will be explained in this section,

  1. Maintain customer profile.
  2. Maintain sales control, such as allow / not allow zero price, allow / not allow selling above credit limit etc.
  3. Issue quotation to customer and record a sales order from customer.
  4. Create delivery order for goods delivery and record a return when customer returned the goods
  5. Issue invoices and make adjustments via credit note and debit note.
  6. Enter receipt transaction when customer make payment. Create prepayment entry when you collect advance payment from customer.
  7. How to claim back the output tax if customer outstanding is more than 6 months and how to return the output tax to JKDM when customer settled the outstanding.
I would like to add new customer or update existing customer Profile


I would like to setup sales control in the system


My customer asked for a quotation


I received an order from my customer


I collect payment in advance from my customer


I would like to fulfil my customer’s order / My customer returned faulty goods


I would like to issue an invoice to my customer / I would like to make adjustment using credit note or debit note


My customer made payment


My customer’s outstanding is more than 6 months, now I want to claim back the output tax that I have paid