To search for all changes to a certain sales order line, use the following sql statement (replacing [Branch ID], [SO #] and [SO Line #] with the actual values):


select * from "record_change_log" where branch_id = '[Branch ID]' and record_type = 'SO' and record_no = [SO #] and description = 'Updated line #[SO Line #]' order by date, time