Hello we have a website that syncs in all sorts of data from Acumatica. We sync in StockItems, SalesOrders, Invoices, etc.
My struggle is that when data is deleted from Acumatica, how can I get those updates so I can delete on my side?
One typical scenario is on Sales Orders. Items are often removed from sales orders. I don’t really have a way to get those updates.
I know I can use push notifications to get these deletes in realtime, but we do more of a night batch process.
Outside of downloading all of our salesorders and doing a comparision of the nightly download and website list...and delete those items that are not in the nightly download. This process is time consuming unfortunatley.
I am hoping to find some sort of query I can call that will give me a list of deleted items, maybe by date?
Does anyhow have an insights on how I could approach this?
Thanks!