Item wise Latest price From Receipt from production

Question

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.

Answer 1

Nagarajan K Answered Feb 02, 2017 at 12:30 PM

0

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

Show 2 Share

2 Comments

prabakaran R

Feb 03, 2017 at 12:07 PM

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)

0

Taseeb Saeed

prabakaran R

Feb 05, 2017 at 11:08 AM

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

0

Comment

Answer 2

prabakaran R Answered Feb 06, 2017 at 05:57 AM

0

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?

Show 2 Share

2 Comments

Taseeb Saeed

Feb 06, 2017 at 11:27 AM

Hello,

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

Thanks

Engr. Taseeb Saeed

0

prabakaran R

Taseeb Saeed

Feb 06, 2017 at 11:42 AM

Hi,

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

0

Comment

Find Questions & Answers

Item wise Latest price From Receipt from production

2 Answers

Find Questions & Answers