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

Announcements

Introducing our New Video Series: Community Spotlight
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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans