Skip to Content

Item wise Latest price From Receipt from production

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 02, 2017 at 12:30 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Feb 06, 2017 at 05:57 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded