Import Scenario - Update deductions to inactivate and set ending date

  • 28 March 2023
  • 2 replies

We can successfully import the updated health insurance rates using an import scenario; however, we have to manually set the previous deduction to inactivate it / set the ending date before importing or the import fails.   We tried to create a separate import scenario to update existing deductions, but I am not seeing how to differentiate between creating a new deduction vs updating the existing.   

SQL is so straight forward in comparison.   Update …   will update the record.   Insert will create a new record.  Not seeing comparable in the import scenario. 

Any suggestions?  



2 replies

Update:  Changing the default employer / employee rates for the deduction codes changes the rates for the individual employees payroll deductions.    We have other insurance where there is not standardized pricing and the prices change per year.  We would like to be able to  import the updated pricing.  How would we do this?   

Userlevel 7

Hi @jkeller21 were you able to find a solution? Thank you!


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