web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Cost price not updating on invent on hand (invent sum) & invent trans forms after posting counting journal

(0) ShareShare
ReportReport
Posted on by 44

I am updating the quantity counted and manually inserting a cost price for an item in counting journal and post it. The quantity is updating and showing in the physical quantity column on invent on hand & invent trans forms but cost price is not updating on the invent on hand & invent trans forms and item master cost price. I have check the latest cost price option on released products manage cost section also.

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    301,035 Super User 2025 Season 2 on at

    Hi Ammad,

    Do you have positive additions due to the counting, deductions or both? What is the inventory costing model set up on the item model group(s)?

  • Suggested answer
    BillurSamdancioglu Profile Picture
    19,703 Most Valuable Professional on at

    Hi,

    If you post positive quantity and do not have any standard cost o the item and didn't put any value manual, then there will be no cost.

  • Ammad majid Profile Picture
    44 on at

    I am adding the cost price manually but it is not showing on invent on hand form (invent sum & invent trans both).

  • BillurSamdancioglu Profile Picture
    19,703 Most Valuable Professional on at

    Hi,

    Is it possible that you share some screen shots of inventory transaction and how you added in counting form.

    Also for item model groups.

  • Ammad majid Profile Picture
    44 on at

    Hi andre,

    Inventory costing model setup on item model group is moving average and additions and deductions both happen in my case. I am inserting the cost price manually while posting the counting journal and quantity as well. Quantity is updating but cost price (cost amount physical) is not updating on invent trans form.

  • André Arnaud de Calavon Profile Picture
    301,035 Super User 2025 Season 2 on at

    Hi Ammad,

    Like asked before by Billur, can you share some screenshots? For the deductions, does the on-hand have a value registered?

  • Ammad majid Profile Picture
    44 on at

    Sorry for late reply, I have been trying to debug the issue but failed to find why the price is not updating. I am attaching the screen shots below:

    This is one having no invent on hand record and I am creating a new counting for that item and assigning it a cost price.

    Item1.PNG

    That is the result of the same item on invent on hand form ( empty cost price) 

    onhand1.PNG

    And this is one already have a record on invent on hand form and I am counting that item and assigning it a new cost price.

    item2.PNG

    That is the result, old cost price is shown on invent on hand form.

    onhand2.PNG

  • André Arnaud de Calavon Profile Picture
    301,035 Super User 2025 Season 2 on at

    Hi Ammad,

    Can you also share a screenshot of the item model group?

  • Ammad majid Profile Picture
    44 on at

    Hi Andre,

    Here is a screen shot of item model group setup

    movavg.PNG

  • Suggested answer
    BillurSamdancioglu Profile Picture
    19,703 Most Valuable Professional on at

    Hi,

    It seems ok.

    And I see there is financial cost.

    So physical cost should also be there when you post.

    Is it possible you to try with the same item again.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 565 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans