hi
i need one column
SELECT T0.[DocNum], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[OpenQty] as 'Remaining Qty', (T1.[Quantity]-T1.[OpenQty]) as 'GRPO Qty' FROM [dbo].[OPOR] T0 INNER JOIN [dbo].[POR1] T1 ON T0.DocEntry = T1.DocEntry WHERE T0.[DocNum] ='122000427'
For example
Purchase Qty GRPo qty Open Qty percentage
10000 7000 3000 ?
Percentage column need in above query