Variation between number of price list

[Former Member]

Hola a todos tengo el siguiente problema al tratar de entar un Invoice

Variation between number of price list and number of price list for items (A/P Invoice-Row-warehouse code] [Line: 0] [Message 3506-9]

alguna idea

Albert Torres

[JesperB1 · Accepted solution]

Hi Albert,

This is a corruption.

Please check note 1056208 and open a support ticket with SAP.

Thanks,

Jesper

[Former Member · Accepted solution]

Gracias por tu contestacion, donde puedo encontrar la nota a la que haces referencia

Albert Torres

[jitin_chawla · Accepted solution]

Hi Albert,

You can check the Note at the following link :

[1056208|https://websmp130.sap-ag.de/sap(bD1odSZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1056208]

Following is the text of the Note :

Long text

Symptom

When trying to add a new price list or update an existing price list you might come across with an error message "Variation between number of price lists and number of price lists for items [Message 3506-9]"

Note: This situation can happen during import data from external

application and not directly from B1.

Other terms

Price list, update, add

Reason and Prerequisites

FAQ

Solution

In order to fix the corruption that was caused prior this issue

Please run the select query above to determine whether your

databse is affected, please contact the global support center

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)

Regards,

Jitin

SAP Business One Forum Team