Finance | Project Operations, Human Resources, ...

Manual entry of 'Cost price' lost in Counting journal when posted

(0) Share

Report

Posted on by Mglaum

Hi all,

I am currently performing a stock take with a counting journal for a store, and a few lines did not have a cost price associated on the specific site, so I updated it manually on the line of the counting journal, however, when posted, the cost price is lost. Is this intended logic for counting journals or is it something that I am missing?

We have no customizations related to this form, we use a moving average and the stock take is done per location.

Best regards,

Max Glaumann

I have the same question (0)

All responses (11)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Max,

If you check the inventory transaction that has been made for the respective item, can you see a cost price that was posted?

Best regards,

Ludwig

Was this reply helpful? Yes No
Mglaum 25 on at

Like (0)

Report

Hi Ludwig, thank you for your reply.

The inventory transactions related to the counting lines which was posted with manually entered cost price does not have any cost price associated.

Best regards,

Max Glaumann

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

I see.

Is this a standard cost item or an item that uses an actual costing method such as fifo?

Was this reply helpful? Yes No
Zain Mehmood 4,187 Most Valuable Professional on at

Like (0)

Report

Hi Max,

Is your physical negative for that item enabled or do you have any cost related with that item at all? What is the on hand quantity for that item. You can check from Inventory management> On hand list> Select the item> On hand Details> Available Physical & Cost price.

Warm Regards,

Zain

Was this reply helpful? Yes No
Mglaum 25 on at

Like (0)

Report

Hi Zain,

There are no cost entry related to the product variant at all, on-hand quantity is 0. When looking over the result from when posting the journal, it seems as some lines kept the manually updated cost price, while some didn't, and the cases that I find where it lost the cost price is where where the on-hand is either 0 or negative, this seems to be standard functionality but I'm not sure why it operates in this way.

Best regards,

Max Glaumann

Was this reply helpful? Yes No
Zain Mehmood 4,187 Most Valuable Professional on at

Like (0)

Report

HI Max,

Can you post some transactions of the item to see if whats happening, please check it from Cost management> Inquiries> Inventory accounting inquiries> Transactions

That will help a bit. Thanks

Regards,

Zain

Was this reply helpful? Yes No
Mglaum 25 on at

Like (0)

Report

Hi Ludwig,

We use a moving average cost method.

Best regards,

Max Glaumann

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

Like (0)

Report

Hi Max,

After you have performed a first inventory closing, you can go to adjust transactions and post a cost price related to received transactions. Check this in a test environment first.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Good Morning Max,

Thanks for the update on the cost method.

Is this the first transaction that you ever posted for this item?

That is, is this stock taking related to a data migration step from a previous system and does the item thus have no moving average cost price in your system?

Also, please check what Andre mentioned further above.

Best regards,

Ludwig

Was this reply helpful? Yes No
Heiko Weber on at

Like (0)

Report

Hi Max, if you lose an item it never has any impact if you manually specify the proce in the counting journal.

This is by design and for a goof reason! Losing an item means you can`t find it anylonger in the warehouse. In that case you have to take it away to exactly the same value (according to the value model) that it was representing. If it would be possible to manually overwrite that value it would end up in situations like: No physical quantity but financial value, no quantity but negative value....

As a general rule : You cannot manual modify transactions that are deducting physical quantities. the value will always be determined by the incoming trancactions according to the costing methods.

Therefore on the other hand:

If you have a positive effect (you find more than expected) this is the moment where a manual entry would have an effect. In this moment you can tell how the additional quantites shuold be valuated.

Was this reply helpful? Yes No