Skip to Content
avatar image
Former Member

Cannot Add CASE - SAP BUSINESS ONE

Select Distinct T0.OwnerCode, T0.SlpCode, t0.Cardcode as "Customer#", t0.Cardname as "Customer Name", t0.DocNum as "SO #", t1.ItemCode, t0.DocDate, t0.DocDueDate, t1.OpenQty, t1.OpenQty*T1.price AS 'Open Value', t2.onhand FROM dbo.ORDR t0 INNER JOIN dbo.RDR1 t1 on t1.docentry = t0.docentry INNER JOIN OITM t2 on t1.itemcode=t2.itemcode WHERE t1.LineStatus = 'O' AND t1.OpenQty > 0

Hi all,

on above i am trying to add a case to show Document Owner Name? Also Under SlpCode it seems to be one number out, as such i need to deduct -1 to bring Real Sales Employee Number.

Thanks

SQL
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers