Import Scenario to mass delete Employee > Delegates?

Yes it did help, thank you! Tip #7 was what I didn’t know and I got this to work in v 21.112 but not v 21.108. 

I have been working with the Import scenario to do a delete of delegates from employees. I receive an error on the first row stating “the system failed to commit the wingman row”

Here is a screenshot of the Scenario.

Any help in fine-tuning would be greatly appreciated.

Hi @KempOdell68 

Tried following on my demo instance and it worked fine. Note the change you need to make on your scenario: 

Hope this helps,

Regards,

Thank you @vkumar  I made that adjustment but I am still receiving the same error.  These are the column headers in my import file. We are running 2021 R1.  Not sure if that makes a difference.

Vendor is the employee number

Vendor Name is the employee name

Delegate is the delegate number

Employee Name is the Delegate name

Hi @KempOdell68 

Please send the xml file of your import scenario to check further.
Regards

Here is the xml

Thanks,

Kemp

Hi @KempOdell68 

Please remove ‘delegate’ text from following column and try again. You can refer to my screenshot which does not have that value. Your scenario does have the text. 

Let me know if it works post change. 

Regards,

Now I get “Field:  Delegate, Value:  123456 , Error:  An attempt was made to add a duplicate entry.”

Hi @KempOdell68 

Check your employee record and Delegate tab data once.

Also, do send me updated scenario. The scenario did work fine on my demo instance without any error.

Regards,

Here is the updated xml.  I looked at the records and see that the delegate exists for the employee.

Thanks,

Kemp

Hi @KempOdell68 

The scenario looks correct. You may send the screenshot of employee profile > delegate tab and the Import by scenario screen to check further. 

Regards,

Here are the screenshots.

Hi @KempOdell68 

I dont see any issue with the scenario or data. Same works on my demo instance. Here is what I suggest.

• create a new scenario with the mapping (final suggested previously) and use the same old db provider
• Try the new scenario ( prepare / import )
• If it still fails, I suggest get help from Support to investigate further. 

What version and build is your instance on?

Regards,

@vkumar I appreciate your help.

I will create a new scenario and see what happens.

This is our Sandbox system on version Acumatica Cloud ERP 2021 R1 Build 21.112.0042

@vkumar 

The new scenario did not work.  I still receive the error “Field:  Delegate, Value:  023005 , Error:  An attempt was made to add a duplicate entry.”