Microsoft Dynamics AX (Archived)

How to retrieve item's average cost price?

(1) Share

Report

Posted on by vv1984

1,087

Hi,

I need to get the COST PRICE it is showing in OH HAND screen for an item.

I need to join InventDim table and InventSum table, to get specific Inventory Dimensions for that item.

I noticed an 'averagecostPriceUnit' method in InventSum table, but i don't know how to use it

inside a query.

My starting query is something like:

select * from inventSum join inventDim where inventSum.inventDimId == invendDim.inventDimId

&& inventSum.itemId == _myItemId

&& inventDim.inventLocationId == _myInventLocationId

&& inventDim.inventSiteId == _myInventSiteId;

How do i retrieve the averageCostPrice for my item?

Thank you in advance

regards

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (0)

Sort by

Suggested answer

vv1984 1,087 on at

Like (2)

Report
Copy link

Link copied!

Solved:

You have to use InventOnHand class, InventDimParm and InventDim of course:

You use a temporary InventDim table to specify which inventory dimensions you want to filter in your query.

Then you initialize a InventDimParm object with InventDim as a parameter.

You finally pass InventDimParm to InventOnHand and there you are, you just need to specify your ItemId:

InventOnHand.parmItemId(_myItemId);

I can post a full working job example if someone's interested.

Thank you

regards

Was this reply helpful? Yes No
dolee 11,279 on at

Like (0)

Report
Copy link

Link copied!

Try InventSum.'averageCostPrice' method as well?

Was this reply helpful? Yes No
vv1984 1,087 on at

Like (0)

Report
Copy link

Link copied!

I was not able to use it because I didn't know the InventDimId from the start, but only some parameters:

site, warehouse and variation.

I needed to group the averageCostPrice by these parameters, and so i think that was the only way to achieve it.

Was this reply helpful? Yes No
Srinivasan Pandiaraj 30 on at

Like (0)

Report
Copy link

Link copied!

Dear friend,

please post full working job for retrieve item's avg cost price . I am in need of it .

Please help me.

Thanks in advance.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Yes. Please post a full working job if you could.

That would be wonderful.

Thanks

Was this reply helpful? Yes No
Pradeep Itnal 3,248 on at

Like (0)

Report
Copy link

Link copied!

Do you still have the code for it? could you please reply here

Was this reply helpful? Yes No
waseem osman 40 on at

Like (0)

Report
Copy link

Link copied!

Dear VV,

Please mail me full working job.

Thank you,

Regards

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Can anyone please mail me a working job?

Was this reply helpful? Yes No
Nadeem Bhatti 2,055 on at

Like (0)

Report
Copy link

Link copied!

I also need the avg price of item on given date, if some can provide me.

Was this reply helpful? Yes No
Pradeep Itnal 3,248 on at

Like (0)

Report
Copy link

Link copied!

Take a look at inventSum table, i guess there is a method.

Was this reply helpful? Yes No