Hi guys,
I need help generating a query for open sales report with "status" of item being picked or not. what card should I use when creating the query. So far this is what I have minus the status colum
select dr.DocNum , c.cardcode , c.CardName , dr.NumAtCard , dr.DocDueDate , dr.DocTotal as Amount , dr.DocTotal - dr.VatSum as Net , dr.VatSum as TAX , dr.DocDate , dr.TaxDate , g.GroupName , u.USER_CODE --dr.* from ORDR DR inner join OCRD C on Dr.CardCode = c.CardCode inner join OCRG G on c.GroupCode = g.GroupCode inner join ousr u on u.INTERNAL_K = dr.UserSign where DocStatus = 'O' and dr.Confirmed = 'Y'
