UBSA1.62 : Access UBS (Accounting): How to Import & Export Master Records
Description
How to create new folder with the same chart of account only Environment
Access UBS (Accounting) Solution
Setup Import & Export:
- Go to Periodic, Export/Import and select E.I Housekeeping
- Set the destination: Sub-Directory For ***9.DBF & Sub-Directory For ***9.CSV
- Select Exit. This is how it looks like, please see example below:
Exporting the files: (from Source database, select company)
- Go to Periodic, Export/Import and select Export to DBF.
- To copy the chart of accounts, select COPY GLDATA.DBF TO GLDATA9.DBF and select OK to proceed.
- Select General Ledger Accounts, and select OK to proceed. (Other selection/filtering are optional)
- To copy the list of customers, select COPY ARCUST.DBF TO ARCUST9.DBF and select OK to proceed.
- Select the Debtor No. From and Debtor No. To, the other selection and filtering are optional.
- Select OK to proceed.
- To copy the list of suppliers, select COPY APVEND.DBF TO APVEND9.DBF and select OK to proceed.
- Select the Debtor No. From and Debtor No. To, (Other selection/filtering are optional)
- Select OK to proceed.
- Close the company database.
Importing the files: (to Target Database)
- Open destination or target Database from select company in UBS home page.
- Go to Periodic, Export/Import and select E.I Housekeeping (set the destination to import files)
- Set the destination: Sub-Directory For ***9.DBF & Sub-Directory For ***9.CSV
- Select Exit.
- Go to Periodic, Export/Import and select Import from DBF
- To import chart of accounts, select IMPORT FROM C:\EXPORT_IMPORT\GLDATA9.DBF and select OK to proceed.
- Repeat the same steps to import the rest of the records
- IMPORT FROM C:\EXPORT_IMPORT\ARCUST9.DBF
- IMPORT FROM C:\EXPORT_IMPORT\APVEND9.DBF
--Source from Access UBS --