
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)