Item Price List Change Log History Query workaround

[kedalenechong]

Hi All

Please help rectify my Item Price List Change Log History Query. The first Query result is fine but once I added AITM the Query hangs. I just need to include AITM Update Date to make perfect the Query.

SELECT T1.[ItemCode], T1.[PriceList], T1.[Price], T1.[Currency], T2.[Price], T2.loginstanc FROM OPLN T0 INNER JOIN ITM1 T1 ON T0.[ListNum] = T1.[PriceList] INNER JOIN AIT1 T2 ON T0.[ListNum] = T2.[PriceList] WHERE T2.[ItemCode] =[%0] and T2.[PriceList] ='1'

SELECT T1.[ItemCode], T1.[PriceList], T1.[Price], T1.[Currency], T2.[Price], T2.loginstanc, T3.UpdateDate FROM OPLN T0 INNER JOIN ITM1 T1 ON T0.[ListNum] = T1.[PriceList] INNER JOIN AIT1 T2 ON T0.[ListNum] = T2.[PriceList] INNER JOIN AITM T3 ON T3.loginstanc = T2. loginstanc WHERE T2.[ItemCode] =[%0] and T2.[PriceList] ='1'

Kedalene Chong

[Harish_Vatsa]

Dear kedalene.chong,

Please remove the extra space in your 2nd query

T2. Loginstanc --> remove space between T2 and Loginstanc

Thanks,

[kedalenechong]

Hi Harish

I edited but still got T3.loginstanc = T2. loginstanc error. The Query shows both AIT1 and AITM Log instance but Log Instance is not visible on Database Field in Query Generator.