Finance | Project Operations, Human Resources, ...

Get date time stamp of Sales Line, LineStatus field data update.

(0) Share

Report

Posted on by SA-15031413-0

I am working on a customization of an SSRS Report. The main data of my report is retrieved from SalesLine, one of the fields I have, I want to populate it with the dateTime stamp of whenever the data updates/changes of the Line Status field in SalesLine.

So, I wanted to ask if there is some sort of history maintaining table where this specific case is maintained, or a workaround to get this data.

I do have a solution in mind, but it is pretty extensive, to fetch all related records to each Line Status. for example, if it was updated to Invoiced, then I fetch the related invoiced line table (custInvoiceTrans), and use its createdDateTime as my field, but as I said, this is very extensive as there are many processes like these.

Kindly Help.

Categories:

Dynamics 365 Finance

All responses (2)

Answers (0)

Sort by

Anton Venter 21,242 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

@SA-15031413-0
As far as I know, there is not out of the box solution for this. Do only want the last change or all changes? Assuming all changes, a simple solution could be to create a custom table and keep the history of the status changes in there. This is with the assumption that you can hook into the update for all or most status changes.
Suggested answer

Aayush Tiwari 443 on at

Like (0)

Report
Copy link

Link copied!

Hello @SA-15031413-0

If you want to keep the change tracking for sales line, you can enable database log for the same table for your selective feilds.
But as the sales line is a transactional data, their are some things that you have to keep in mind as the quantum of data of sales line based on which you have to define database clean up log as well so that the database log doesn't get to big in context of space.

Regards
Aayush Tiwari