Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Order confirmation dat...
Finance forum
Answered

Order confirmation datetime needed while posting sales order confirmation in F&O

Posted on by 72
Hello Experts,
 
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?
 
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 228,135 Most Valuable Professional on at
    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).

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans