Inventory valuation with Project stock- project for long periods with same material

[former_member196210]

Hi Experts,

My client using PS and all process (Sales, production) will be linked to WBS.

Now we are facing problem with inventory valuation of FG, we are using valuation with specific to project.

Example- I have FG that is linked to one WBS element (Valuation is specific to project). On 1^st of September I have created one production order and done GRN for production order (GRN was happened with price 100, the price is the plan cost of production order. As a standard functionality it will check priority and taken plan cost of production order) and the same price 100 has been updated in table QBEW in the combination of WBS and Material. Like that in the month of September I have created 10 orders and done GRN.

Now in October also I have created one production order and done GRN, system still taking 100 for GRN (But in the month of October there is huge change in raw material prices), how can I update the price for this WBS and Material ( CK40N will not work because this is project stock and valuation also project).

Please help how can I change the price periodically in table QBEW.

Thanks,

Chandu

[bhaskar_basam]

You can use BDC or LSMW to update the prices for these FGs, this is the only way you can update. Else you need to change price control for FGs to auto update the latest RM prices.

Regards

Bhaskar

[former_member196210]

Thanks Bhaskar,

We are using Price control S, but business do not want to update manually by using MR21.

Please suggest if there is any alternative way to update QBEW table, why because they have almost 1000 FG codes and 1000 projects, to calculate price manually and updating is difficult.

Thanks,

Chandu

[bhaskar_basam]

Hi,

CK40N will not update price at the project stock or sales order stock level. You need to update manually update the prices against the WBS stock using MR21 (from dropdown select wbs element).

If you maintain your FG stock as Price control "V" then in this case whenever you create a FG production order and when you settle this order, the differences between the existing price of FG and total of RM prices will loaded on the FG stock at project level and you will get actual cost.

If you still prefer to go with price control "S" then the differences between FG and total RM prices will hit your PRD account.

Regards

Bhaskar