Finance | Project Operations, Human Resources, ...

On - Hand Inventory Dual write Integration

(0) Share

Report

Posted on by Sindhu_rk

Hi all,

Integration between on-hand information (F&O) - Product Inventory(CE) using Dual-write.
only Virtual tables are enabled in CE(inventoryonhandrequests) & (inventoryonhandentries) shown below.
But It need to sync from On-hand information(F&O -----> CE)Product Inventory in standard table not in virtual table is shown below.

Note: onhand inventory In F&O should sync with product inventory in CE. Our scenerio.

Kindly guide us to achieve this on Custom Dual-write / another method.

Thanks In Advance!

Regards,
Sindhu.

All responses (13)

Answers (0)

André Arnaud de Cal... 291,971 Super User 2025 Season 1 on at

Like (0)

Report

RE: On - Hand Inventory Dual write Integration

Hi Sindhu,

The add-in in syncing on-hand information; not product master data. Some fields in F&O are calculated columns. On the CE side, you can also perform calculations to get e.g. a Total available quantity.

When you have other applications which also has on-hand information for the same products, the total available calculation would require to take more columns into consideration.

I haven't looked myself at the Preload inventory availability summary yet. You can find some information on Microsoft Learn: Inventory Visibility app - Supply Chain Management | Dynamics 365 | Microsoft Learn
Sindhu_rk 80 on at

Like (0)

Report

RE: On - Hand Inventory Dual write Integration

Hi Andre,

Thank you for guiding me,

I have enabled the Inventory availability add-in in CE side. But some data is not flows in CE side but it is in FO side,
SHOWN BELOW and Here where is TotalQuantity and Product name in CE side?

How to enable all the data in FO to CE ?

What is the difference between Inventory Summary & Preload Inventory availability summary ?

Could you help me to solve this.

Thanks,
Sindhu.
Suggested answer

André Arnaud de Cal... 291,971 Super User 2025 Season 1 on at

Like (0)

Report

RE: On - Hand Inventory Dual write Integration

Hi Sindhu,

The list shows some technical names. The warehouse information is technically stored in the table InventLocation, so the Location ID is the warehouse. The field WMSLocation ID is the location.
Sindhu_rk 80 on at

Like (0)

Report

RE: On - Hand Inventory Dual write Integration

HI Andre,

Thanks for the reply!

Using Inventory visibility Add-in is Warehouse ID or Name get sync between FO---> CE?

i cant see warehouse id or name in CE is shown below.

Could guide me how to get warehouses in CE.

Thanks,
Sindhu
André Arnaud de Cal... 291,971 Super User 2025 Season 1 on at

Like (0)

Report

RE: On - Hand Inventory Dual write Integration

Hi Sindhu,

I would suggest reviewing the installation with help of the documentation. Install the Inventory Visibility Add-in - Supply Chain Management | Dynamics 365 | Microsoft Learn

The endpoint is not a URL to be able to access an internet page, so the error you get is expected.
Sindhu_rk 80 on at

Like (0)

Report

RE: On - Hand Inventory Dual write Integration

Thanks for the solution Andre,

In F&O inventory Managent >Setup > Inventory visibility integration parameter. In General Tab which i shown below sc-1.Inventory Visibility endpoint, here i have selected GET ENDPOINT button.

The inventory visibility endpoint is get created. But it shows different URL.If i try to naviagte it shows page not found shown below SC-2, here what exactly i have to give could you suggest me to found out.

SC-1

SC-2

Thanks,

Sindhu.
André Arnaud de Cal... 291,971 Super User 2025 Season 1 on at

Like (0)

Report

RE: On - Hand Inventory Dual write Integration

Hi Sindhu,

As mentioned above, you can e.g. use Logic Apps to move data from one table to another.

In case the menu item in F&O is not visible, then check if the feature "Inventory Visibility integration" has been enabled in this environment.
Sindhu_rk 80 on at

Like (0)

Report

RE: On - Hand Inventory Dual write Integration

Hi Andre,

using Inventory visibility add-in i brought on-hand inventory in CE as a App shown below.

but we need all the data in CE STANDARD TABLE which is shown below

In this product inventory Table.

could you help me how can i bring those data in product inventory in Field service CE

and In FO the Inventory Management the inventory visible parameter is not reflecting. shown below the sample of image here

this is not reflecting In FO
André Arnaud de Cal... 291,971 Super User 2025 Season 1 on at

Like (0)

Report

RE: On - Hand Inventory Dual write Integration

Hi Sindhu,

It is not recommended to use Power Automate for this scenario due to possible high number of changes. Power Automate should not be seen as Power Integrate. You can then better have a look at Logic Apps which also has a Dataverse connector. Then still, I think the best way to have on-hand information synced from F&O should be the inventory visibility add-in.
Sindhu_rk 80 on at

Like (0)

Report

RE: On - Hand Inventory Dual write Integration

Hi Andre,

Thanks for the reply!

I have some queries please guide us.

Could we Achieve on Power Automate?

Their is any possibilities.. to achieve this scenerio through Power Automate?

If their..could you say the source of Table need to use in FO?

Exposing api need to use? in FO if power automate is possible means!

Thanks,

Sindhu