Navision 2009 Time Stamps

Good day,

 

Is there a function/code to query the time/time stamp an entry was posted/committed within Navision?

 

I want to automate a report which will work on the basis that if an entry was posted within the last 5 hours and and condition x is not met, then the automated report will reverse the transaction based on Current Time-Processed Time>=5 hours

  • Hi,
    I suggest you to create a new field in your table and write a code to update this field when the entry is posted with the current date time i.e.
    after the entry is posted:

    field:=CURRENTDATETIME;
    TABLE.modify(true);

    So you can query it with this date time field.
Related