Item cost price calculation logic in AX2012

(0) Share

Report

Posted on by Hichem.Chekebkeb

3,371

Hi,

I'm trying to understand the logic to get the item cost price in AX after doing an importation and including charges related to it.

I did look into Item price form but nothing picked my interest (I sure didn't understand its role).

let's say that I have imported 100 unit of an item at $5 and I paid $30 insurance.

I haven't find anywhere to see the related cost price of that item.

Could you please tell me where to find that?

Any documentation links or videos will be very appreciated.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Verified answer

Weaveriski 23,618 Moderator on at

Like (0)

Report

Go to the transaction that you used to post the receipt and there will be a cost on the inventory transaction - the insurance will depend upon whether you used miscellaneous charges or not and how you posted it.

Was this reply helpful? Yes No
Mansoor Adeel 840 on at

Like (0)

Report

in AX if you want to see the cost price, you can see from item transaction form. if you want to learn the logic of item price in PO, lets take your example and solve it.

In PO you can use Misc. charges to distribute on your items which system allocate to PO lines as per allocation you apply. if your purchase amount is 500 and 30 are insurance charges then system will show the cost of 530 for your purchase of 100 items.

If your further apply landed cost in the PO, which you can record after invoicing the PO in charges ->adjustment section. it will also be included in your item cost.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

mansoor,

please define item transaction form in more detail.

and also let me know where we can view automatic Charges on any item???

Was this reply helpful? Yes No
Weaveriski 23,618 Moderator on at

Like (0)

Report

1. Item record and transactions - then navigate to the transaction that caused the inbound that you want to analyse.

2. If they are not configured you will see nothing, so are you using miscellaneous charges? How are you actually reflecting the insurance charge in AX?

Was this reply helpful? Yes No
Hichem.Chekebkeb 3,371 on at

Like (0)

Report

Thanks everyone for reply

WEAVERISKI,

Talking about misc.charges,

What is the difference between entering misc.charges in PO or in final Invoice and which one is affecting the cost price ?

"Go to the transaction that you used to post the receipt" could you specify how to get to cost price this way in AX?

Thanks

Was this reply helpful? Yes No
Weaveriski 23,618 Moderator on at

Like (0)

Report

Which one affects cost price depends upon the setup of the misc charge.

If you specify the transaction that caused the receipt I will do (Production Order, Purchase Receipt, Customer Return, Transfer Order, Inventory Journal etc.) Easiest way is to go to the item and press the transactions button, navigate to it. On hand gives you a cost as well so that screen would show you but potentially not at a transaction level.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am facing very serious issue in inventory transaction, cost of item is showing 0 it is not taking even purchasing cost i am not getting why i am facing this issue because of this i m not been able to check my item cost i also get the reason of it but still solution is not yet resolved on Transaction screen update tab Adjustment of same amount that is of cost amount is shown with negative sign because of which cost amount going zero. Please help me out

Was this reply helpful? Yes No
Weaveriski 23,618 Moderator on at

Like (0)

Report

Take it back to the basics and ensure when you book an item in and invoice it the cost is updated on the item and the transaction. There are item flags to prevent it but the transaction should always be the cost.

You also need to look at your costing method, you do not mention what it is.

I would also suggest a new post for your query rather then appending to one in progress that was not yours.

Check you have also run the inventory close process.

Was this reply helpful? Yes No
Mansoor Adeel 840 on at

Like (0)

Report

Sania Weaveriski is correct, your problem should be discussed in a separate thread. short answer of your query is, item cost is always updated with following conditions:

1. After Invoice posting if you are using purchase order with "Include physical value" check mark unchecked in item model group

2. If you have nothing in inventory and you are using sales then system takes cost from costing version. If costing version do not exist then it takes cost from item cost in costing section of item master record. If both costing version & costing section are empty then system do not take item cost with it when issues.

3. If you forgot to make the entries with cost when taking items inward, you can use inventory adjustment to update the cost and then use inventory recalculation to update the inventory cost values in item transactions.

Should you have further inquiries about inventory costing, you can contact me at

Mail: mansoor_adeel@yahoo.com

skype: mansoor_adeel

Was this reply helpful? Yes No
Naser Ahmed 35 on at

Like (0)

Report

Thanks mansoor_adeel@yahoo.com

i have another issue ,

in AX for Retail , which cost price will be used in a sales return transaction which created in a POS

Regards

Was this reply helpful? Yes No