Skip to main content
Solved

Update of customer salesperson by state or zip range?


Forum|alt.badge.img+1

Is there a way to update the salesperson assigned to a group of customers in bulk based on state and/or zip code? We pay commissions based on the salesperson assigned to a customer account and need to change a group of accounts to a new salesperson.

I set up a generic inquiry based on AR.CustSalesPeople pulling in the needed data from the location, customer and address tables. The inquiry returns the expected data and can be filtered for the needed records, however I’m not able to setup the “Enable Mass Record Update” operation successfully.

What “Entry Screen” should I be using or does this need to be done using an import scenario? (I tried AR.20.50.00, AR.20.50.PL and  AR.30.30.00.)

Any suggestions or guidance would be appreciated. Thanks!

Best answer by alicezyks51

I tried adding =True in the mapping and got the same result, so I sent this off to our VAR for assistance. The updated Import Scenario they created is below. The targets in the mapping changed from Salesperson Info / Customers to Customer Summary / Salespersons. (Note: The “IGSC” refers to our commissions customization and would not be part of the key fields names in other instances.) The import now works as expected.

Thanks for the suggestions which pointed me in the right direction.

View original
Did this topic help you find an answer to your question?

7 replies

DavidEichner
Captain II
Forum|alt.badge.img+13
alicezyks51 wrote:

Is there a way to update the salesperson assigned to a group of customers in bulk based on state and/or zip code? We pay commissions based on the salesperson assigned to a customer account and need to change a group of accounts to a new salesperson.

I set up a generic inquiry based on AR.CustSalesPeople pulling in the needed data from the location, customer and address tables. The inquiry returns the expected data and can be filtered for the needed records, however I’m not able to setup the “Enable Mass Record Update” operation successfully.

What “Entry Screen” should I be using or does this need to be done using an import scenario? (I tried AR.20.50.00, AR.20.50.PL and  AR.30.30.00.)

Any suggestions or guidance would be appreciated. Thanks!

 

You can setup a data provider that uses that Generic Inquiry as the source.  Once you do that, configure an import scenario to do the update.


Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • 43 replies
  • June 20, 2022

I setup the data provider and the import scenario, but am running into an issue getting the new salesperson set as the default. The customers currently have a salesperson (our inside sales 037) with a zero commission percent as the default. The import scenario adds the new rep (221) with the correct commission percent but ignores the setting of default = TRUE. Here’s snips of the excel file and the salesperson tab in the customer.

Any suggestions on how to fix this? Thanks!


DavidEichner
Captain II
Forum|alt.badge.img+13

Can you send an image of the import scenario profile line where you set the field = True?


Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • 43 replies
  • June 21, 2022

Below is my import scenario based on the attached spreadsheet.

The default of True is in the spreadsheet. Please let me know if it needs to be set in the import scenario. Thanks!


DavidEichner
Captain II
Forum|alt.badge.img+13

I would try adding it directly in the row of the mapping

 

=True


Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • 43 replies
  • Answer
  • June 22, 2022

I tried adding =True in the mapping and got the same result, so I sent this off to our VAR for assistance. The updated Import Scenario they created is below. The targets in the mapping changed from Salesperson Info / Customers to Customer Summary / Salespersons. (Note: The “IGSC” refers to our commissions customization and would not be part of the key fields names in other instances.) The import now works as expected.

Thanks for the suggestions which pointed me in the right direction.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2657 replies
  • June 23, 2022

Thank you for sharing your solution @alicezyks51 !


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings