Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / The cost of an item in...
Finance forum
Answered

The cost of an item in a counting journal in F&O

Posted on by 12
Hello
 
In my counting journal, there is a line item (e.g. Item A).
I can see that the cost price is retrieved from the Activated planned cost of Item A.
 
I would like to know besides Activated planned cost, where does the counting journal line item retrieve the cost price of an item? 
 
 
 
Is there a parameter setting I can use to change where to retrieve the cost?
 
And does increase and decrease in quantity affect when the cost is coming from?
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    The cost of an item in a counting journal in F&O
    Thanks for your reply. When using the weighted average, upon an increase, it will use the planned cost price. In case of a decrease in on-hand, it will initially use the running average cost. When running the inventory close, it will recalculate and potentially correct the cost with an adjustment.
  • CU23050433-0 Profile Picture
    CU23050433-0 12 on at
    The cost of an item in a counting journal in F&O
    Hi,
     
    The item model group has a weighted average setting.
     
    The Item's activated planned cost is 199
    the item's current inventory value is 138
     
    The cost being retrieved is 199
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    The cost of an item in a counting journal in F&O
    Hi,
     
    The settings of the inventory costing method on the item model group are managing how the cost price will be determined. What setting do you have for this field on the item model group(s)?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans