Sales Order maintenance

(0) Share

Report

Posted on by Karl Jensen

Does GP have tables that store changes to transactions? Specifically, I am looking for a table that contains an audit trail of changes to Sales Order detail lines. I'd be able to see the line number, the field changed, the previous data, and the new data. I'd settle for something that just says the order changed, even at the header level.

Thanks!

*This post is locked for comments

All responses (2)

Answers (1)

Karl Jensen on at

Like (0)

Report

RE: Sales Order maintenance

Thanks, Mahmoud! That makes sense. I'll check out that route.
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Sales Order maintenance

I have been working previously on a similar project, I got this fulfilled by using the SQL server CDC feature, check the blog post Audit Requirement for Dynamics GP

Your feedback is highly appreciated,