15
Hi Experts,
I am just curious to understand what is the function of "Generate queries" under Retail and Commerce > Headquarters setup > Commerce scheduler.
*This is my first post in community so apology for any mistake in choosing the Forum*
We used to use this functionality in the legacy version(AX) of Dynamics when there was new distribution job being added. I am not sure if this is relevant, if you are not using (N-1) in D365.
Based on the data distribution definition (an XML file where you can define relationship between different tables ), the "Generate query" button will generate the X++ queries that will be used to define what all relevant data needs to be send to the channel DB. For example, even if you have 1000 products in your released products, only products in your assortments gets pushed in channel DB. This is actually taken care by Retail Data distribution definition.
You can refer my blog below, to understand how you can add additional filters to definition.
Hi Mr Karan Singh,
I haven't used this feature before, and I went to try to click on this button:
Scheduler jobs are the mechanism for distributing data to and from locations. Jobs are made up of subjobs, which specify the tables and table fields that contain the data to distribute.
So I think the "Generate queries" is to query the data that be sent to channels.
Anyone with other ideas can also explain here.
Best Regards,
Charlotte
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
