InventDim from ItemId

Go To


I am working on generating a form with fields of dimensions including Itemid.

I have a form in which i have only the ItemId, I need to find inventDimID for it.

How do I do that?

2012-04-04 17:33
by Tejashree S
The answer to this question depends on what you want the inventDimID of. What table are you using to get the itemid? What are you looking for (inventtrans table will have the inventdimid of all transactions on a given item) - Michael Brown 2012-04-04 18:12
I just have a itemid and not any transactios - Tejashree S 2012-04-04 18:21


I think that what you are looking for here are the dimensions of the item, not necessarily the inventDimId. In order to get the dimensions, you could do the following(for the purpose of this example, we have our dimension[1] = Department:

static void Job8(Args _args)
    Dimension   dim;
    SysDim      department;
    dim = InventTable::find('3t80').Dimension;
    department = dim[1];

2012-04-04 18:50
by Michael Brown
basically what u get in the job are ledger dimensions, but i need inventory dimension - Tejashree S 2012-04-04 18:52
inventory dimensions do not exist on items, they exist on their corresponding transactions (such as purchase orders, sales orders, journals, etc) - Michael Brown 2012-04-04 18:56
@TejashreeS this would only really make sense if you are looking for something like on-hand stock - AnthonyBlake 2012-04-10 09:07