UBS

Notes

Please double check all data imported into SQL Accounting from UBS.
Data might not be 100% accurate because the tool imports direct from UBS database instead of through the UBS software.
We will appreciate if you would help report any issue encountered with detailed information so we can improve the data import tool.

Limitation & Precaution

No support for opening balance with foreign currency.

This is because UBS have two posting (1 local, 1 foreign) for foreign currency transaction and sometimes one of the posting might be missing.

Always import Price History first before AR/AP Opening Balance.

This is to avoid system from auto-delete AR/AP opening balance when importing Price History with same document number.

Housekeeping

After UBS database is restored, run the following Housekeeping operation:-

Index All Files
Recover Data After Power Failure
Delete Unwanted Transactions

Preparing for Opening & Sales/Purchase Price History Import

Insert season code.
Import account and stock as normal. Before importing stock item, check and tick any options at the bottom as needed.
Before importing Sales & Purchase Price History, login into UBS and perform the following steps:-

Transaction | Open Item Debtor | Edit B/F or O/I | Must tick mark all to O/I | Exit
Transaction | Open Item Debtor | Maintain B/F Bills | Click "List" (Exit "List" and click "Generate" if there are transactions)
Transaction | Open Item Debtor | Bill Payment Ledger | List Missing Records in Arpost.DBF | Press OK if there are items in the list or press Exit if non

Repeat Step 3 for Creditor.

Please check with clients if they want to do UBS Account Year End Processing before importing Debtor or Creditor Opening Balance.

After that go Tools | Options and change the Financial Start Period and System Conversion Date if needed.

Now, run Sales and Purchase Price History (go into File | Data Import | UBS Stock).

After done Sales & Purchase Price History, log in to UBS go Housekeeping | Run Setup | General Setting.

Put the "Closing Period"

Then, go to Periodic | Year End Closing.

After done the above steps, go back go File | Data Import | UBS Account, then select the UBS database folder. Beware of the following when selecting UBS database folder:-

DO NOT select the folder under the UBS database folder. E.g. "DATA2013"
After select, tick which Opening document to import.

Finally, run Tools | Analyse Data Integrity and backup.

Import current Sales & Purchase Invoice (UBS Stock)

Coming soon: Transactions with GST

The following UBS Stock files are used for data import:

MASTER > artran.dbf
DETAIL > ictran.dbf

Please follow step 1 to 6 as described in 1.3 Preparing for Opening & Sales/Purchase Price History Import above.
Make sure all the GL accounts (most importantly Sales & Purchase account) in Stock | Maintain Stock Group is assigned and valid.
Make sure all the default GL accounts in Tools | Options | General Ledger is also valid.
Now, go to File | Data Import | UBS Stock, select the UBS Stock DB folder and press Connect.
Tick Stock Item | Current Transaction - Sales Invoice and/or Purchase Invoice check-box.
[Recommended] Go to Tools | Options | Miscellaneous, untick "Prompt Negative Stock Quantity Dialog Box"
Select any applicable options and then click Execute to start import.
Finally, run Tools | Analyse Data Integrity and backup.

Steps

http://www.sql.com.my/document/Import%20UBS%20Guides.pdf