Skip to Content
0
Former Member
Sep 02, 2008 at 07:04 AM

PriceList Name on Item Master Screen

365 Views

Dear all,

SELECT T0.ItemCode, T1.PriceList, T2.ListName, T1.Price

FROM OITM T0

INNER JOIN ITM1 T1 ON T0.ItemCode = T1.ItemCode

INNER JOIN OPLN T2 ON T1.PriceList = T2.ListNum

this query i get say eg ABC Item all the 10 price lists Names. But if you see in item master, Item ABC, you will see only one price list name displayed. How to get that name in the query for that particular item ABC. Since that is the default pricelist name displayed on Item master screen. How to get that name.

Regards,

Murtaza