Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • TM-24070630-0 Profile Picture
    TM-24070630-0 on at
    RE: Add a custom field in an existing POS database

    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

  • Neeraj Chawla Profile Picture
    Neeraj Chawla 1,147 on at
    RE: Add a custom field in an existing POS database

    Can you explain this a little bit more...

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans