Data Import: Difference between revisions

From eStream Software
No edit summary
No edit summary
Line 1: Line 1:
==UBS==
==UBS==
===House Keeping===
===Housekeeping===
<ol>
<ol>
<li>After restore UBS database do the following Housekeeping:-</li>
<li>After UBS database is restored do the following Housekeeping:-</li>
   <ul>
   <ul>
     <li>Index All Files</li>
     <li>Index All Files</li>

Revision as of 10:00, 3 November 2014

UBS

Housekeeping

  1. After UBS database is restored do the following Housekeeping:-
  • Index All Files
  • Recover Data After Power Failure
  • Delete Unwanted Transactions

Preparing for Opening & Sales/Purchase Price History

  1. Insert season code.
  2. Import acc and stk as normal. Before import stk item, tick the 3 options at the bottom.
  3. Before import sales & purchase price history, login to UBS and check the below thing.
  4. Step to check before do import opening or sales & purchase price history.
  • 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 on CREDITOR.
  • After that go Tool | Option and insert financial start period and system conversion date.
  • Go run sales and purchase price history (go into SQL | Acc Stock(UBS) | Historical Transaction).
  • After done sales & purchase price history, log in to UBS go Housekeeping | Run Setup | General Setting.
  • > put closing period
  • Then go Periodic | Year End Closing.
  • 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.
  • Finally, after done the above steps, run analyse, copy company profile from UBS to SQL and backup.