Skip to Content
0
Former Member
Jun 15, 2011 at 06:56 AM

Error while executing one query in SAP B1

11 Views

Experts,

select

T0.U_ItemCode,

T0.U_ItemName,

T0.U_Forecast,

SUM(T0.U_mrpqty)'Simulated Qty',

(select sum(onHand) from OITW T1 where T1.ItemCode = T0.U_itemcode) 'Current Quantity',

(select T3.ItmsGrpNam from OITM T2 inner join OITB T3

on T2.ItmsGrpCod = T3.ItmsGrpCod where T2.ItemCode = T0.U_itemcode)'Item group name'

from "@QUOTA1" T0

where T0.U_ItemCode = '[%0]'

and T0.U_Forecast = '[%0]'

group by

T0.U_itemcode,

T0.U_itemname,

T0.U_Forecast

When i run this query in Query Manager, it gives error

'User-Defined Values' (CSHS)

'Service Contracts' (OCTR)

What might be the issue?