HI All,
I have a problem, the production order status end in 2019/12/23.
the production order picking list a raw material A, Item on hand quantity is zero, the batch number of raw material sold in many other production order.
but only this production order, when I update the raw material costing version in per quarter, It will create a Inventory cost revaluation voucher.
what can I do, that next quarter will not create voucher in this production orer when I update cost.
Hello Shirlow,
Good to hear that you found the information needed.
I would recommend that you also have a look at the following document that describes things in detail:
It's a long post but it is worthwhile going through.
Please let us know if there is anything else the community can do/help.
Many thanks,
Ludwig
Hi Ludwig,
Thanks a lot,
In the just, I found the reason, it is because Inventcosttrans table, It lost a line of record..
When we report as finished a production , inventrans will change the status to received and create a trans in inventcosttrans, CostTransType is receipt and the CostTransState is physical.
when we ended the production order, inventrans will change the status to purchased and create a trans in inventcosttrans, CostTransType is receipt and the CostTransState is financial.
but I lost the financial trans in inventcosttrans table in 2019/12/20, when I ended the production order.
so per quarter when I update the cost in costing versions, it will new a Inventory cost revaluation voucher,
ervery inventcosttrans transaction has a ItemPriceRefRecId relations with InventItemPrice,
And when I update item cost price, system will search the latest ItemPriceRefRecId , so if I want to the system cut down the relation and don't create the new Inventory cost revaluation voucher, I need to clear inventcosttrans the latest transaction's ItemPriceRefRecId ....Add the lost transaction record as end the original production order does not help..
OK great.
Do you see a similar adjustment for the sales prices / costs?
That is, if you have a look at the item sales transaction do you also see a COGS adjustment?
Best regards,
Ludwig
Thanks Ludwig,
1、 Now, if I update the price in this quarter , it still create Inventory cost revaluation voucher to the production.
2、 This production order status had been Ended in 2019/12 and after picking slip in this production , this batch number of raw material on-hand is Zero.
3.I check in the system, this batch number of production order finish good already sold in 2020/02
Hi Shirlow,
Many thanks for the update/confirmation.
I have three follow up questions:
1. Did you somehow backdate the standard cost price activation?
2. What is the status of your production order? Is it closed?
3. Assuming that the items have already been sold; do you see a similar cost adjustment in the related sales order?
Best regards,
Ludwig
Hi Ludwig,
maintain a new price with the item in currently costing versions, after I active this price, I will get the voucher, voucher type is Inventory cost revaluation, and it will add into production order production posting.
Good morning Shirlow,
Can you describe what you did exactly when you ... updated the raw material costing version per quarter?
This is not clear to me.
Many thanks,
Ludwig
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
