1,858
Hi,
I have 3 months transactions in AX 2012 R3, I want to move them to D365 Commerce.
What entities are available for this in D365 Commerce?
I want to migrate the transactions store wise.
Appreciate any tips.
Best Regards,
Either you can import the retail transactions as it is using Retail store transaction entities and then run retail statement posting. This requires data import into multiple tables and the data on different tables should be matching. If there is any mismatch in data, the retail statement posting will fail.
List of entities you can use:
If your motive is just to update the on hand, you can import them as sales order (by day, week or month) and invoice them. For batch numbers, you can try setting the inventory model group to FEFO.
To enable the Retail Sale checkbox, you need to some required data in the RetailSalesTable
One more thing that I found out is that, there is P-Job that keep the records in Store and HO in sync.
So even if there's a way to create a retail sales order directly in HO, it will have a next sequence number which will be in conflict when the P-job tries to sync the next sequence from store, because both might be same.
Hello Ramune
Yes, just the Retail Store.
There's a "Retail Sale" check box in Sales Order Header. It's a display method so won't be available in data entity. Perhaps with a customization it will work?
The objective here is to post all the transactions from previous months and decrease the On-Hand quantities in D365 FO (Because On-Hand has been uploaded which is causing item count confusion). And there's another catch there because the On hand quantities in D365 FO has automatic batch numbers. Though I can reduce the quantity properly from the Store warehouse. What shall I do regarding the batch numbers?
I am new to D365 Commerce so trying to find as much info on this as I can before I do a test run on UAT.
Appreciate any tips.
Best Regards,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (