Importing Pricing: Base Price List Not Found

[former_member594505]

Hello:

In trying to import item pricing using SAP Business One 9.3's Data Transfer Workbench, we are getting the following error: Base Price List Not Found.

I have researched this online and am finding many posts about this error. Some of these posts suggest trying various updates to the LineNum column in the template.

But, no matter what the suggestion is, none of them have helped to resolve this issue.

Has anyone successfully eliminated this error? Thanks!

John

[zal_parchem2]

Hello John - as you have already seen, importing Price List can be a bit challenging, so a few questions.

You say "import item pricing", but there is no field called BasePriceList on the template, only LineNum and PriceList. What does the Excel spreadsheet look like??? Maybe you can attach a screen print - that would help.

If you are importing item pricing, does the Price List you want to populate already exist???

Is the Price List based on

What is the path you are using for the DTW process???

Regards, Zal

[zal_parchem2]

darn - hit Submit too early.

Does the Price List you are populating have a factor (other than 1), and is it based upon a DIIFERENT Price List???

[former_member599925 · Accepted solution]

You need to enter base Price list number in "PriceList" Column. This you can get from OPLN table.

Base Price List Number is the Internal Id of Price list in which you are inserting the Prices.

[agustin_marcoscividanes]

Hi

you have to run this query in Query Manager:

select * from OPLN.

The number you need as base list is the code you obtain in the results of the query.

Agustín

[kothandaraman_nagarajan]

Hi,

Share your template here to check. If you have access to SAP Business one customer portal, you can find SAP note related to this error message.

Regards,

Nagarajan