Importing Price Levels

[5454]

Dear All,
We are working on Price Codes where we have one Standard price and 9 price levels. All the prices are different and not based on Standard price. So we are choosing the Pricing Method "Price Override".

May we know how to import these 9 + 1 standard prices into MAS200. We have Visual Integrator. We are working on the file "IM.PRICE" which doesnt have Price to mention. May we know where to populate these 9 + 1 prices?

Thanks a Lot in advance.


-MAS Beginner

 

[davewalden777]

In the data tab you should have at least:
PRICE_CODE_REC - assigned - import mask = 1 and in the
validation tab use method:Expression
and ValSring:IMB$(1,1)<> &quot;&quot; makes sure it's not empty
BREAK_QTY1 - calculated = 999999
IM_METHOD - &quot;O&quot; for override
IM_CUST_PRC_LVL - this is the price level you want, for
example we use levels 1-6 plus R,D,S[retail,specific
company name, sample]
ITEM_NUMBER - item number for pricing
DISC_MKUP_PRCR1 - the price to assign to this price level

If you want price levels 1-9 for some item#, you will need
to do this import 9 times, changing the price level and price for each different level.
All prices are stored in the value
DISC_MKUP_PRCR1 using the IM_CUST_PRC_LVL as a mask.

I just use a .csv file with item#,lvl-1,lvl-2,lvl-3, etc...
I have seperate import jobs set up for each of our
price levels so I can chain them together and import
whatever combo I need.