I am making a solution where I need to pick a generated sales order confirmation from F&O accounts automatically based on confirmation data time.
But here the problem is while posting it's only giving me a confirmation date via ODATA API not a exact time.
The reason why I need time is like our app will execute every 10-15 min where we will be stored a last confirmation datetime and in a next execution we will use that and check if any new confirmation is generated or not. if we found any then we will export and send it to our customer and will store again that order confirmation data time in our DB so again we use that in our next execution to fetch a newly created OC.
Does anyone know how I can get exact datetime while posting an OC?
Order confirmation datetime needed while posting sales order confirmation in F&O
ConfirmationDate is a date field, not a date/time field, therefore you'll never get time from there. If you want, you can utilize CreatedDateTime field, which is enabled on the table (but you may need to add it to the data entity).
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.