Anyone have documentation to show how to setup price lists? I’m trying to follow along but not completely sure I understand. Definitely can’t find anything on importing a price list.
Go to data import doctype and type price list. Download the template, fill the necessary details and import back
By the way i dont think its appropriate to use 115 price lists
Got it. So that’s what I thought originally too - too many price lists.
So, any suggestion? My original idea was to assign one supplier per item and that seems to be okay. Only issue is I need to figure out how to pick supplier in sales order item table and then have it only show items that are from that supplier.
Should I maybe create Supplier Code as Item Group? Then, I can filter on Item Group using a script like this on the Sales Order Item doctype? So, sales person would choose Supplier Code (Item Group) and then it would only show Items in that “Item group”? Do you see any reason to not do this? I would have 115 Item Groups.
frappe.ui.form.on (“Sales Order Item”, {
supplier_code: function(frm) {
cur_frm.set_query(“item”, function() {
return {
“filters”: {
“item”: frm.doc.supplier_code
}
};
});
}
});
What is the reason of fetching supplier in sales order? Will you have different sales prices for that item
If selling prices are different than better to create separate items
115 price lists might sound too much for some. 115 supplier for the same item sounds too much to others.
It is a matter of “how to ease the pain”. Let us know how you cleverly solved it 
Well, I’m a little torn. I don’t know exactly how to use the price lists and I can’t find a good explanation of how they work.
115 Suppliers but not all supply same products. One supplier might have A, B, C and another might have C, D, E but they both have item C. Make sense?
Yes, selling prices are different. We are in the plant industry. If one grower sells his cheaper, we might buy those til he runs out and then we have to use a different grower with increased price, etc…
Pricelist1 → for A,B
PriceList 2 → C(a) for supplier a
PriceList 3 → C(b) for supplier b
PriceList 4 → for D,E
You will need to apply set theory and find common products where prices differ and create those differentiated price lists. The rest are all 1:1.
Hope this helps. Create a price list for buying and see how it works.
1 Like
If I understand the price lists, then I would create a new price list for every single vendor (115 of them) by going in and Import the names of the list first where you said.
Then, I would import all of my items with a default supplier listed and then go to doctype Item_Price and upload the pricing with the price list linked?
That’s a lot of steps but I’m good to do it if it works best.
How does the system know which price list to use when I select the item on the sales order? Do I need to add a linking field there or it knows automatically when I select the item?
Where do you select it? If you are creating a PO, you need to click the supplier and the correct price for that item and that supplier would appear.
What you are thinking is comparison shopping cart. I dont think that is available.
What i mean by that? You browse items and see 5 different prices for 5 different vendors and then choose which one to order. It is a nice functionality. But it is not available [atleast i dont know how to make that work without some customization]. What price lists does is, matches price to item to supplier.
Let me know if you find any alternatives. Best
Thanks again! I really appreciate your help.
Here’s what I want.
-upload item and assign it to default supplier with supplier name and supplier code
-every supplier has a 2 digit supplier number/code
-in sales order item table, select supplier number in first column, then FILTER item based on supplier code link
I don’t think it’s that hard but seems to be much more difficult. Does this help to see maybe what I am doing wrong? I’ve tried making supplier number as dynamic link but it wouldn’t do that and I tried linking but I don’t know how to make this work.
Ok. You can have only 1 supplier per PURCHASE order. You cannot specify which supplier in the SO.
So I dont know exactly what you are trying here
If you are making a Sales Order, then you have to select the supplier first. Not something you can choose by filter per item.
I would suggest you map the process. Maybe you want to make a Material Requisition (MREQ) for your sales orders (SO) first. And then the buyer created different POs to procure those based on the best price. And here : you need to split the MREQ to PO based on Prices. That is why you need a shopping comparator : where for each MREQ item, you can choose which supplier to allocate (if you can see those different prices for that 1 item) and CREATE individual PO or collective PO.
So i think you need to rethink the process and have a bit of customization. And i think this would be super beneficial for you and the community.
Best
WHOA! So I cannot build a sales order for a customer with multiple suppliers? For instance, we order plant A from supplier A and then plant B from supplier B on the same sales order?
My workflow was one sales order for whole customer order which is from multiple suppliers. Then, create purchase order for each supplier based on sales order. This seems to be pretty common with other ERP systems that I looked at. Is that not possible with ERPNext? I haven’t seen anywhere that you can only have one supplier for one sales order.
My bad. What I was trying to say was 1 supplier per PO.
Oh whew! Yes, 1 supplier per PO. PO generates after you create sales order and it will generate based on supplier.
So, back to question of how to filter the second column after choosing first column in Sales Order Item.
I documented our workflow as you suggested. I am stuck on two things. Linking Supplier Number to Item. Filter second column of Sales Order to only show Items sold by supplier that you select in Column 1.
Hi Heather, try to disconnect SO form PO. Your SO should be agnostic where it comes from. In the SO, you should postpone the decision as to where it comes from. [assuming selling price is the same no matter what]. Then make a material requisition MREQ to fulfil the SO. Then create a PO the best way as the most optimal price. here you need a customisation to choose different supplier by item and route your drop ship orders.
Build a small customisation and it will save you a lot of headaches.
Cheers
Thanks for the suggestion. I understand that would be ideal but not how our industry works.
Suppliers might have the plant we need today but not tomorrow so inventory fluctuates rapidly. We have to create the sales order based on the supplier’s stock and/or quality.
WE are the middle man between customer and supplier and it is our job to source the highest quality based on customer. WE are the ones that determine the supplier because we know cost and quality. So, we create each sales order for the customer based on our knowledge and relationship with them. (some customers like cheapest price, others want highest quality, etc…)
We receive the order and immediately source the products by calling or emailing the suppliers to see what they have and sometimes we have to get pictures and then we process the order. The customer relies on us to generate the sales order. Price is different from each supplier. Even if both have item A, price might be $5.00 from one supplier and $6.50 from another. We charge different price to customer based on where we get item from too.
ok make up your mind.
An iphone5 is an iPhone5 is an iPhone5. Either they are the same product sourced at different prices.
OR they are different products. if quality differs they are not the same.
Try a different idea. when you get a sales order use the supplier portal to give you quotes RFQ. Let then enter product codes as per thier availability (of stock). Convert those RFQ into PO and you are done.
In any case you have to coordinate availability via phone with your supplier. this way put the burden on them. Then combine it and and create a SO (might need customisation) for fulfilment from you to your customer and a PO to drop ship the orders.
I seem running out of ideas other than some customisation. cheers
haha. Yes, I’m a bit all over the place because I keep trying to see if I can make it work like the suggestions. Sorry for that!
They are different products due to quality so let’s leave it at that.
One product=one supplier only.
Supplier=multiple products.
I’m back to square one now. I need to select supplier and then filter product on their list of products. Seems simple enough but I can’t do it. Any help on dynamic link so when supplier is selected, it only shows products linked? Is that the right direction?