
Hello AX community,
I would like to consult you about a specific AX365FO Retail data migration issue.
Which would be the best approach, does someone have any experience on the subject.
Here is the case: We are deploying D365FO Retail and there is a legacy data migration part.
All of the sales orders from the current Retail system should be migrated and available on the new one (D365FO Retail). To be more precise, in every POS we should be able to find the history of all sales orders from the legacy system.
After technical analysis, I see that the mainly concerned tables are RETAILTRANSACTIONTABLE and RETAILTRANSACTIONSALES, they exist in DBO, AX, and CRT schemas. I understand partly how the CRT synchronization works, the data of these tables is sent from FO => Retail (P-0001 Job).
To import the legacy data, I was thinking about the following options:
Your opinions on the subject will be highly appreciated :-)
Thank you.
Kind regards,
Saso
Hello,
If anyone wonders, here is how I resolved this issue.
The following 2 native entities can be used to import the retail sales headers and lines :
With this, you will be able to see all of the retail transaction sales in the BackOffice.
In order to get the history on the POS side, the following function needs to be used :
As soon as you do that the sales orders history will appear on the POS side.
Hope that this can be of help to someone :-)
Kind regards,
Saso