четверг, 6 июля 2017 г.

Update/delete InventDim (memorize)


Recently I've found during searching one interesting information that could be useful for anyone who develops in AX.
The information related to manipulation with data in InventDim table.

InventDim table is backbone of Dynamics AX Inventory management module
before deleting inventDim record using method inventDim.delete(true) you should do following validation
* There should not be any record in InventSum table related the InventDimID which you are going to delete
* There shuld not be any record in InventTrans table related to InventDimID whicu you are going to delete
before updating inventDIM record using method inventDim.update(true) you should do following validation
* ensure that inventTrans records related to inventDimID which is getting updated is good to get updated with new 'inventBatchId' and 'InventSerialId', otherwise you will have bad information is On-hand details
* ensure that inventDim table is not having any record with new combination is inventory dimension, otherwise it will not get update.
It is recommended that we should not do any outside update and  delete in InventDim Table, but if you will take care of above data intigrity checks then you can update and delete the records in InventDim Table with out any issue.


I hope these observations will be helpful :)

Happy DAX-ing !

Комментариев нет:

Отправить комментарий