Data Import: Difference between revisions

From eStream Software
No edit summary
Line 3: Line 3:
<ol>
<ol>
<li>No support for opening balance with foreign currency.</li>
<li>No support for opening balance with foreign currency.</li>
  <ul>
* 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>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>
  </ul>
<li>Always import Price History first before AR/AP Opening Balance.</li>
<li>Always import Price History first before AR/AP Opening Balance.</li>
  <ul>
* This is to avoid system from auto-delete AR/AP opening balance when importing Price History with same document number.
    <li>This is to avoid system from auto-delete AR/AP opening balance when importing Price History with same document number.</li>
  </ul>
</ol>
</ol>


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


Line 35: Line 29:
<li>Now, run Sales and Purchase Price History (go into File | Data Import | UBS Stock).</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>
<li>After done Sales & Purchase Price History, log in to UBS go Housekeeping | Run Setup | General Setting.</li>
  <ul>
* Put the "Closing Period"
    <li>Put the "Closing Period"</li>
  </ul>
<li>Then, go to Periodic | Year End Closing.</li>
<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:-
<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:-
  <ul>
* DO NOT select the folder under the UBS database folder. E.g. "DATA2014"
    <li>DO NOT select the folder under the UBS database folder. E.g. "DATA2014"</li>
* After select, tick which Opening document to import.
    <li>After select, tick which Opening document to import.</li>
  </ul>
<li>Finally, run Tools | Analyse Data Integrity and backup.</li>
<li>Finally, run Tools | Analyse Data Integrity and backup.</li>
</ol>
</ol>

Revision as of 09:31, 7 November 2014

UBS

Limitation & Precaution

  1. 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

    1. 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

    1. Insert season code.
    2. Import account and stock as normal. Before importing stock item, check and tick any options at the bottom as needed.
    3. Before importing Sales & Purchase Price History, login into UBS and perform the following steps:-
    • Transaction | Open Item Debtor | Edit B/F / O/I | Must tick mark all to O/I | exit
    • Transaction | Open Item Debtor | Maintain B/F | Click on List ( if got transaction exit the list tick generate)
    • Transaction | Bill Payment | List Missing at arpost | if got list have to press ok if not press exit
  • Repeat step 1 to 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 Tool | Option 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. "DATA2014"
    • After select, tick which Opening document to import.
  • Finally, run Tools | Analyse Data Integrity and backup.