Skip to main content
Solved

How to change SO line SalespersonID via import scenario


Forum|alt.badge.img+1

I need to change the SO line SalespersonID on multiple sales orders via import scenario. However, I’m not sure where to affect that field in the import scenario under “Line Details” as I would expect.

I have a list of order numbers and their order types along with the new salesperson ID. Any thoughts on how to set this up via import scenario?

Best answer by mikeho

Finally got it to work! For future reference in case anyone else needs this information, it looks like the correct field to reference is Owner -> Contact:

 

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

RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

@mikeho - I am assuming you want to update the Salesperson ID on the Sales Order Line Level.

 

Please try this import scenario.

 

I hope this helps. Thanks!


Forum|alt.badge.img+1
  • Semi-Pro II
  • September 21, 2022

Hi @RohitBhandurge,

Thank you for the help! Is there a way to do this without having to list the Inventory ID for each line? Meaning just update the Salesperson ID on every single line?


RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

@mikeho - How many lines do your list of Sales Orders  have on an average? 


Forum|alt.badge.img+1
  • Semi-Pro II
  • September 21, 2022

@RohitBhandurge - it can vary wildly, but I’d say on average between 3-5 lines. 


RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

@mikeho - Alright. You should be able to use the “Line Nbr.” as a reference in the Import Scenario if you don’t want to use Inventory ID as a reference.

 


Naveen Boga
Captain II
Forum|alt.badge.img+19

@mikeho  Do you want to update the same Sales Person ID for all the lines with out having a reference InventoryID and Line Nbr ?


Forum|alt.badge.img+1
  • Semi-Pro II
  • September 21, 2022

@Naveen Boga - yes, same Salesperson ID for all of the lines of the orders.


Naveen Boga
Captain II
Forum|alt.badge.img+19

@mikeho  There is a simple way to do this by using the Mass Update with Generic Inquiry feature.

Please find the link below. 

  1. Create a Generic Inquiry
  2. Enable the Mass Update feature
  3. Provide Sales Person ID to update

https://www.greytrix.com/blogs/acumatica/2022/08/02/acumatica-mass-update-with-generic-inquiry/

 

Since you wanted to update with the same Sales Person ID, another way is to work with the database script and but this is a bit risky. Before running this script must check with a technical person. I will not recommend this unless you are very clear with the update but this is another option.

 


Forum|alt.badge.img+1
  • Semi-Pro II
  • September 21, 2022

Thank you, @Naveen Boga! I totally didn’t think about going that route.

I’ve created the Generic Inquiry however the whole Operations with Records section containing the “Enable Mass Record Update” box is greyed out. Any idea why that might be and how I might make it accessible?

 


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+12
mikeho wrote:

Thank you, @Naveen Boga! I totally didn’t think about going that route.

I’ve created the Generic Inquiry however the whole Operations with Records section containing the “Enable Mass Record Update” box is greyed out. Any idea why that might be and how I might make it accessible?

 

Hi @mikeho  Select the entity screen which you need to update the data.

Thanks


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+12
manikantad18 wrote:
mikeho wrote:

Thank you, @Naveen Boga! I totally didn’t think about going that route.

I’ve created the Generic Inquiry however the whole Operations with Records section containing the “Enable Mass Record Update” box is greyed out. Any idea why that might be and how I might make it accessible?

 

Hi @mikeho  Select the entity screen which you need to update the data.

Thanks

 


Forum|alt.badge.img+1
  • Semi-Pro II
  • September 21, 2022

Thank you, @manikantad18!  Is it possible to update both the line item Salesperson ID and the Owner under the Financial tab of the sales order? I don’t see a way to do this with your GI.

 


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+12
mikeho wrote:

Thank you, @manikantad18!  Is it possible to update both the line item Salesperson ID and the Owner under the Financial tab of the sales order? I don’t see a way to do this with your GI.

 

Added the generic inquiry with Mass update enable for owner ID 


Forum|alt.badge.img+1
  • Semi-Pro II
  • September 21, 2022

@manikantad18 - Am I correct in understanding that we can either do mass updates on the Owner or the SO line Salesperson ID, but not both in the same GI? (I’m assuming because these come from 2 different tables.)


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+12
mikeho wrote:

@manikantad18 - Am I correct in understanding that we can either do mass updates on the Owner or the SO line Salesperson ID, but not both in the same GI? (I’m assuming because these come from 2 different tables.)

Yes these can be handled in two separate GI

thanks


Forum|alt.badge.img+1
  • Semi-Pro II
  • September 21, 2022

Thank you, @manikantad18. However I’m trying to simplify this for users so it sounds like the import scenario may be the best route because they’ll be able to do it all in a single import.

 

@RohitBhandurge - I tried your import scenario, however it added a line to the sales order instead of updating the current line. Is there something different that needs to be done on the import scenario? I also tried adding the Owner but it didn’t seem to work. Here’s what I currently have:

 

 


RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

@mikeho - Can you try by unchecking the highlighted below?

 


Forum|alt.badge.img+1
  • Semi-Pro II
  • September 21, 2022

@RohitBhandurge 

I tried it and a new line was still added to the sales order instead of updating the current line.


RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

@mikeho - You can run the script that @Naveen Boga mentioned above while I test this more.


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+12
RohitBhandurge wrote:

@mikeho - Can you try by unchecking the highlighted below?

 

@mikeho 

 

Check the suggestion in the above article and let me know if it works for you.

Thanks


Forum|alt.badge.img+1
  • Semi-Pro II
  • September 22, 2022

@manikantad18 

I’ve tried emulating the suggestion in the article you shared; here’s what I have:

 

But I’m getting the following error message now:

 


Forum|alt.badge.img+1
  • Semi-Pro II
  • September 23, 2022

I figured out what was wrong with my import scenario and was able to get the SO line Salesperson ID to update, so thank you for the help there. However, I’m still having trouble getting the Financial > Owner field to update.

@manikantad18 - do you or anyone else have any suggestions for how to update this field? When viewing the field in the sales order under the Financial tab it displays the owner’s full name so that’s what I’m trying to change, but maybe that’s not actually the data I need to import?


Forum|alt.badge.img+1
  • Semi-Pro II
  • September 23, 2022

Finally got it to work! For future reference in case anyone else needs this information, it looks like the correct field to reference is Owner -> Contact:

 


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