UBS

From eStream Software
Revision as of 01:58, 9 October 2015 by Yeoh Kok Seong (talk | contribs)

UBS

<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>
<pre>
===Limitation & Precaution===
<ol>
<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.
<li>Always import Price History first before AR/AP Opening Balance.</li>
* This is to avoid system from auto-delete AR/AP opening balance when importing Price History with same document number.
</ol>

===Housekeeping===
<ol>
<li>After UBS database is restored, run the following Housekeeping operation:-</li>
* Index All Files
* Recover Data After Power Failure
* Delete Unwanted Transactions
</ol>

===Preparing for Opening & Sales/Purchase Price History Import===
<ol>
<li>Insert season code.</li>
<li>Import account and stock as normal. Before importing stock item, check and tick any options at the bottom as needed.</li>
<li>Before importing Sales & Purchase Price History, login into UBS and perform the following steps:-</li>
* 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
<li>Repeat Step 3 for Creditor.</li>
<li>Please check with clients if they want to do UBS Account Year End Processing before importing Debtor or Creditor Opening Balance.</li>
<li>After that go Tools | Options and change the Financial Start Period and System Conversion Date if needed.</li>
<li>Now, run Sales and Purchase Price History (go into File | Data Import | UBS Stock).</li>
<li>After done Sales & Purchase Price History, log in to UBS go Housekeeping | Run Setup | General Setting.</li>
* Put the "Closing Period"
<li>Then, go to Periodic | Year End Closing.</li>
<li>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.
<li>Finally, run Tools | Analyse Data Integrity and backup.</li>
</ol>

===Import current Sales & Purchase Invoice (UBS Stock)===
<pre style="color: red; font-weight: bold">Coming soon: Transactions with GST

The following UBS Stock files are used for data import:

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

Steps

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