Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Variation between number of price list

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

replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question