Skip to Content
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
All Posts คน เหรียญรางวัล
แท็ก (View all)
odoo accounting v14 pos v15
เกี่ยวกับฟอรั่มนี้
คำถามนี้ถูกตั้งค่าสถานะ
discountrulequantitypricelistcalculationbreakpoint
1 ตอบกลับ
5713 มุมมอง
อวตาร
Dan

I'm a newcomer to OpenERP/odoo.

I want to reduce the cost of a product as larger quantities are ordered.

So, example pricing would look like this:

Quantity  |  Price per individual product

1-3 = £200 each

4-5 = £190 each

6-7 = £180 each

8 and higher = £170 each

Users need to be able to simply select a quantity in a sales order / invoice and the correct total to be calculated based on these rules.

How is this achieved?

อวตาร
ละทิ้ง
อวตาร
paul
คำตอบที่ดีที่สุด

You can achieve this type of pricing by using the Min. Quantity field in the Pricelist.

Steps:

  • go to Sales > Pricelists > Pricelists
  • create (or edit existing) a new Pricelist then Pricelist Version
  • then create Pricelist Item for each quantity pricebreak (in your examle you would create 4 Pricelist Items with min qty of 1,4,6, and 8 respectively)

Note:

  • these instructions don't get into all of the details about pricelists.  Pricelists are very powerful and have many options that can be used to decide what products and are affected.
  • the pricelist that you created (or edited) above needs to be applied to the sales order in question
อวตาร
ละทิ้ง
Dan
ผู้เขียน

Thanks, I will give that a go. We have a lot of products that require these price breaks, so I'm assuming a .csv import option is possible too.

paul

yes, you can upload via csv. I have done it many times.

Dan
ผู้เขียน

Thanks for your help, I've configured the price breaks through the GUI. I have two issues: 1. the price computations only seem to work for sales orders / quotations. Can they be made to work for draft invoices too? 2. The rounding doesn't work. I set "0.05" as the rounding bit still end up with prices like £300.02. And setting the rounding to "1.00" produces some very odd totals (more than they should be but by seemingly arbitrary amounts). Any ideas?

Related Posts ตอบกลับ มุมมอง กิจกรรม
Can pricelist / price break points work on invoices?
invoice price rule pricelist breakpoint computation
อวตาร
อวตาร
1
มี.ค. 15
5517
v11 Pricelist : Try Setting Price = Cost + 10% แก้ไขแล้ว
discount price pricelist
อวตาร
อวตาร
1
ม.ค. 24
6727
How to show strikethrough prices on website correctly?
discount pricelist website
อวตาร
0
ต.ค. 22
4294
Is it possible to have the same features of Sales Price Lists in Vendor Price Lists?
purchase discount pricelist
อวตาร
อวตาร
2
ต.ค. 19
4585
Price on sale order is not working when I change the UOM - 10.0 Enterprise
discount uom pricelist
อวตาร
อวตาร
2
ก.ค. 18
5644