Question Status

Suggested Answer
ahmed barbary asked a question on 30 Apr 2013 11:20 AM

Can any one reply to me in this question if possible

 I have Concrete  code as 2555mpo  contain to

 Raw Material      unit cost(item card)       cost method       unit measure

gravel                          0.2                          average                 ton            

sand                            0.3                          average                 ton

cement                        0.4                          average                 ton

 2555mpo is (finish goods) and has standard unit cost  so that i have this questiones

1- according to example what unit cost i must put in finish good (2555mpo)

2- how i calculate standard cost of finish goods

please guys reply for this question because this will clear to me more things 

Reply
Suggested Answer
Neville Foyn responded on 30 Apr 2013 4:22 PM

Hi

You need to first run the adjust cost item entries to ensure that your average cost is up to date, then use the standard cost worksheet to have the system create your standard costs on the finished goods item

You should not fill anything in manually the system will calculate an update the FG item using the worksheet

Cheers

Nev

Neville Foyn
NAV Developer, Consultant & Trainer
MCTS NAV, CRM, Sharepoint, SQL
MCSA SQL 2012
MCITP NAV
MCT 

Reply
ahmed barbary responded on 30 Apr 2013 11:08 PM

mr Neville Foyn  thank you more time for interest.i understand what you say but one point i need to show to me if

possible when i calculating by standard cost work sheet make as following :

2555mpo  

gravel

sand

cement

then  roll up standard cost or what i do

Reply
ahmed barbary responded on 30 Apr 2013 11:29 PM

What i need is to update finish good 2555mpo  that has standard cost so that what i do

write this item  2555mpo only

OR

Write raw material components

this actually my question

Reply
sanjaypandey20@live.com responded on 2 May 2013 12:04 AM

You dint mention qty consumption in BOM detail., first need to fill qty then you can get finished product cost.

Reply
Neville Foyn responded on 2 May 2013 3:59 PM

Hi

Been a while since i last used the worksheet but the steps are basically:

Suggest Item standard cost - Purchased materials

Suggest Machine & Work Centers

Update costs on these if required

Suggest item standard cost - Manufactured items

Roll up standard cost

Implement cost changes

That will then give the correct calculated cost, when i was first working with this i created a new FG item and setup in a test system, then manually added just those to the worksheet so that i could play with the numbers and figure it all out, i would suggest that you do the same as it helps with getting it all to make sense

Cheers

Nev

Neville Foyn
NAV Developer, Consultant & Trainer
MCTS NAV, CRM, Sharepoint, SQL
MCSA SQL 2012
MCITP NAV
MCT 

Reply
ahmed barbary responded on 3 May 2013 3:56 PM

Mr Neville Foyn  thank you very much but there are one point misunderstood

1-Now are i make standard cost work sheet to gravel  ,sand ,cement although it

2-suppose i has 200 in unit cost of  finish goods  i need to know how system calculate this value.

or based on what this value come

if possible can you give me answer to these questions im sorry.

Reply
Suggested Answer
Neville Foyn responded on 6 May 2013 10:09 PM

Hi

How the system calculates costing methods is a pretty complex question, it also changes with the adjust cost item entries batch job

Your best bet is to read through the costing whitepaper, it is for version 5 but will give you the background, you can find it here

dynamicsuser.net/.../8363.aspx

Cheers

Neville

Neville Foyn
NAV Developer, Consultant & Trainer
MCTS NAV, CRM, Sharepoint, SQL
MCSA SQL 2012
MCITP NAV
MCT 

Reply
Suggested Answer
Neville Foyn responded on 30 Apr 2013 4:22 PM

Hi

You need to first run the adjust cost item entries to ensure that your average cost is up to date, then use the standard cost worksheet to have the system create your standard costs on the finished goods item

You should not fill anything in manually the system will calculate an update the FG item using the worksheet

Cheers

Nev

Neville Foyn
NAV Developer, Consultant & Trainer
MCTS NAV, CRM, Sharepoint, SQL
MCSA SQL 2012
MCITP NAV
MCT 

Reply
Suggested Answer
Neville Foyn responded on 6 May 2013 10:09 PM

Hi

How the system calculates costing methods is a pretty complex question, it also changes with the adjust cost item entries batch job

Your best bet is to read through the costing whitepaper, it is for version 5 but will give you the background, you can find it here

dynamicsuser.net/.../8363.aspx

Cheers

Neville

Neville Foyn
NAV Developer, Consultant & Trainer
MCTS NAV, CRM, Sharepoint, SQL
MCSA SQL 2012
MCITP NAV
MCT 

Reply