Skip to main content
Solved

Change Activation status on import scenario

  • Dec 22, 2023 1:23 AM UTC
  • 3 replies
  • 201 views
  • Translate All

dpruckus
Freshman I
Forum|alt.badge.img

Is it possible to have a flag in the import file, to change the Activation status on file import? Lets say I have a master spreadsheet of Employees (or users) and everytime before importing it I would select which ones are Active and which ones are not. In this case I wont need to manipulate the data on the Import scenario screen. Thanks.

 

 

Best answer by Robert Sternberg

This is possible and is something I do quite often, the implementation does not quite align with your question however I believe it will accomplish your goal. 

STEP 1

Add a new column to your excel file “Active”

Values are 1 or 0 (0 for exclude)

 

STEP 2

Create an import scenario with SOURCE RESTRICTIONS of Active = 1

All rows with Active = 0 will be excluded from your import as requested. 

 

View original

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Dec 22, 2023 3:29 PM UTC

@dpruckus  I don’t think that is possible. We need to choose/select the records in the Import Scenarios screen to be processed.

Translate

Ed Goodman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Employee
  • Dec 26, 2023 8:16 PM UTC

@dpruckus 

Functionality to change the activation status on the import does not exist at this time.  You will need to look into customization in order to accommodate this.  As a workaround, if you are only wanting to update information for active employees, I would suggest setting up a target restriction in the import scenario for active employees.

 

Translate

Robert Sternberg
Captain II
Forum|alt.badge.img+7

This is possible and is something I do quite often, the implementation does not quite align with your question however I believe it will accomplish your goal. 

STEP 1

Add a new column to your excel file “Active”

Values are 1 or 0 (0 for exclude)

 

STEP 2

Create an import scenario with SOURCE RESTRICTIONS of Active = 1

All rows with Active = 0 will be excluded from your import as requested. 

 

Translate