InventDim from ItemId

Question

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?

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, Apr 04 '12 at 18:12

score 1 · Answer 1 · answered Apr 04 '12 at 18:50

1

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];


}

answered Apr 04 '12 at 18:50

Michael Brown

2,221
2
17
34

basically what u get in the job are ledger dimensions, but i need inventory dimensions – Tejashree S Apr 04 '12 at 18:52
2

inventory dimensions do not exist on items, they exist on their corresponding transactions (such as purchase orders, sales orders, journals, etc). – Michael Brown Apr 04 '12 at 18:56
@TejashreeS this would only really make sense if you are looking for something like on-hand stocks – AnthonyBlake Apr 10 '12 at 09:07

InventDim from ItemId

1 Answers1