|
|
| (15 intermediate revisions by 3 users not shown) |
| Line 1: |
Line 1: |
| ==UBS==
| | * [[UBS]] |
| ===Limitation & Precaution===
| | * [[EMAS]] |
| <ol>
| | * [[MYOB]] |
| <li>No support for opening balance with foreign currency.</li>
| | * Others [[Customisation]] |
| <ul>
| |
| <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>
| |
| <ul>
| |
| <li>This is to avoid system from auto-delete AR/AP opening balance when importing Price History with same document number.</li>
| |
| </ul>
| |
| </ol>
| |
| | |
| ===Housekeeping===
| |
| <ol>
| |
| <li>After UBS database is restored, run the following Housekeeping operation:-</li>
| |
| <ul>
| |
| <li>Index All Files</li>
| |
| <li>Recover Data After Power Failure</li>
| |
| <li>Delete Unwanted Transactions</li>
| |
| </ul>
| |
| </ol>
| |
| | |
| ===Preparing for Opening & Sales/Purchase Price History===
| |
| <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 / 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
| |
| <li>Repeat step 1 to 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 Tool | Option 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>
| |
| <ul>
| |
| <li>> put closing period</li>
| |
| </ul>
| |
| <li>Then, go to Periodic | Year End Closing.</li>
| |
| <li>After done the above step | go back go SQL | click IMPORT UBS ACCOUNT, then select database, you will realize then got another folder under "database name".
| |
| * DO NOT select the folder under "database name". | |
| * After select folder, press on keyboard "CTRL + L " then tick 1 by 1.</li> | |
| <li>Finally, after done the above steps, run analyse, copy company profile from UBS to SQL and backup.</li>
| |
| </ol>
| |
