Skip to Content
avatar image
prabakaran R

Item wise Latest price From Receipt from production

Feb 02, 2017 at 10:14 AM | 85 Views | Last edit Jun 08, 2017 at 06:22 AM 3 rev.

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.

SAP Business One
SAP Business One SDK
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Nagarajan K
    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
      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

  • avatar image
    prabakaran R
    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