CKMM issue PUP(actual price) disappeared in the material ledger

[Former Member]

Hello Gurus,

We have a material ledger issue, CKMM transaction was ran to change the price determination from the status 3 to 2 to update the standard cost in during the middle of the month. Standard cost is updated but the actual receipts and consumptions records for the first half of the month have been disappeared in the materials in CKM3. How can we bring the records back in the material ledger. Please advice

Thanks,

Srikanth

[former_member513101]

Hi Srikanth,

No really understand why you need to adjust the quantity along with price difference. May be i miss some points. Anyway, following are my understanding and assumption:

1. Price determination was changed from 3S to 2S in July. CKM3 price difference info lost due to this
2. There are PGR and PGI after the change in July.
3. July month end, wrong ending inventory value due to item 1 and 2. No price difference allocate back to ending inventory, single-level consumption (e.g charge to cost center), and multi-level consumption (e.g production WIP, production order, COGS)
4. I assume you changed back the price determination from 2S to 3S on 1st Aug.
5. Ending inventory values are wrong in august and Sept (subsequent months) due to above.

Assumption:

1. Let say this material std unit price is 500 for qty 100 at the July beginning
2. Total price difference 1,000 for qty 100 lost after the change
3. July ending inventory qty is 70, and qty 30 PGI to production order for FG qty 30. Let make it simple let say FG qty 30 all sold out to customer.
4. So the Aug beginning value is (70* 500 = 3500 + remaining price difference 700 = 35700). CKM3 show 3500 due to the price determination change ( just an example). Now October already, for sure you have goods movement in Aug and Sep. ML actual cost is actual moving average. You need to identify those goods movement for Jul to Oct to decide where to correct the price difference. You need to find out the goods movement quantity and ratios then correct it with MR22 if it has to be put back to inventory value. For COGS adjustment you can use FB50 to correct it. If you have COPA activate. Make sure COGS in COPA report tally with FI COGS value.

Hope explanation and assumption above help you.

Thanks.

[Former Member]

Hi KK Lam,

The issue with MR22 is we can only adjust the stock value (debit or credit the total value). How can we adjust the quantity of the material. Because, there where some goods receipts processed in the month of July and august for these materials which are now disappeared because of CKMM and now the ending inventory quantity needs to be adjusted along with the price differences.

Thanks,

Srikanth

[former_member513101]

Hi Srikanth,

1. If your MMRV current period is Aug, then you can make adjustment to July and Aug. It is not advisable to reverse the MMPV period. If you really want to do so, you can follow the note 487381 provided by SAP. This has an impact to inventory valuation. You can simulate it in Quality environment before you do it in production.

2. You can run post closing for specific material with CKMI

[Former Member]

Thanks for your response KK and Tapio ,

1. Can we post MR22 in the periods of July, August since we are already into October. Moreover the requirement is to adjust the actual cost from July and August. Is it possible?

2. After adjusting the cost can we only run material ledger closing for the specific materials(not for the whole plant) since closing cockpit is already ran for July August and September.

Thanks ,

Srikanth

[former_member513101]

Hi Srikanth,

You can correct the price with MR22

[Former Member]

Hello,

when you change price control from 3 to 2 and back to 3, all previous recorded data in ML lost. I think it's mentioned in documentation and related notes as well. CKMM is a one-time transaction.

If you want to change the standard price, change it for the next period. The current period will be usually corrected by actual price determination. If you need to adjust the price for current period, just post manually price differences with transaction MR22.

Best regards, Tapio

[Former Member]

Hi KK Lam,

Thanks for your quick response I have gone through the note 384553 and also contacted SAP. I am looking for a work around solution for this issue. Because this happened in July the ending inventory values are wrong in august and September and they are going to be wrong in the future periods. I need to a solution to at least fix the future periods going forward with correct inventory value.

Thanks,

Srikanth

[former_member513101]

Hi Srikanth,

Check Note 384553.If you change the price determination control from 3 to 2, the material is assigned the "Quantities and Values Entered" status. The system deletes all price differences in the material ledger, except for the price differences from revaluations. I don't think you can get back those records in ML.