inventDimId Not Populated in RetailTransactionSalesTrans Table for LAN-ECOM (Online) Transactions

(0) Share

Report

Posted on by MUBASHAR

Hello community,

I'm facing an issue where the inventDimId field is not being populated in the RetailTransactionSalesTrans table for transactions associated with the LAN-ECOM InventLocationId, which corresponds to the online channel for our eCommerce site. However, for other InventLocationId values, such as LAN-FLOOR (physical store), the field is populated correctly.

Key Details:

Module: Retail
Environment: eCommerce transactions via the online channel (LAN-ECOM).
Impact: The missing inventDimId disrupts inventory tracking and affects downstream processes.
Expected Behavior: The inventDimId should populate based on product and transaction details, just as it does for physical store transactions.
Troubleshooting Attempts:
- Verified item setup for valid inventory dimensions.
- Reviewed channel and warehouse configurations.
- Ensured correct mapping between the eCommerce channel, warehouse, and store.

Has anyone encountered a similar issue with online channel transactions or can provide insights into potential root causes or solutions?

Thank you for your help!

Categories:

Dynamics 365 Commerce

inventDimId1.PNG

inventDimId.PNG

All responses (2)

Answers (0)

MUBASHAR on at

Like (0)

Report
inventDimId Not Populated in RetailTransactionSalesTrans Table for LAN-ECOM (Online) Transactions

@Jonas "Jones" Melgaard

For our eCommerce orders (LAN-ECOM), the fulfillment process does not involve traditional POS interactions or EOD statement postings. The workflow is as follows:

Orders are placed on the eCommerce platform and integrated into Dynamics 365 through the LAN-ECOM channel.

Inventory is reserved from the online warehouse assigned to the LAN-ECOM channel during order confirmation.

Fulfillment steps include picking, packing, shipping, and invoicing, managed through standard sales order processes.

Inventory and sales data are reconciled via batch jobs, not through EOD statements.

Given this setup, is there a configuration or process adjustment needed to ensure inventDimId is populated for online transactions, even without EOD posting?
Jonas "Jones" Melgaard 1,924 on at

Like (0)

Report

inventDimId Not Populated in RetailTransactionSalesTrans Table for LAN-ECOM (Online) Transactions

How are you fulfilling these eCommerce orders?

I don't recall it getting InventDimId unless you are posting EOD statements from a POS.