Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Purpose of Extended Cost When user rolls up the cost

in Costing 16 comments

Summary: Hi Team, we are using Standard cost for Manufacturing items and having cost profile setup to cost these items in Secondary UOM called as MSF (Thousand Square Feet). We are seeing incorrect Extended quantity calculation for FG item while rolling up the cost.

Scenario:
Item - AGFG1000081
Batch Quantity – 1 MSF
Quantity Used - 29.856250 Pieces
Work Definition Cost Processing Batch Output Size – 1
Extended Quantity - 2,866.82573
Per Unit Cost - Extended Cost/ (Quantity Used*Costing Batch Output Size/Batch Quantity)
2,866.82573/ (29.856250*1/1) = 96.02096m MSF (Thousand Square Feet)

Questions:
1. We are seeing Extended quantity is calculated as (Quantity used * Per Unit Cost). What is the purpose of Extended Cost When user rolls up case, unit cost is calculated correctly but extended cost is not getting calculated correctly. Unit cost gets calculated for each MSF and then it multiplies by 29.856250 to get extended cost (Pieces) ?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!