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?