Override amount calculation

Frappe Framework Customization
#1

Hi,

I want to override calculation of amount field (purchase order item, etc)
Default calculation as I know is amount = rate * qty

Is it possible to add a custom field and use that as additional variable for calculating amount. For example, I add handling field and the amount is calculated using rate * qty + handling.

Other answer tells to use Doc Events, but the posting date is a bit old (2016). If I must use Doc Events hook, do I still need to recalculate other fields (taxes, grand total, etc) ?

Thank you.

#2

I think it can be done by custom script :slight_smile:

https://erpnext.org/docs/user/manual/en/customize-erpnext/custom-scripts/custom-script-examples

#3

I have tried something like this:

// bussiness logic here
final_amount = item.amount + handling;
frappe.model.set_value(cdt, cdn, "amount", final_amount);

But when I do save or submit document, amount is reverted back to original value (qty*rate).

#4

On which doctype you are doing calculations?

#5

Purchase Order (Purchase Order Item). If it works, I will do on Purchase Invoice too.

#6

then it is Override by controllers .
taxes_and _totals.js
taxes_and _totals.py

1 Like
#7

Thank you, it works.

#8

Hello! How you did it with js script? (before saving)

#9

On public/js/controller/taxes_and_totals.js, there is a calculate_item_values function that calculates rate*qty. You can override it (via custom script).

#10

so how to do that could you give me code example?

#11

Continuing the discussion from Override amount calculation:

Hello, brother this link is not working now… I am beginner in erpnext

will you please help to solve the similar issue I am facing …
my scenario is that I want to calculate
amount = rate * stock_qty
in sales order as well as purchase order …

#12

how we can override calc_item_value() function using custom app

#13

You may review this How to override method in frappe? - #4 by revant_one

#14

This solution talked about doctype class what I need it a core function override