Skip to Content
Menu
This question has been flagged
1 Reply
1182 Views

Enterprise V15


In our instance I have enabled the ability to search chatter by adding mail.message to our sales module.  My reason for doing so was primarily to be able to run reports on the history of the commitment_date field and see who changed it and when.   Due to the nature of our business, I know this happens often, with most orders having their commitment_date changed at least once3 if not multiple times.

Odoo logs this in teh chatter as an entry with the logged in user and then "Deliver Date: mm/dd/yyyy" if this is an initial entry, or "Delivery Date: mm/dd/yyyy and then a right arrow, and then mm/dd/yyyy.


In my chatter history report I have tried using Studio to add numerous available fields to see these entries with no luck.  I can see "Sales Order created" entries, and others, but nothing regarding the commitment_date changes.


Any assistance on what I may be doing incorrectly is appreciated.   I've only been exposed to Odoo for about 6 weeks and I have no programming background, so I still have much to learn.

Avatar
Discard
Author

Thanks for the insight, Jason.  Commitement_date tracking is already enabled, and changes are reported in the chatter for orders, but I'm trying to get some sort of aggregate reporting of how many changes each order saw, and also calculate overage number of changes over a given time frame (basically me manipulating an export in Excel).  And while the app is "free", it adds 1300 lines of code to our instance, which will result in $234 worth of extra charges each month ($18 per 100 lines), and I'm not sure spending that much to get data on a single field is worth an extra $2800 a year.  Hopefully I can find an alternative method.

I appreciate you responding.

Best Answer

Hi,

You can use free app  Audit Log | Odoo Apps Store

or use python to set commitment_date tracking=True

class SaleOrder(models.Model):
    _inherit = 'sale.order'

    commitment_date = fields.Datetime(
string="Delivery Date", copy=False,​
states=LOCKED_FIELD_STATES,​
help="This is the delivery date promised to the customer. "
"If set, the delivery order will be scheduled based on "
"this date rather than product lead times.",
​tracking=True​)

Hope it help!


Avatar
Discard