Hi All,

In Inventory it seems there are two places we can enter prices: in the Edit Items function in the Base Price Field, and in Edit>Alternate Price Lists>Alternate Price List Items then in the Base Price field for the particular item.

It seems that when an item is placed into an order in Order Entry, OE pulls the price for the item from the price list. When I create the report Reports>Price/Sales Analysis Reports>Price List the item's price is pulled from the Edit Items Base Price field.

So, my question is - is there a way to only fill in one of these fields and automatically populate the other, or are we doing something wrong?

Thanks so much for all your help!

Cam

Hi Cam,

Indeed there are 2 different places to put prices for items.

When entering an Order Entry order, there is a Price List field on the detail screen when entering the item. If this is blank, then the Base Price from the Edit Items area is used. If it is not blank, then the Alternate Price List base price is used. There are more rules regarding Alternate Price Lists (such as what if the Price List code doesn't have the item), but this is the basic theory.

The idea behind Price Lists is that you can assign them to customers and give certain customers different pricing than others. What is it that you want to see happen? Would you prefer that every customer gets the same price for an item, or that different customers get different prices? Perhaps if you describe the desired end result, we can offer the best way to set that up.

There is a function in Inventory to update the Alternate Price List base price from the master Item, so there is a way to automatically popuate the Alternate Price from the regular price.

Hi,

Now that you explain it, it sounds like we would find Alternate Price Lists valuable.

What I'm trying to do is print off a price list for a bunch of our items, but the report seems to pull from the Edit Items Base Price field.

Is there a way to populate the alternate price list from the master item for all parts, only if the master item has a base price larger than $0? I've looked at the function already and can't see anything, but I was hoping you guys knew a way.

Thanks!

Hi Acrylon

If the automatic update function that Softrak discusses up above isn't sensitive enough, you can always export prices to Excel, massage the data there, then use the Import function in Adagio to update Alternative Price Lists. It's a little more complicated, but not too terrible.

Steve

Thanks Steve, I like that idea.

Have a great weekend!