Assortment support in WMS
Apperal and similar retailing have lots of dimensions. Dynamics 365 dimensions architect affected by Seasonality and product ranges. Even, Microsoft Dynamics 365 For Retail does not support product assortments (size ratio based products)
In reality, Warehouse operations are not suitable ...
Reorganizing retail transaction tables fields
Retail transactions consist of Header, lines , Payments and Discounts parts. The number of table fields are increasing with new features and upcoming versions. Storage is the biggest problem for Retail companies with a high number of daily retail movements. They complain about being obliged to...
Posting Retail statement and finance
There are two durations as we consider physical posting of retail transactions.
1.POS creates retail transaction -> Batch execute Retail Posting to reserve inventory-> Retail Statement create sales order with physical transactions.
2.POS creates retail transaction -> Ret...
Inventory Status Field Place
Standard inventory management module does not support inventory status field property. It comes with WMS module's feature. Inventory status functionality is the best option for one of our clients' requirement. However, to activate this functionality we had to activate advanced warehouse manage...
Remove Status Field in Batch Table
There are lots of presure on the Batch tables. Especially, While batch framework try to update status field with pessimistic lock. Then we have faced lots of deadlock and blocking issue. Status field should be keep an another table which is just insert statement.
Filtered Index Feature
Filtered index feature should be added to table indexes in D365FO. It's very helpfull to reduce index sizes and maintenance costs.
RecId generation can be replaced with InMemory Tech.
GetNextRecId stored procedure can be In-Memory one. We have just converted SYSTEMSEQUENCE table and GetNextRecId stored procedure to as In-Memory objects. Actually, It's too fast for between 1 and 1000 records. We don't know why after 1000 records In-Memory's performance reduced unex...