Skip to content
Microsoft Dynamics 365

POS hotfixes for AX for Retail 2010 R1 and R2 could include scripts to update the POS database.  To upgrade the POS database, please complete the following:

 1. Before installing the hotfix:

      a. Make a backup of your existing store database.

     b. In SQL Management Studio, view the current database version (DBversion) by running the follow SQL statement against the POS database: 

            select * from POSISINFO

  2. After installing the hotfix:

    a. Start Retail Database Utility (Start > All Programs > Microsoft Dynamics AX 2012 > Retail Database Utility > Retail Database Utility). In the configuration dialog box, enter information
into the Store database and Identification fields, and then click Continue.  This will execute the script, if available, to upgrade your database.

 

 

       b. In SQL Management Studio, view the current database version (DBversion) by running the follow SQL statement against the POS database and verify that the database version has changed:

               select * from POSISINFO    

 

 

We're always looking for feedback and would like to hear from you. Please head to the Dynamics 365 Community to start a discussion, ask questions, and tell us what you think!

Join the conversation

Loading comments...