Importing Pricing

[former_member594505]

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

[zal_parchem2 · Accepted solution]

Hello John - this is rather straightfoward. You can DTW the information into SAP B1 by using two TXT (Tab Delimited) Files.

One contains the Item Code.

Second contains the ParentKey, LineNum, PriceList, and Price.

I generally do one Price List at a time as a "Best Practice". Gives the User a chance to sign off on each and every Price List.

For some unknown reason I cannot attach a screen capture to show you the headers today - strange. okay - worked around that problem.

If you have any questions, you can reach me at zalparchem@bellsouth.net

Best Regards - Zal

[zal_parchem2]

Hello John - and a very Merry Christmas to you also. Thank you for your kind words

SAP has this: SAP Help Portal for DTW

Maybe try the SAP Business One Academy: SAP Business One Academy

But I am not too sure how applicable these are to someone starting out. To be honest, a lot (and I mean a lot) of the tricks and nuances I have are from pure sweat and blood figuring out these things over the years. Some folks might say that the "Import/Export" function under the Administration Module is easier, but I find you will encouter as many problems there as with the DTW - just my experience, maybe you might find otherwise.

However, there is one thing I do have which you might want to look for and that is the SDK Help File. Mine is really old and you might want to Google that. All of my old URLs before the SCN change are gone, so unsure how to get one now. But reviewing the information in the SDK Help File helped me to understand data and enumerators and and and...

One more point - the DTW samples and templates. I try to use as little as possible from each one of those AND I keep a personal copy of all DTW spreadhseets which were successful. Just keeping the copies have saved me a world of headache!!! Here is where I used both DTW and the Data Import/Export Function with one Customer.

Regards - Zal

[zal_parchem2]

This just hit me this morning when I got into the forum.

This Displayed Line Number is true for any area (Warehouses on Item Master, Lines on Sales Orders, etc., etc.).

See this Blog:

LineNum or VisOrder - Which One to Use???

Regards, Zal

[former_member594505]

Hi Zal:

That was it! Thank you, so much! You're a class act!

I'm going to mark your post as "Accepted". But, at your convenience, do you know of a manual or user guide of some kind that I can download that explains how to format such DTW files?

For instance, it seems odd to me to have a column for the price list if the LineNum column designates the location of that price list, anyway.

Regardless, thank you so much, Zal! Merry Christmas!

John

[former_member594505]

Hi Zal:

I'm getting an error saying "Base price list not found".

Attached are my two files.

Why am I getting this error, and how do I eliminate it?

John

price-list-import-test1.txt

price-list-import-test2.txt

[zal_parchem2]

Hello John - looking at your files I see there might be some data incorrect???

First let's talke about LineNum and how you get it. When you look at the Price List screen with Inventory Module > Price Lists > Price Lists, you will see the Price List Numbers in the left-hand column, and you will need to do a calculation with that:

LinNum in the DTW is equal to the Price List Number displayed on the window minus 1.

So, diplayed in the left-hand column is a "1", which means LineNum 0 = PriceList 1, LineNum 1 = PriceList 2, LineNum 2 = PriceList 3 and so on. Always what is displayed is PriceList and then take 1 from that to get the LineNum...

What you sent has LineNum 0 and PriceList 2, which means you might be one number off. LineNum 0 = PriceList 1.

You are almost there - keep tying and remember "Run As Administrator".

Regards - Zal

[Abdul]

Please explain what are these levels I believe these are different prices for different group of customers. If this is the case then you can upload this in different price list and assign price list to relevant customer

[kothandaraman_nagarajan]

Hi,

You can try with Import From Excel under Administration->Data import/Export-->Data Import-->Import from Excel-Price list.

Regards,

Nagarajan