Skip to Content
0

Item wise Latest price From Receipt from production

Feb 02, 2017 at 10:14 AM

80

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Nagarajan K 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
10 |10000 characters needed characters left characters exceeded

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
Former Member
prabakaran R

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
prabakaran R 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
10 |10000 characters needed characters left characters exceeded
Former Member

Hello,

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

Thanks

Engr. Taseeb Saeed

0

Hi,

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

0