In my limited use of inventory in Sage 50 I would suggest that if you have an item which you sell individually as well as by the case lot, it would be best to create a separate part number for the item by case. By doing this you can have cases stocked as well as the units separately. You would create case lots by using the Inventory Assembly to put 12 items in one case. Or, if you buy in case lots you could use item assembly to take one case and create 12 items. This would also give you more flexibility with your pricing.

js2015 said:

The problem is when I print price list from report, I only can see case price. How can get report show both piece and case price?

Hi,

If you're using Sage 50 Canadian, the price list report may have the capability of showing multiple prices in the list.

How, specifically, are you getting the report from Sage 50?   Is it the report under Reports | Inventory & Services | Price List?   File | Import/Export? 

I thought that you meant that you had set up different price lists that the person keying the invoice would manually select, and now you wanted to get a report of those prices.  To do that you would just add columns to the price list report.

Sage 50 Canadian does not have a feature that will automatically set selling prices on a sales Order / Quote / Invoice, based on quantity sold. 

It looks like someone else answered your question, if you were asking about setting up different buying vs stocking vs selling units of measure.

In the Sage 50 Inventory module each item can only maintain one unit for sale. You are trying to set up the inventory item with sales in two different units. If you sell the item by each then all of the various price lists refer to the price for each. If you change the selling unit to case then all of the various price lists refer to the case price. This is why you need to have to items in inventory. For instance one item might be number A1050 and the selling unit is each and the other item could be A1050C with a selling unit of case. Another example would be if you have the same product in three different sizes of bottles each one would need its own inventory item number. To carry this further if you sold these bottles in case lots, by the skid you would need a number for each size of case and another item number for each skid lot. Yes, it sounds like a lot of inventory items for the same product but it sure helps to control and count inventory. You can print a report showing each item with all of the various price lists used but not with different selling units.

Clyde,

Alwyn said:

In the Sage 50 Inventory module each item can only maintain one unit for sale.

Not quite.

Using Universl, sell item H1020 and it will sell for a unit "each" for a specific price (in my file $25).  When I then switch the units on the sales invoice to Case, it will sell for $250 (10 units per case * $25 each).  See the units setup of that item.  This prevents the need to set up multiple items for different units when the pricing is linear and I think this is how js2015 set up his/her item.

If the unit price is $25 with 10 units per case and the case price is $200, this option does not work without using different price lists or overriding the price.  So some people will use your idea of setting up new items.

js2015, have a look at the MS Office Documents utility on the Report menu.  Run the report for Price List with Different Units of Measure, Different Prices.  This requires Excel and that you have Third-Party rights set to at least Read-only in the security setup of your userid.

Thanks Richard, it is obvious that I have not used that feature. My client that uses inventory has different items for each unit of sale.Thank you for jumping in on this.

Hi Richard,

Thanks a lot for sharing, that’s exactly what I need.