تخطي للذهاب إلى المحتوى
القائمة
لقد تم الإبلاغ عن هذا السؤال
2 الردود
1474 أدوات العرض

Hi, is there some way I can change the Sales Order reporting graph to use 'Creation Date' as its X axis rather than 'Order Date'?   
I tried to edit the graph with the Studio, but 'Creation Date' is not in the dropdown list for the First Dimension and I cannot enter a manual one as 'order_id.create_date' like I would when making an advanced filter.

Is this possible? 

thanks,

James

الصورة الرمزية
إهمال
أفضل إجابة

This happens because the create_date field does not exist in the "sale_report" model, which is the model used to create the reports, therefore the "sale_report" model should be inherited from code, add the create_date field and inherit the methods that load the reports. data in the view so that it also loads create_date. (Don't forget to add "sale" to the module dependencies). Then


Inherit model "sale_report" and add field:


class SaleReport(models.Model):  
​_inherit = 'sale.report'

​create_date = fields.Datetime('Order Date', readonly=True)​


The function that loads the data into the view

def _select_sale(self):

In this function you should add a line similar to this:

s.create_date as create_date

You can then edit the chart and change the date field to create_date

الصورة الرمزية
إهمال
الكاتب أفضل إجابة

Thanks Pablo, I've passed the info to my developer. It sounds straightforward enough 

الصورة الرمزية
إهمال
المنشورات ذات الصلة الردود أدوات العرض النشاط
purchase module تم الحل
1
أغسطس 22
1819
1
يونيو 25
1505
3
يوليو 25
3198
1
مايو 25
1335
1
مايو 25
1590