Migrate transactions from AX 2012 R3 retail to D365 Commerce

(1) Share

Report

Posted on by MYGz

2,162

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,

I have the same question (0)

All responses (4)

Answers (1)

Ramune on at

Like (0)

Report

Hi,

what kind of transactions you would like to migrate? Retails store transactions or something else?

Was this reply helpful? Yes No
MYGz 2,162 on at

Like (0)

Report

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,

Was this reply helpful? Yes No
MYGz 2,162 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Shafeeque P. 6,533 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No