how to manage a same item with different prices?

[former_member610350]

we are working on SAP Business One and are having SAP Customer Checkout on retail stores. Here we are managing a warehouse which do all the purchasing and also transfers goods from the warehouse to the retail stores. we are facing a issue of making a whole new item once the price of the same changes . we cannot change the old item (which is with a different price) because we also at the same time have such items (with the old price) in our stores. For example there is a toothpaste of Rs.50 in our stores but now company has changed the price so the price is Rs. 52 in such cases we have 2 variants of the same toothpaste in our stores one with price 50 and the other with price 52.insuch cases we are forced to make a new item which results into a set of problems .Now the item list has almost 2000 extra items. All this makes the order list quite inefficient and same goes for the transfer list which makes placing order or issuing goods a hideous task. Also the sale price and the purchase price keep changing with the price. Please suggest some solution.

[JoergAldinger]

Hello Vinod,

I don't think it is good practice in general to create multiple item codes for the same article just because of a price change. As you explain in your post, there are multiple problems caused by this situation.

I think you might have to look into creating different price lists (one for each retail store), so that you can independently modify prices in each store from B1. Of course, you may have to employ some useful tool (query, alert, report, price update wizard, 3rd party price update addon, or otherwise) in order to keep track of prices in the different retail stores and adjust them with the least effort possible.

But I would definitely try to eliminate all duplicate items.

Hope this helps.

Best regards,

Joerg.

[former_member610350]

Thank you Joerg ,

But we also have different prices but same product in a single store which makes it difficult handle . And hence the price list is almost same for all the stores (with too many items ). Could you please suggest some other way to handle this ?

Thank you !

Regards

Vinod

[JoergAldinger]

I think you should consider pricing the same item in the same way. Having different prices for the same item based on when it was originally bought is a nightmare to manage for the seller and almost certainly incomprehensible for the buyer. Are you actually selling the same item in the same store for two different prices? If the customer does buy two units of the same item and you charge two different prices, do you not get a complaint?

If you do want to keep doing that, then I would look into printing custom barcodes for the items that include the price, and then take the price from the barcode when scanning it in CCO. Kind of like what is done in supermarkets when you buy meat or cheese, where the barcode incorporates the item code and the quantity at the same time...

Hope this helps...

Joerg.

[former_member619657]

Hello Vinod,

According to me, this can be done using multiple uom groups, multiple barcodes and multiple price lists for an item.

Hope this helps.

Best regards,

Hemant