Sage 100

I have a client who is requesting a report of canceled and changed sales orders and master orders. That's all good and fine, but they want to report on is what is changed each month. Line items do not keep track when the date their information was changed, and only the sales order date stamps when it was updated - and that could mean someone just accessing the SO and then selecting Accept without making any changes. I don't have any way of knowing what was changed each month on Orders - I could have an order that has been around for 4 months and last month the order quantity changed or an item was canceled, but a different month some other line items could have changed too. The SO History file won't give me any more information than the original quantity, the original price and the current quantity and current price, plus deleted lines. Anybody done any better tracking that what the stock SO history does?

Anyway to use Knowledgesync's snapshots to do this?

hmmm. not sure but I will look into this. Thanks Mark.

I agree with @MarkChinsky. In Vindyard's training videos is ""Identifying a Change in a Database

I have done this with KS, inserting the changes into a SQL database (Express wlll be fine if they don't have SQL for something else already) and reporting off of that.

Thanks Phil!