How to add calculated value in treeview for Sales Order - value of invoice paid?

Question

Dear all,

I am trying to customize Sales Order treeview by adding column with value of amount to be paid. Situation is as follows - I have sales orders which has partial invoices attached (and paid). So each Sales order has few invoices. In tree view of Sales Orders main value users can see is Total amount of specific sales order. What I would like to do I would like to add value of amount to be paid.

I have found fields that I can base my calculations (from sale.order object):

amount_total
i

Mariusz Mizgier · Answer

Easiest way to approach that would be by development - you have to add a field.function, which will return the value of amount to be paid - adding that field via UI is impossible, as Settings -> Database structure -> Fields doesn't support fields.function.

Create simple field, add a function, which will return result you want, add that in tree view and voila.

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Minimum Lot Charge For Sales Order Line Items v7	0 jouluk. 24	9501
Record Rule to allow a User to update their own Employee object without belonging to Officer group Ratkaistu v7	3 syysk. 24	21755
How to activate the Technical Features? Ratkaistu v7	5 jouluk. 24	53042
Way to only allow a specific DB to be the default? Ratkaistu v7	4 heinäk. 24	10611
How to correct the decimal precision in email template? Ratkaistu v7	7 elok. 23	11007

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!