Skip to Content
0
Dec 20, 2018 at 12:57 AM

Importing Pricing

433 Views

Hello:

I know that there is a set of ten price lists that can be used in SAP Business One, and I know that you can import pricing into these price lists.

But, I have an Excel spreadsheet that simply has a column of Item Numbers and other columns containing prices for those items.

These other columns have such headings as "Level IV", "Level III", "Level II", and "Level I". I have inserted an excerpt, below.

There is not much of a rhyme or reason as to what the different pricing columns represent, in terms of calculating pricing. It's simply a "flat" spreadsheet.

What would be the best way of importing pricing for these items?

Thank you!

John

Attachments

pricing.png (63.2 kB)