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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Subjob for custom ax table to custom POS table not pushing data from job

(0) ShareShare
ReportReport
Posted on by

Hello, 

I'd like to push data from an AX custom table to a POS custom table by a subjob to job 1030 in my D365 VM.

I've tested the distribution schedule by changing some data and running job 1030 to ensure that jobs can be executed.  This works. 

I've followed a few posts that are originally for AX2012 along with https://docs.microsoft.com/en-us/dynamics365/unified-operations/retail/dev-itpro/add-customer-preference-channel as my main reference to do this. 

The custom table is very simple:  Code, Description. 

There is data in this custom table in AX.  The POS table also has this table created and security permissions given to DataSyncUsersRole.

Created channel table for the custom table and then used that for the scheduler subjob where I mapped the fields.

I'm not sure about the next steps now.  In the link the instructions say to export the RetailTableDistributionXML file and add the customer preference table. 

Since mine is a custom table I did this and put it at the end of the XML file.  I'm not sure this if this is correct.

...... [Scroll all the way to the end of the XML]

<Table name="MyCustomTable">
<LinkGroup>
<Link type="FieldMatch" fieldName="Code" parentFieldName="Code" />
</LinkGroup>
</Table>
</RetailDataDistribution>

I then imported the XML back and the hit the generate queries button just like the link says.

At this point I am assuming that I can go to distribution schedule and run job 1030. 

The data did not get imported to the POS table. 

I'm not sure what i may have missed in my steps.  Or if I did the incorrect XML. 

Any suggestions or recommendations? 

thanks

*This post is locked for comments

I have the same question (0)
  • Omar Iqbal Profile Picture
    75 on at

    Have you resolved this problem ?

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…

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