sfg and FG @ MAP

[Former Member]

Hi Experts,

We have a classic problem of highly fluctuating raw material costs for manufacturing SFG and FG. We also have considerable stock aged more than a couple of years 9and this scenario might continue also) . Since the standard costing estimate mark and release procedure will valuate entire inventory at standard price, this will create a huge notional profit as on the Balance sheet date. Even though this will get reversed during the next period, we have auditing issues and hence SFG and FG needs to be valuated at actual costs. Since we are using AFS package in SAP, material ledger cannot be activated. (Please confirm if I'm right on this point). Can you please suggest a material valuation/consumption process which is a best practice in the situations of volatile raw material prices? I have already considered moving average price for SFG and FG which have serious repurcussions, but have no other option than to go ahead with the same and place some controls in the system during production order settlement. Please suggest if there is a better way out.

Best Regards

Vimal

[udo_werner · Accepted solution]

Hi Vimal,

That really sounds like you shoud use Material Ledger / Actual Costing. And there is no restriction against usage of AFS and material ledger. The restriction is in the combination of retail and material ledger, not AFS.

If you found something that indicates they are not compatible give me a hint.

best regards, Udo

[Former Member · Accepted solution]

Hi Udo,

Thanks for your inputs. PFB the text . I got it as mail in the SAP help file format and hence went with it.

AFS Restrictions

u2022 Note that the R/3 standard function multi-level actual costing (material ledger) is not currently available for AFS materials that are split valuated.

u2022 It is not possible to use the R/3 standard function Costing of Co-products for AFS materials.

Best Regards

Vimal

[Former Member · Accepted solution]

Hi Udo,

PFB the link restricting material ledger in AFS scenario. Can you please let me know how to work around this?

http://help.sap.com/saphelp_afs30b/helpdata/en/23/69e33750ef2926e10000009b38f889/frameset.htm

Thanks

Vimal

[udo_werner · Accepted solution]

Hi Vimal,

I investigated with the colleagues of the AFS solution. It is correct that there are some restriction concerning usage of split valuation and joint productio, but in general material ledger and AFS are compatible.

If you want to align you may contact me directly as Udo.Werner at SAP.com.

best regards,

Udo

[ajaycwa1981]

Hi

ML is the best solution for your situation, provided its technically possilbe and you are willing to do it

I would strongly advise against MAP for SFG/SFG... Refer SAP Note 81682, which strongly advices against it with an example

I had a similar situation and I used a work around... This is to be used when you are sure that Qty variances are not much in your case... The Main cause of variances is Price variances

a. Create a New Costing variant, with Costing Type = Release to Prices other than Std Cost

b. The Valuation Variant settings must be as below

For Materials - Strategy J (Price as per Price Control as of Last Period)

For Activity prices - Actual Price of Previous Period

c. At month end, once you calculate Actual Activity price, you can create a Costing Run in Ck40N

The Costing date can be 01.Apr.2011, if you are running the Cost Estimate for March 2011

d. The price calculated to be stored in Plan price 2 field of the Material Master or Tax price field

You can get a comparison of original Std cost and the revised std cost.... If need be, you can pass a JV in FI for the Stock (x) Revised price - Original Std price

5. If need be, you can also revaluate the COGS in COPA using this std cost estimate

br, Ajay M

[Former Member]

HI Ajay,

Yes. I understood the repurcussions mentioned in Note 81682, but thought of handling them with batch management and partial settlement of Prod orders. If i understand your solution correctly, u mean that we have an yearly std cost estimate at which all the entries would get passed and valuation will happen. In addition to that, have a monthly std cost estimate and update an unused field in the material master with the specified valuation variant. And then take the differences between two fields and pass an accounting entry to correct the books. (Please correct me if i got it wrong). Sounds like a work around, but need to check the quantity variance part. But can you tell me what happens if there is a quantity variance?

Best Regards

Vimal

[ajaycwa1981]

Hi Vimal

You understood it correctly

In case the qty variance is a regular affair - You should rectify your BOM then... The wrok around is based on the assumption that master data (BOM/Routing) are more or less correct

br, Ajay M