Create databases for retail stores (Retail essentials) [AX 2012]

Updated: July 18, 2014

Applies To: Microsoft Dynamics AX 2012 R3

This topic explains how to create and update retail store databases by using the Retail Store Database Utility. A store database can be created on either a shared database server or a point-of-sale (POS) register for offline use.

Prerequisites

Before you can create or update retail store databases, you must do the following:

Procedures in this topic

This topic contains the following sections:

Use the following procedure to create a store database on a shared database server. You can create only one store database for a store.

  1. On a stand-alone computer that is running SQL Server, click Start > All Programs > Microsoft Dynamics AX > Retail Channel Configuration Utility > Retail Channel Configuration Utility.

  2. Select Create channel database, and complete the information in the following fields:

    • Server name – Enter the name of the server on which to create the store database. Typically, you install the database on the local computer, or localhost.

    • Database name – Enter a unique name for the store database.

  3. Optional: Test the connection.

  4. Click Continue to create the store database.

Note Note

This procedure assumes that you are using the Retail Scheduler jobs that are included by default with Retail essentials. If you have modified those jobs or created additional jobs, you might have to modify those jobs accordingly.

After you create a new store database, and before you create offline databases for registers, you must add data from Retail essentials to the new store database.

To send data to the store database, do the following:

  • When you set up a new store database, run the job 9999 Full sync. This runs all jobs and ensures that all the data is sent to the stores. To avoid sending all data to all locations, you can temporarily modify the distribution schedule for the job, so that the data is sent only to the new location.

For more information about jobs, see Configure jobs and subjobs in Retail Scheduler (Retail essentials) and Schedule and run jobs in Retail Scheduler (Retail essentials).

Prerequisite: Before you can complete this procedure, you must create a store database and distribute initial data to it.

Use the following procedure to create an offline database on a point-of-sale (POS) register.

  1. On a POS computer, click Start > All Programs > Microsoft Dynamics AX 2012 > Retail Channel Configuration Utility > Retail Channel Configuration Utility.

  2. Select Create or reprovision the offline database, and then complete the information in the following fields:

    • Store ID – Enter the store ID. This value must be the same as the value that was entered for the store in the Name field of the Retail stores form. (Click Retail > Common > Retail channels > Retail stores.)

    • Under Channel database, enter the following information:

      • Server name – The name of the SQL Server instance that is hosting the store database.

      • Database name – The name of the store database.

    • Under Offline database, enter the following information:

      • Server name – The name of the SQL Server instance that is hosting the offline database.

      • Database name – The name of the offline database to be created or reprovisioned.

  3. Optional: Test the connection.

  4. Click Continue to create and configure the offline database.

  5. On the POS computer, start the Offline Sync Service, so that the offline database can be synchronized with the shared store database.

  6. To confirm that the offline database was created correctly, and that synchronization is working, verify that tracking tables have been added to the store database. Tracking tables are copies of tables that have the suffix _tracking. If tracking tables have been added, the store database has been provisioned for synchronization. To make sure that the synchronization service is running, see the RetailOfflineSyncLog table in the store database.

  7. When you troubleshoot database synchronization and offline databases, make sure that the user who creates and synchronizes databases has sufficient permissions on the store server and on the SQL Server instance where the offline database is created.

Before you can complete this procedure, you must create an offline database. The sync service is used to synchronize the offline database with the store database.

To configure Retail POS and Retail Offline Sync Service, follow these steps:

  1. On a POS computer, click Start > All Programs > Microsoft Dynamics AX 2012 > Retail Channel Configuration Utility > Retail Channel Configuration Utility.

  2. Select Configure Retail POS and Retail Offline Sync Service, and then complete the information in the following fields:

    • Store ID – Type the store ID. This value must be the same as the value that was entered for the store in the Name field of the Retail stores form. (Click Retail > Common > Retail channels > Retail stores.)

    • Register ID – The ID of the local POS register that is being configured.

    • Legal entity – The legal entity that the store belongs to.

    • Under Channel database, enter the following information:

      • Server name – The name of the SQL Server instance that is hosting the store database.

      • Database name – The name of the store database.

  3. Optional: Test the connection.

  4. Click Continue to create and configure POS and the offline sync service.

  5. On the POS computer, start the Offline Sync Service, so that the offline database can be synchronized with the shared store database.

  6. To confirm that the offline database was created correctly, and that synchronization is working, verify that tracking tables have been added to the store database. Tracking tables are copies of tables that have the suffix _tracking. If tracking tables have been added, the store database has been provisioned for synchronization. To make sure that the synchronization service is running, see the RetailOfflineSyncLog table in the store database.

  7. When you troubleshoot database synchronization and offline databases, make sure that the user who creates and synchronizes databases has sufficient permissions on the store server and on the SQL Server instance where the offline database is created.

If the store database becomes unavailable, POS registers can connect to a local offline database and continue performing transactions. Therefore, offline databases on POS registers must be synchronized with the latest data from the store database.

Offline profiles define which data is synchronized from the store database to the offline databases on POS registers. Each offline profile consists of several offline scopes. The default scopes are modeled after the Retail Scheduler jobs that are used to synchronize data between Retail essentials and the stores. For example, the 1080 scheduler job pushes tax-related information from Retail essentials to the stores. The tables that are included in the 1080 scheduler job are also included in the offline scope that pushes tax-related information from the store database to the offline database.

For more information about offline scopes and offline profiles, see Set up offline profiles (Retail essentials).

The following sections describe the transactions that you can and can’t complete when a POS register is in offline mode.

If a POS register has an offline database, you can complete the following operations when the store database is offline:

  • Generate a sales transaction.

  • Recall an unfinished transaction, if the transaction was initiated during the current offline session.

  • Void an item.

  • Void a payment.

  • Void a transaction, if the transaction was initiated during the current offline session.

  • Perform blank operations.

  • Complete a return transaction, under specific circumstances. The following table shows when an offline return transaction can be completed.

    Mode of database when the original transaction was generated

    Current mode of database

    Return allowed

    Offline

    Offline

    Yes, if the original transaction was completed during the current offline session

    Offline

    Online

    Yes

    Online

    Offline

    No

    Online

    Online

    Yes

You can’t complete the following operations when the store database is offline:

  • Print an X report

  • Print a Z report

  • Close a shift

  • Blind-close a shift

  • View blind-closed shifts

  • Suspend a shift

A register will go offline if the system is temporarily down or if the store database is unavailable. When the connection with the store database is lost, Retail POS automatically switches to the offline database. The connection status is displayed on the status bar.

ImportantImportant

If a transaction is in progress when the connection is lost, you must void the transaction, and then start a new transaction that uses the offline database.

When the store database becomes available again, you must use the Database connection status operation in Retail POS to reestablish the connection with the store database.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).
Show: