Data Import

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.