Sorry Robin, I’ve missed your question re this issue. I’ll try to find out and let you know.

Hi Robin,

To clarify, you are referring to the creation_datetime of the transaction log entry?  If so, isn’t this populated automatically unless you supply it in the API by the business logic?  I haven’t tried doing the API without supplying this value to see what happens but was just thinking.

If it is a different column or entity, let us know.  The question has been raised to R&D by both Joshua and myself.  I don’t think there is a way the API itself can retrieve a  getdate() like value but this is being confirmed.

Hi Phil, 

Yes i am, if the field is not supply in the API, the created at and actual date will not be automatically filled by business logic.

Hi Robin,

After doing some research I cannot find a way embed current Date/Time within the API.

Unfortunately module order_changes_log does not auto populate creation_datetime.

However if you are planning to build a Process Flow, this can be easily added in the input file or sql.

If you are using a sql query as an input, you can add a current date/time and use it as the input.

Hi Joshua,

Thanks for the research, i have to use it in a “when a event occurs Process Flow” that also triggers a outbound message to our customer when Status changes and write a message to order_changes_log so our agent can see that message is send.

For the date i have created a formula in the formula manager that i use in de API

Formula: #YYYY+-+#MM+-+#DD

Only the time formula #TIME gives not the right format so i cannot use that.

So for time i will use fixed time for now.

Thanks again, 

Robin.

If this is important for the business, I would ask IFS to customize order_changes_log BO. This would be a small change.

Yes, for us it is important for the business.

Thanks..