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) / Retail SDK Entity Sche...
Microsoft Dynamics AX (Archived)

Retail SDK Entity Schema Update

(0) ShareShare
ReportReport
Posted on by Mohammed Khatib 430

Hi,

I am new to Microsoft Dynamics AX Retail Development. I am working on Microsoft Dynamics AX 2012 R3 CU8, I have added multiple custom fields on the RetailTransactionTable to fetch more information from the POS Terminal for each transaction. I did the following:

1- Added the fields to RetailTransactionTable

2- Added the same fields to RetailTransactionTableT

3- Updated the Retail Channel Schema to map the new fields (Table & Temp Table)

4- Modified the RetailCDXChannelSpecificData_AX63 to Download and Upload the new fields

5- Altered ax.RetailTransactionTable  table and its View in POS local databases

6- Generated Incremental & Full CIL in Microsoft Dynamics AX

Just for testing, I had set a default value for these fields in the local database to see if the values will get sync to AX or not, and that worked as required; all values were in AX after I uploaded the transactions from all channels to AX (Distribution Schedule)

The problem here is that I am not able to see the attributes in Retail SDK for RetailTransaction or POSTransaction entities.

 

Please let me know if I am missing anything here.

Thanks.

Regards,

Khatib

*This post is locked for comments

I have the same question (0)
  • SergeyP Profile Picture
    SergeyP 2,928 on at

    So, you were able to see new columns in DB Tables in CRT Database, right?

    The attributes (I assume you meant C# properties) will not be autogenerated for you - you need to define them manually, but if you don't do that (you don't have to in fact) you could leverage ExentionsionProperties - the values you are looking for should be there, please look into this post  community.dynamics.com/.../478250

    it is AX7 specific but ExtensionProperties concept is also leveraged in the version you are using.

  • Oksana Kovaliova Profile Picture
    Oksana Kovaliova 3,597 on at

    Hi Mohammed,

    Are you customizing MPOS or ePOS?

    In case of MPOS you should use ExtensionProperties of data entity (Microsoft samples are good to have a look).
    In case of EPOS you can store new fields in PartnerData property of Transaction, while transaction object is in POS memory + save new fields to database in method SaveTransaction of class TransactionTriggers (in TransactionTriggers project from SDK).

    2016_2D00_04_2D00_26_5F00_22_2D00_42_2D00_05.png

    A bit more about PartnerData is here: blogs.msdn.microsoft.com/.../ax-for-retail-2012-r2-working-with-custom-fields-for-receipts

    Regards,
    Oksana

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