Import scenario to skip existing customer record while doing insert operation

  • 12 January 2022
  • 3 replies

I want to import the unique customer records using import scenario.

I  want to skip the existing records & insert only non existing records.

The record skip logic should be execute on “CustomerID”.


Best answer by mikeschmitt81 12 January 2022, 16:01

View original

3 replies

Userlevel 7
Badge +11

@sysuser113  By default Acumatica, will look into the Keys (In this case it is Customer ID), if this value already existed in the system, process run and update the record if not exist Customer record will be created in the system. 

@Naveen B  Thanks for the reply.

Yes, Acumatica check the Key and if the record exist then it updates the record.

I don’t want to update the record instead of update it should skip the record.

@sysuser113  Review the Incremental sync type option - in the help text 



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 — 2020  Acumatica, Inc. All rights reserved