Microsoft Dynamics Axapta Technical,Functional Coverage

If you are creating production order for bom items and items bom level is more than 2 or 3 then it may be possible to system will take more time to create production order or it will hang  . I have face this problem and tried to debug following classes. BOMHierarchyCheckscanupBOM BOMHierarchyCheckserchdownbom Prodtabletype I found there is problem due to inventdimid and number sequence creation problem I tried to reassign number sequence for particular inventory dimension. Finally it got resolved..Thank God.

use index hint on a join in Axapta InventTrans inventTrans; InventDim inventDim; ; while select inventTrans index hint ItemIdx where inventTrans.ItemId == 'X' join inventDim where inventDim.inventDimId == inventTrans.inventDimId && inventDim.inventBatchId == 'Y'

If you want to find inventdimid in axapta then you can try following code. This example also shows you how to create inventdimid. InventDim inventDim; ; // Set the values that you need for // the journal or transaction inventDim.InventLocationId = "01"; inventDim.InventColorId = "02"; // Use findOrCreate and use the inventDim // variable that you have set values into inventDim = InventDim::findOrCreate(inventDim); // Use the inventDimId to link to the // InventDim record that was either // found or created info(inventDim.inventDimId);