Variation between number of price lists and number of price lists for items

[Former Member]

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

CGNSK010     1

CGNSK010     2       

CGNSK010     3

CGNSK010     4

CGNSK010     5

CGNSK010     6

CGNSK010     7

CGNSK010     8

CGNSK010     9

CGNSK010     10

But the Item "CGNSK010" is allready remove from the master Data.

So what i do to add new Item

please give me urgent help..

[Former Member · Accepted solution]

hello to All

I solve it