Cost of Goods Sold calculation ?????

rinki123

Hi Experts,


Can anyone explain me that how can I Show Cost of Goods Sold calculation separately in Navision for Item and Transaction wise, for example- I have purchased one Item and using it in transforming a Finished goods,I want to check price of that particular Item in every stages when I purchased it and when it converted into Finished Goods and price has changed and if some overhead charges are also incurred then what is the final price for that Item?????


Cost of Goods Sold = Opening Stock+Purchase+ Manufacturing Expenses+Overheads - Closing Stock
or

Sales - Profit = COGS.

veeravi

If you are using MFG module, go to costing--> reports--> detailed calculation then filter the item you want it.

rinki123

veeravi wrote:

If you are using MFG module, go to costing--> reports--> detailed calculation then filter the item you want it.

Thanks but what about COGS???

Alex_Chow

Have you seen this?
http://www.dynamicsnavconsultant.com/20 ... e-cpa-way/

rinki123

Alex Chow wrote:

Have you seen this?
http://www.dynamicsnavconsultant.com/20 ... e-cpa-way/

I want Item wise report,like; Item Purchase Price+Overhead+Charges(500+50+50)=600 is the COGS Price of that Item now I am selling it in 680 rupees,means profit =80 rupees(Sales-Cogs = Profit)

I want to view COGS, Item Wise.

Alex_Chow

Look at the Cost Amount (Actual) column on the item ledger. That is your COGS.

Becareful about this though:
http://www.dynamicsnavconsultant.com/20 ... true-cost/