Thursday, November 12, 2009

Add a new inventory dimension

Dynamics AX 2009 includes the following inventory storage dimensions from the packaging:

  • Warehouse
  • Batch number
  • Location
  • Pallet ID
  • Serial
and item dimensions:
  • Configuration
  • Color
  • Size
Sometimes it may not be enough for the business needs. To add a new dimension, you can follow the steps below:

  1. First, I assume you have create the dimension tables (similar to InventColor, InventBatch)
  2. Add the key field into the table InventDim.
  3. Then add to the field group InventDimensions and InventoryDimensions
  4. Add fields to the DimIdx as well as relations if necessary.
  5. And then modify some methods if InventDim, just goes thru all methods.
  6. Add fields to InventDimParm also.
  7. Modify macro InventDimJoin and InventDimSelect.
  8. The most important things is do a seach at the top of AOT with #InventDimDevelop as the keywords.
  9. Do a complete Recompilation of all stuffs.
  10. Finish!
You are suggested to add all new dimensions before the system implementation. If there's some open transaction, weird things may happen. So add some spare dimension if necessary.

2 comments:

richa said...

Thanks A lot for your post. It's great help for people new in axapta.

Santosh Kumar singh said...

This is another blog which i get very useful for dynamics learner


http://daynamicsaxaptatutorials.blogspot.com/