Data Import: Difference between revisions

From eStream Software
No edit summary
No edit summary
Line 12: Line 12:
<ol>
<ol>
<li>Insert season code.</li>
<li>Insert season code.</li>
<li>Import acc and stk as normal. Before import stk item, tick the 3 options at the bottom.</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 import sales & purchase price history, login to UBS and check the below thing.</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>
<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 | Edit B/F / O/I | Must tick mark all to O/I | exit

Revision as of 10:04, 3 November 2014

UBS

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