A2.112 : How to Migrate POS 3 Transactions to POS 5/F&B Database?

A2.112 : How to Migrate POS 3 Transactions to POS 5/F&B Database?

Question :

I have just upgraded from POS 3.1 to POS 5.0/FnB, but my front-end system does not have any POS 3.1 record. Can I migrate past transactions from POS 3.1 to POS 5.0/FnB?


Solution :

Yes you can.


For POS 3.0/3.1:

1. You must update to latest POS 3.1 rev: before do migrate to POS 5.0.

How to know my POS is latest revision ref below link:

https://wiki.autocountsoft.com/wiki/Category:AutoCount_Pos_3.1:_Release_Note


For POS 5.0:

1a. Go to Windows Start > AutoCount POS 5.0 > AutoCount POS 5.0 Database Configuration

000159-a.png


For FnB 5.0:

1b. Go to Windows Start > AutoCount FnB 5.0 > AutoCount FnB 5.0 Database Configuration

000159-b.png


2. Click on Tools > Migrate Database

000159-c.png


3. Define database > set Date Range > Find > Migrate

000159-d.png


Server Name: server IP address + SQL instance name (.\A2006 or (local)\A2006 if your POS 3 DB is on the same PC)

Database Name: Account book name (AED_32BIT_O)

Date Range: The range of transaction that you wish to import.


--Source from AutoCount Wiki --


    • Related Articles

    • A2.121 : How to create new database for POS/F&B system with existing database attached

      Question : How to create new database for POS/F&B system with existing database attached? Solution : For Pos 3 Go to Start Menu, click on Database Configuration under AutoCount Pos Folder alternatively you may find database configuration application ...

    • A2.126 : How to configure POS B attach POS A database

      Question : How to configure POS B attach POS A database? Solution : For Pos 3: You need to configure settings at POS B. Open AutoCount POS Database Configuration Alternatively you may find database configuration application at C:\Program Files ...

    • A2.2 : Allow to view Up To Date Cost in POS 5.0/F&B

      How to allow outlet sale team to view item up to date cost? Solution : 1. login POS 5.0 Back End > Point of Sale > Maintenance > POS User Maintenance 2.Double click the User > find out his user group > then click on Cancel 3.Go to Point of Sale > ...

    • A2.31 : How to remove outlet database from POS server monitor

      Question : I have one old outlet POS/F&B database which is no longer in use. How to remove ( delete / disappear it ) the old POS/F&B outlet database from my HQ location at my POS Server Monitor? Solution : 1. Open your POS Server Monitor then select ...

    • A2.125 : How to restore Frontend database on existing PC with POS

      Question : One of my cashier need to send for repair. How can I temporarily move all data to a backup PC? Solution : First of all, you need to have the latest backup file of existing company. Then go to the target machine (which POS/F&B software is ...