[NEW FEATURE] Quoted Item Comparison

Hi everyone,

I’ve been implementing a new report called Quoted Item Comparison, which is now one of the Supplier Quotation reports. It was developed in order to be able to analyse a number of quotes and pick out the best supplier for each of them. One of the key things here is that if you have more than one quantity specified for each item, it will chart these for you so you can see the price breaks.

To use it, go to Buying >> Supplier Quotation >> Reports >> Quoted Item Comparison. Enter your Item code and all the quotations with that item will be included, showing quantity breakdowns and a link to each quotation (so you can see if there are any additional charges, stipulations, etc). If you want to see a plotted graph showing the price breakdowns, use Menu >> Print. Here is an example of the table and plot:

There is also a Tools menu in the report that allows you to quickly assign a default supplier for the item right from the report. If you click Tools >> Select Default Supplier, a dialog box with a list of the suppliers that had provided quotations is popped up. You select the supplier from the list then click “Set Default Supplier”

It’s just come out, so there may be ways to improve it. Please let me know if you have any suggestions.

10 Likes

Throws an error:

Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 61, in application
response = frappe.handler.handle()
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 21, in handle
data = execute_cmd(cmd)
File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 56, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 1013, in call
return fn(*args, **newargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 495, in wrapper_fn
retval = fn(*args, **get_newargs(fn, kwargs))
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/query_report.py”, line 179, in run
result = generate_report_result(report, filters, user)
File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/query_report.py”, line 66, in generate_report_result
res = frappe.get_attr(method_name)(frappe._dict(filters))
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/buying/report/quoted_item_comparison/quoted_item_comparison.py”, line 10, in execute
qty_list = get_quantity_list(filters.item)
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/buying/report/quoted_item_comparison/quoted_item_comparison.py”, line 69, in get_quantity_list
qty_list.sort(reverse=False)
TypeError: ‘<’ not supported between instances of ‘_dict’ and ‘_dict’

Hi Ben.

Do you have any idea why it was deprecated since v11?

It was really helpful. And can’t find any other way than manually input at every item master its Default Supplier.