Cost of Goods Sold calculation ?????

rinki123 · 2011-06-11

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 · 2011-06-11

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

rinki123 · 2011-06-13

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 · 2011-06-13

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

rinki123 · 2011-06-14

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 · 2011-06-14

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/

Cost of Goods Sold calculation ?????

Comments

Categories