cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible in SAP B1 only.

Former Member
0 Kudos

Hi,

I want to find out the ITEM WISE - its Last Purchase Price . Is it possible in SAP B1 only.

Item Details according to item wise -its Last Purchase Price

Plz reply..............................!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Jyotsana.....

Check this report.....

Inventory> Inventory Reports> Last Prices Report.....

Regards,

Rahul

Former Member
0 Kudos

Hi,

Plz tell me that if i want the Item Group wise - Last Purchase Price upto 1 to 5 , than it will show or not

I want, the Item display according to Item Group wise with its Last Purchase Price upto 1-5

Is it possible with the Query or in SAP B1 only.

Former Member
0 Kudos

Hi Jyotsana......

You can get this report through query generator........

You may try this.......

SELECT Top 5 T0.[DocNum], T1.[ItemCode], T1.[Dscription], T1.[Price], T3.[ItmsGrpCod], 
T3.[ItmsGrpNam] FROM OPCH T0 INNER JOIN PCH1 T1 ON T0.DocEntry = T1.DocEntry 
INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode INNER JOIN OITB T3 ON 
T2.ItmsGrpCod = T3.ItmsGrpCod WHERE T3.[ItmsGrpNam] ='[%0]' ORDER BY T0.[DocDate] desc

Regards,

Rahul

Former Member
0 Kudos

This Query works.

Thank you sir ..........!

Answers (0)