AX2012 new field on InventTable is breaking the Replication of data to POS

(1) Share

Report

Posted on by Sophs@4Sight

161

Good day I am not sure this is the correct place, but I have an AX 2012 R3 question as I still have clients using this.

I added an indicator (YesNo) field to InventTable.

I then also added the field to the form EcoResProductDetailsExtended. I added this field to the user layer as this is a short term solution. (Busy upgrading to D365 FnO)

I teted and everything was fine. However when we deployed this change to Production (Live), the replication to their POS broke and the InventTable (N-1040) was cleared out.

So this meant that no Products could be seen on any of the POS tills.

Is there a step that I missed because this table is one of the tables being replicated?

Is it possibly because I added the field on the user layer?

Please can anyone assist.

Categories:

Microsoft Dynamics AX

All responses (4)

Answers (0)

André Arnaud de Cal... 294,118 Super User 2025 Season 1 on at

Like (0)

Report

AX2012 new field on InventTable is breaking the Replication of data to POS

Hi Sophs,

The deployment process to directly add the field in a production environment is wrong. Best practice would be preparing a full compiled and CIL built solution and move the model store from a sandbox to the production environment. Then a synchronization of the database.

Anyway, adding the field, even in the USR layer would most likely not impact the POS distribution. As this might be something specific to your environment, probably you can reach out to the POS vendor or the partner that was helping with the integration.
Sophs@4Sight 161 on at

Like (0)

Report

AX2012 new field on InventTable is breaking the Replication of data to POS

Thank you for your responses.

As this is a very temporary solution, I only made the change on the usr layer. And imported my project. Compiled and synchronised the table / form and restarted the AOS.

The changes deployed was only a EDT (extending YesNO) and InventTable with New field and EcoResProductDetailsExtended, with field added.

I did not test the impact on the POS distribution in the Test environment, as I was not aware that it would be impacted.

Do you think it could be because it was deployed on the USR layer.

The distribution ran after my deployment.

Also when we removed my changes and ran the distibution jobs again all the InventTable had the data again.

Kind regards
André Arnaud de Cal... 294,118 Super User 2025 Season 1 on at

Like (0)

Report

AX2012 new field on InventTable is breaking the Replication of data to POS

HI Sophs,

I do agree with Jonas that adding a field should not break an integration. Was this the only change or were multiple customizations deployed to production? Having this field in a non-production environment is not causing this error? Have you tested this before moving to production?
Jonas "Jones" Melgaard 3,435 Super User 2025 Season 1 on at

Like (1)

Report

AX2012 new field on InventTable is breaking the Replication of data to POS

Adding a field to InventTable should not break the distribution jobs.

When did the distribution jobs run, and can you see any errors in the batch history for them?

I'm also thinking.... How did you deploy this change to PROD.

Full-on model store deployment with full CIL generation?

Community site session details

AX2012 new field on InventTable is breaking the Replication of data to POS

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Jonas ”Jones” Melgaard – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

AX2012 new field on InventTable is breaking the Replication of data to POS

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Jonas ”Jones” Melgaard – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates