Hi ....
What will be the query if we need to add more coloum in my warehouse wise inventory have a report like below.
Selling prices (Price list wise)
Landing Price Batch wise
-------------------------------
SELECT T2.[ItemCode] AS "AZ Code", T2.[CodeBars], T4.ITMSGRPNAM AS "Family Name", T2.ItemName, T0.Quantity AS "Qty", T1.whscode AS "W/H Code",T1.WhsName AS "W/H Name", T0.ExpDate AS "Exp. Date", T0.BatchNum AS "Batch No", T0.PrdDate AS "Mfg. Date", T0.[InDate], T0.[CreateDate],T2.[LastPurDat] AS "Last P. Date", T2.LastPurPrc AS "Last P. Price",TotalValue=(LastPurPrc*Quantity), T2.[IWeight1] AS "Weight Kg" FROM OIBT T0 INNER JOIN OWHS T1 ON T0.WhsCode=T1.WhsCode INNER JOIN OITM T2 ON T0.ItemCode=T2.ItemCode INNER JOIN OITB T4 ON T4.ITMSGRPCOD = T2.ITMSGRPCOD GROUP BY T2.[IWeight1], T2.[CodeBars], T2.[ItemCode], T0.[InDate], T0.[CreateDate], T2.[LastPurDat], T2.ItemName,BatchNum,Quantity,ExpDate,PrdDate,T1.whscode,T1.WhsName,T2.LastPurPrc,T4.ITMSGRPNAM ORDER BY T1.WhsName
Thanks in Advance