I’m doing a customization on AX 2012 R2. The task is to add a new tracking dimension beside batch and serial number, we called it GIN number.
I’ve create a new EDT called ‘GIN’ and then add the EDT to InventDim table. When I open the table via AOT, I try to insert new data to the ‘GIN’ column, but it gave me error “Incorrect setup of dimension groups” when I try to save it.
Creating a new dimension will not be an easy task. Simply adding an EDT won’t work because of the complexity involved in inventory transactions and tracking.
Thank you for the reply I’m new to AX, so I’ll try to explain what I try to achieve:
The concept of the new tracking dimension called GIN number is as follow:
GIN is a running number for every item arrival; so when item A batch 01 arrive at 1 Feb 2013, it’ll have GIN number 01.
When item A batch 01 arrive again at 2 Feb 2013 together with item B batch 02 and item C batch 03, it will become:
Item A batch 01 will have GIN number 02
Item B batch 02 will have GIN number 03
Item C batch 03 will have GIN number 04
So, item A batch 01 can have 2 or more GIN number depends on the arrival.
My approach is as follow:
Create a new EDT called ‘GIN’
Add the EDT to InventDim table
When user input batch number in Item arrival, I’ll create a new inventDimId and insert it to InventDim
I know that creating a new dimension will not be an easy task, especially when I’m new to AX, but I don’t seem to find any other way to store the GIN number other than adding it to the tracking dimension.
Can you help me by giving any clue how to store the GIN number ? or should I continue adding GIN number to tracking dimension ?
But presumably you are not going to modify the entire reservation and picking routines throughout the system, I am presuming there are no cost implications. I can see little benefit in all honesty but I do not know the industry you are dealing in. I would see for the instances this occurs and the business has to know that they look at the source transactions and pick the earliest packing slip/delivery note in a clash. Seems like a huge modification for minimal value.