Hello I have problem to add new Item in master Data, i run the following Query
Select * FROM ITM1 T0
Left JOIN OITM T1 ON T0.ItemCode = T1.ItemCode
Where T1.ItemCode is NULL
And T0.Itemcode not in (Select itemcode from OINM)
the result shows as follows
Item Code Price list & many more field
But the Item "CGNSK010" is allready remove from the master Data.
So what i do to add new Item
please give me urgent help..