M3-WMS Inventory Reconciliation

Ensure that M3 - WMS Integration is correctly configured.

See Infor M3 Core Integration Guide for Infor WMS.

Ensure that these tables exist in Data Lake:
  • CSWMS_wmwhse_LOTXLOCXID
  • CSWMS_wmsadmin_PL_DB
  • CSWMS_wmwhse_LOTATTRIBUTE
  • MITLOC

See KB3636612 for a detailed guide for M3-WMS Inventory Reconciliation Configuration.

In the WMS Application > Enterprise > Administration > Config Settings, ensure that the DataLake_switch flag is set to TRUE for the WMS data to sync in Data Lake.

WMS and DataLake sync a few hours after you set the flag to TRUE.

If the update does not occur after a few hours, contact WMS Support for help.