For building an ETL pipeline to warehouse Acumatica data, are there any approaches to detect deleted records besides the traditional primary key comparison method?
Question
How to handle deletes in Acumatica
Hi
If you are using Acumatica 2025 R1 or later, you could try the following (see the section on ‘Tracking Removed Records for Synchronization’):
https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=27f3a57a-0def-48ad-ba80-3ab664a98fde
This will only return the NoteID field for each deleted record though.
If you need something more real-time rather than on demand, you could also try Push Notifications:
https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=d8d2835f-5450-4b83-852e-dbadd76a5af8
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.