Update Else Create Import Scenario

HI @Denham 

Try changing your Sync Type:

• Full (default): To perform an import of all the data available in the source.
• Incremental - All Records: To perform a partial import, including only the data in each record that has changed in the source.
• Incremental - New Only: To perform a partial import, including only the records that have appeared in the source since the previous import took place.

If the data is imported from a file data source, the Incremental - All Records and Incremental - New Only options provide the same result: If you select either of these options, the system imports the data only if a new version of the source file is provided before the import.

Hi @Denham 

Please review the above suggestions

@kandybeatty49 

Hi Kandy

With the Sync type being changed to Incremental - All Records, will that also import any records that dont exist already? Or will that only update what is being imported that already exists?

Hi @Denham 

It will only update based on the file. If an item is not in the file, it will not touch it. It also will not create new records, it will error if the item is not in the system. 

Also, Acumatica does add the as blank if the item is not in the system and will cause the import to error. 

So if I upload a file with some records that already exist in the sales prices screen, but with updated pricing, and also some sales price records which dont exist in the sales prices screen and then import with incremental-full being the sync type, it will only import the updated records not the ones that are in the file which dont exist in the screen?