get this error when updating item master data

[jbrotto]

Not sure if there are hidden items or price list in our SAP B1 DB but that is what I am thinking. The error I get When updating an item is "Variation between number of price lists and number of price list for items.

[jbrotto]

Seems also I can't add new item but I could delete item never used.

[jbrotto]

I did a count of the rows in the oitm times opln rows and it is inmaterilly 20 items than what is in itm1 table. Is that the cause?

[kothandaraman_nagarajan · Accepted solution]

Hi,

Refer SAP notes 912994 and 1078992 for workaround to fix above error message.

Regards,

Nagarajan

[jbrotto · Accepted solution]

I figured it was extra items in SAP B1 and what I did was delete any that was in the OITM table but not in the ITM1 table. A simple rule is the number of rows in itm1 tbale is equal to the number of row in oitm * opln