![]() PS I also tried running it on A.Docdate >= but its not working. WHERE A.Docdate >= and A.Transtype NOT IN ('15', '59', '67') and A.LocCode not in ('LLD', 'THD') SELECT 'CN TO PRIMARY WHs' as 'Type', A.CreatedBy, A.Transtype, A.DocDate, A.ItemCode, A.InQty, A.OutQty, A.Price, A.LocCode, A.SumStock, A.Usersign,CASE WHEN A.Transtype = 13 THEN 'AR INVOICE' WHEN A.Transtype = 15 THEN 'Delivery 'ELSE 'Others' END AS Document_Type ,A.Base_Ref as Docnum WHEN A.Transtype = 10000071 then 'Inventory Posting' WHEN A.Transtype = 20 then 'Goods Receipt PO' WHEN A.Transtype = 59 THEN 'Goods Receipt/Receipt from Production' WHEN A.Transtype = 60 THEN 'Goods Issue/Issue for Production' SELECT 'CN TO PRIMARY WHs' as 'Type', A.CreatedBy, A.Transtype, A.DocDate, A.ItemCode, A.InQty, A.OutQty, A.Price, A.LocCode, A.SumStock, A.Usersign,ĬASE WHEN A.Transtype = 13 THEN 'AR INVOICE' *** This software was recommended and shared by Ed Yap.First query below is working because the parameter is static, but if i set a dynamic parameter then it will return an error. ![]()
0 Comments
Leave a Reply. |