How to View COGS Value???

[samjalees2000]

Is there any way we can view the value of the material(cogs) in the system?

[former_member183879]

Hi,

For the delivery, COGS value is updated during PGI.

During PGI, a material document is created, for which an accounting document is created.

This material document can be seen in MB03, or accounting document in FS03.

Correspondingly the values of these documents can be seen in the fields MSEG-DMBTR or BSEG-DMBTR respectively for material document or accounting document.

You can find out the accounting document for material document from the table MKPF where material document number should be given as input in the field MKPF-XBLNR

[samjalees2000]

Yes,I know we can see the cogs value at the accoutning document but basically I wanted to know whether it is mantain somewhere else where I can view it before performing the transaction as basically I want to create a report compraing the actual cost(cogs) and sale price(distributor price).

I have heard it is present in the material master???If not,then there must be some place where the system brings the value to hit the accounts after pgi

[jignesh_mehta3]

Dear Friend,

The value is basically a dynamic value...

It depends on your Stock Valuation Strategy... (moving average or Standard... )

Check in Material master - Accounting Screen... Here you can see the Standard Price & Moving Average price...

If it a Moving Average Price, then it would be different after each Purchase & sales transaction is executed...

Hope this helps...

Thanks,

Jignesh Mehta

[bcrao]

Hi,

In account tab- of MM record- you can check the value

Check in sales order/delivery order condition tab ex. VPRS condition type

Thanks

Chidambaram

[Former Member]

Hi,

At the time of Delivery/PGI, COGS entries are passed. You can check the accounting document from there. Go to the document flow & display the accounting document.

Thanks & regards,

Hussain

[jignesh_mehta3]

Hello friend,

In the Account Document of your Delivery Document, the Accounting Entry would be:

Cost of Gods Sold A/c

To Stock A/c.

Here in this Accounting entry you can see the Cost of Goods Sold value that has hit the Profit & Loss A/c as a result of the Sales (Delivery) of Goods.

Thanks,

Jignesh Mehta