Skip to Content
Menu
This question has been flagged

Hi all,


I am trying to make a field in the model accoutn.invoice.report. 


This field is to supply me with an average age of overdue invoices. Now the filtering I want to take place in my report (using Dashboard Ninja), but the number needs to come from the dataset. 

I have defined a custom field 

x_average_age

As dependencies I have:

invoice_date_due

My compute is:

for record in self:
  record["x_average_age"] = (datetime.today() - datetime(record.invoice_date)).days/365

I have no idea why this would or wouldn't work. I hope someone can help.


Avatar
Discard
Author Best Answer

bump?

Avatar
Discard
Related Posts Replies Views Activity
1
Nov 24
110
0
Aug 24
237
2
Jul 24
414
1
Jan 24
424
2
Apr 24
1952