Counting Journal Positive Impact

(0) Share

Report

Posted on by Community Member

Hi Team,

I am running counting journal in D365 F&O. Suppose I have on hand quantity in system 10 to my physical quantity 12 . System is increasing the quantity but not the amount. Is there any law implication or any specific reason.

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi PramodKumar,

Do you have any cost price set on the Item details for this item? If not, it will use 0.00 for positive updates.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Andre. We don't have any cost price setup for the item. I just want to understand what is the reason for not updating cost of change is positive.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

The reason is that the cost price on the item card is not filled. In that case, AX is not able to know what cost price to use. So, ensure that a cost price is known. For standard cost, it is a bit differenct. Then you have to activate a cost price.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Andre,

But System updates quantity and cost price in case it is negative at running average cost. So what is the reason?

Was this reply helpful? Yes No
Verified answer

Guy Terry 28,924 Moderator on at

Like (0)

Report
If you are removing items from stock, AX knows what the cost of those items is, just like it knows the cost of items when you sell them. Depending on the cost method you use, it will likely post that loss at the running average, and then adjust that to an actual cost when you run Inventory close.

If you are adding items to stock using a count journal, you are effectively making them out of nothing. AX doesn't know where these items really came from, or how much they cost. You can manually enter a price on each count journal line if you want. Or, if you set a Price on the Manage costs fast tab of the Item, AX will automatically put that price on to the Count journal line (and you can change it if you want). If entering or maintaining a 'good' price is determined to be too much effort, you could consider ticking the Latest cost price tick-box. This will ensure that AX set an Item Cost price for you, and it will maintain / update it each time a receipt transaction is financially updated. This can mean that the Cost price remains relatively up-to-date. You will have to decide which is the best solution:

when we find stock, we should manually enter the cost on the journal line.

when we find stock, AX will use the cost price that we have set on the Item. We could review and update these item cost prices as needed.

when we find stock, AX will use the cost price that it has set on the item. We won't have direct control over that price, but its better than having no cost price on the journal line (and the user forgetting to enter one!)

Was this reply helpful? Yes No