Item wise Latest price From Receipt from production

[former_member320372]

Hi All,

How to take item wise latest price from the receipt from production(OIGN) table. It should only show the latest price. This report should contain the DocNum, Date(Latest date),Item code, Price.

[former_member320372]

Hi Taseeb Saeed,

Thanks for the reply. This report doesn't show the latest price for all item. It's skip some items from the report. Can you help me?

[Former Member]

Hello,

It will show only those items which are entered in Good Receipt ever.

Thanks

Engr. Taseeb Saeed

[former_member320372]

Hi,

But i want the details from receipt from production table, Which is part of production process.

[kothandaraman_nagarajan]

Hi,

Could you explain your requirement with an example? Which valuation method is used for receiving items? Why do you need such report?

Regards,

Nagarajan

[former_member320372]

Hi,

I want to take this report to view the latest COGP (Cost of goods produced). SO that i can identify the amount spend to produce that particular item. Based on this report i will plan for cost reducing.

Ex:

ItemCode(IGN1) Latest Receipt from production date(OIGN) Receipt from production No(OIGN) Receipt from production price(IGN1)

[Former Member]

Hello,

Try this

SELECT 
DocEntry
, ItemCode
 ,Dscription
 ,Price
 ,DocDate


FROM IGN1 


WHERE	CAST(DocEntry AS NVARCHAR(50)) + '-' + CAST( LineNum AS NVARCHAR(50))
IN (


	SELECT 
		CAST(MAX(DocEntry) AS NVARCHAR(50)) + '-' + CAST( MAX(LineNum) AS NVARCHAR(50)) [Key]
	FROM IGN1 
	GROUP BY ItemCode


	)

Thanks

Engr. Taseeb Saeed