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.

Powiązane posty	Odpowiedzi	Widoki
Minimum Lot Charge For Sales Order Line Items v7	0 gru 24	9558
Record Rule to allow a User to update their own Employee object without belonging to Officer group Rozwiązane v7	3 wrz 24	21801
How to activate the Technical Features? Rozwiązane v7	5 gru 24	53105
Way to only allow a specific DB to be the default? Rozwiązane v7	4 lip 24	10639
How to correct the decimal precision in email template? Rozwiązane v7	7 sie 23	11050

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!