Data Import: Difference between revisions

From eStream Software
No edit summary
 
(16 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>
<li>Step to check before do import opening or sales & purchase price history.</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 on CREDITOR.</li>
<li>After that go Tool | Option and insert financial start period and system conversion date.</li>
<li>Go run sales and purchase price history (go into SQL | Acc Stock(UBS) | Historical Transaction).</li>
<li>After done sales & purchase price history, log in to UBS go Housekeeping | Run Setup | General Setting.</li>
> put closing period
<li>Then go 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>

Latest revision as of 01:37, 9 October 2015