web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Add a custom field in ...
Microsoft Dynamics AX (Archived)

Add a custom field in an existing POS database

(0) ShareShare
ReportReport
Posted on by TM-24070630-0

Hi everyone,

I am trying to add a custom field in an existing POS database following this description - I add a new script with incremented version number, the script is an embeded resource in CreateDatabase.dll, I modify the POSISUPGRADES.xml, place the recompiled DLL in the service folder of the Retail Database Utility and run the utility ... and nothing. The utility reports that "The retail POS configuration was updates successfully" but actually nothing has happened. The upgrade script is not run, the version in POSISINFO is not changed.

I am stuck. Any help or hint will be highly appreciated.

Tsanka

 

*This post is locked for comments

I have the same question (0)
  • Neeraj Chawla Profile Picture
    Neeraj Chawla 1,147 on at

    Can you explain this a little bit more...

  • TM-24070630-0 Profile Picture
    TM-24070630-0 on at

    Sure,

    I would like to add a new field to the existing local databases which current version is 6.3.0.0.

    The steps that I do are:

    • create a  new SQL file named Upgrade6.3.0.1.sql as embeded resource in the CreateDatabase project. The content of the sql file is an sql command for altering the ax.RetailTransactionTable and adding a column there.
    • modify the POSISUPGRADES.xml file by adding 

    <POSISUPGRADES>

    <UPGRADEVERSION>6.3.0.1</UPGRADEVERSION>
    <UPGRADESCRIPT>Upgrade6.3.0.1.sql</UPGRADESCRIPT>

    </POSISUPGRADES>

    • build the CreateDatabase.dll and place it in the service folder of the Retail Database Utility
    • run the Retail Database Utility in administrator mode and select the first option ("Configure Retail POS and ..."). 

    Following those steps I expected that the POS database would be updated to version 6.3.0.1 and my new field would be created. However this did not happen. May be I missing something very simple.

    It is interesting that if I create a new Retail Store, the update script from the CreateDatabase.dll is executed and my newly created local database has the new field and the new dbversion is correctly set to 6.3.01.

    Thank you

    Tsanka

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans