Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Item cost price calcul...
Microsoft Dynamics AX (Archived)

Item cost price calculation logic in AX2012

(0) ShareShare
ReportReport
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

  • Mansoor Adeel Profile Picture
    Mansoor Adeel 840 on at
    RE: Item cost price calculation logic in AX2012

    Dear Naser,

    Sorry for late reply, system treats the sales return like purchase of item and if an item was sold at $100 and you are taking item at $100 and not selecting any bill then system will take inventory with $100 in COGS, Inventory, Customer and sales accounts. If any bill is selected then system will take inward with the cost it was issued with in COGS, inventory and will take the return amount in sales, customer account.

    Hope it will help.

  • Naser Ahmed Profile Picture
    Naser Ahmed 35 on at
    RE: Item cost price calculation logic in AX2012

    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

  • Mansoor Adeel Profile Picture
    Mansoor Adeel 840 on at
    RE: Item cost price calculation logic in AX2012

    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

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: Item cost price calculation logic in AX2012

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item cost price calculation logic in AX2012

    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

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: Item cost price calculation logic in AX2012

    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.

  • Hichem.Chekebkeb Profile Picture
    Hichem.Chekebkeb 3,371 on at
    RE: Item cost price calculation logic in AX2012

    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

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: Item cost price calculation logic in AX2012

    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?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item cost price calculation logic in AX2012

    mansoor,

    please define item transaction form in more detail.

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

  • Mansoor Adeel Profile Picture
    Mansoor Adeel 840 on at
    RE: Item cost price calculation logic in AX2012

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans