No edit summary |
(→UBS) |
||
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> | ||
* 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> | <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> | </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> | ||
* Index All Files | |||
* Recover Data After Power Failure | |||
* Delete Unwanted Transactions | |||
</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> | ||
* Put the "Closing Period" | |||
<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:- | ||
* DO NOT select the folder under the UBS database folder. E.g. "DATA2014" | |||
* After select, tick which Opening document to import. | |||
<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
- 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
- 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 / 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
- Put the "Closing Period"
- DO NOT select the folder under the UBS database folder. E.g. "DATA2014"
- After select, tick which Opening document to import.