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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Counting Journal showi...
Microsoft Dynamics AX (Archived)

Counting Journal showing "Zero" as cost price for some items

(0) ShareShare
ReportReport
Posted on by SteveWhyte 583

Here is my situation:

1. All item model groups are set to FIFO

2. On printing a counting journal, some of the items are showing 0.00 as the cost price.

3. It is my understanding the AX uses the average price until you run an Inventory Recalculation or Inventory Close.

4. In examining the transactions on some of the items with 0.00 cost price, many of them do have transactions (purchase orders/sales orders) and yet the cost price is 0.00

Any ideas on how to troubleshoot this?

Steve 

*This post is locked for comments

I have the same question (0)
  • Guy Terry Profile Picture
    Guy Terry 28,972 Moderator on at

    I think you need a cost Price on the Released product (Manage costs fast tab). If you tick Latest cost price, AX will set this cost price for you at certain events.

    Or, if you want a different price per Site, you can set a Cost Price via the Item price function (Manage costs tab in the Action pane).

    Bear in mind that AX will not use the cost price on the Journal line when you adjust inventory out, but it will if you adjust inventory in.

  • SteveWhyte Profile Picture
    SteveWhyte 583 on at

    Thanks for your info Guy.

    My expectation is that the item would be cost at average until inventory close/adjustment. I understand latest cost price has its challenges (I can't remember now what these are). I don't want to set cost price via item price function.

    Any other ideas?

  • Guy Terry Profile Picture
    Guy Terry 28,972 Moderator on at

    TBH, I think Latest cost price is pretty good. For me, it's better than the alternative....

    AX uses the item (cost) Price when it doesn't know the cost to use. Imagine the warehouse find some stock they didn't know they had; they adjust in the quantity, but how often do they care to find out what cost to use.... never? In this case, AX will look to the item's Price and use that. Sure, the user could update the price on the journal line, but in reality will that happen?

    So, without Latest cost price ticked, what is the item's Price? By default, it's 0.00. That's just plain wrong. But unless you actually have someone who cares about updating it, it's going to be 'wrong'. If you have Latest cost price ticked, it causes the (cost) Price on the on the Item to update. From memory, it updates with the Cost price of the most recent financially updated receipt inventory transaction. So, yes, you're at the mercy of what ever the most recent receipt transaction was, but in all likelyhood, it'll be a valid transaction that was created with a good cost price. Latest cost price doesn't consider which inventory dimensions are ticked for Financial Inventory (it doesn't care if you have different costs per Site, or per Batch). And probably it doesn't care about product dimensions either. So, in that sense, it's not perfect.

    For your count report; does a cost price help you count better? No, I'm sure it doesn't. But does it help you decide which discrepancies to double-check? Yes, probably it does. But it's only a guide.

    For your adjustments, when you adjust stock out, the price on the journal line is irrelevant (because you use an actual costing method to value your inventory). But when you adjust stock in, then it plays a big part.

    Before you rule out Latest cost price, answer the question 'If I find stock I didn't know I had, what cost price should I use?'. If you can think of a better workable solution, then AX probably doesn't have it in standard!

  • SteveWhyte Profile Picture
    SteveWhyte 583 on at

    Hey Guy

    Your arguments above are probably one of the most reasonable arguments I have seen here in the Forum. Your depth is phenomenal just like my friend Ludwig who also contributes to this forum.

    My only response/question to your comments would be this:

    If there are transactions against an item (both ins and outs), what are the possible reasons to explain why the cost price is zero, even at the point of just printing the counting journal?

    Looking forward to your response

    Steve

  • Guy Terry Profile Picture
    Guy Terry 28,972 Moderator on at

    Ha! I met Ludwig a couple of weeks ago. He's a great contributor here, and elsewhere.

    From what I can see by testing, the Cost shown on the journal line does not use the value of On-hand or previous stock transactions. It only uses the Price set on the Item (or Item price).

    Of course, if you use Latest cost price, the Item will have the price from one of those inventory transactions :-)

  • SteveWhyte Profile Picture
    SteveWhyte 583 on at

    Thanks Guy for your response. I will discuss your great points above with Ludwig shortly as we plan to look at the actual data together.

    Guy & Ludwig, both you guys are rock solid!!!!!

    Steve

  • Konrad U Profile Picture
    Konrad U 804 on at

    Latest cost price does have a downside in that unit of measure issues push it around. Our service and production departments order in vastly different quantities at different prices based upon the quantity. In the answer to why, updating an item record with a new average cost would be a heavy performance hit. Average costing is already a huge performance hit, we went on implementation of 2012 r3 with standard to avoid inventory closes.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans