Skip to main content
Question

How to handle deletes in Acumatica

  • June 4, 2026
  • 1 reply
  • 43 views
P
Freshman I

For building an ETL pipeline to warehouse Acumatica data, are there any approaches to detect deleted records besides the traditional primary key comparison method?

    1 reply

    S
    Jr Varsity III
    Forum|alt.badge.img+2

    Hi ​@PradheepPrabhakaran 

     

    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

      Terms & ConditionsAccessibility statement
      About Acumatica ERP system
      Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
      © 2008 — 2024  Acumatica, Inc. All rights reserved