No edit summary |
|||
Line 2: | Line 2: | ||
===Limitation & Precaution=== | ===Limitation & Precaution=== | ||
<ol> | <ol> | ||
<li>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.</li> | |||
<li>We will appreciate if you would report any issue encountered with the data imported with detailed information so we can improve the data import tool.</li> | |||
<li>No support for opening balance with foreign currency.</li> | <li>No support for opening balance with foreign currency.</li> | ||
* This is because UBS have two posting (1 local, 1 foreign) for foreign currency transaction and sometimes one of the posting might be missing. | * This is because UBS have two posting (1 local, 1 foreign) for foreign currency transaction and sometimes one of the posting might be missing. |
Revision as of 01:57, 9 October 2015
UBS
Limitation & Precaution
- 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 report any issue encountered with the data imported with detailed information so we can improve the data import tool.
- 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.
- 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
- Put the "Closing Period"
- DO NOT select the folder under the UBS database folder. E.g. "DATA2013"
- After select, tick which Opening document to import.
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.