Skip to main content
Solved

Bulk change customer profile FOP Point

  • September 28, 2022
  • 8 replies
  • 135 views

Forum|alt.badge.img
  • Freshman II
  • 11 replies

Needing to change all customer profiles FOB point to a certain ID. We were able to change the description but need to change or delete the ID. Any suggestions? Thanks!

 

 

Best answer by yhartman

As an alternative to Import Scenario (which might be easier in this case), you can utilize mass updates on Generic Inquiries.

To do this, go to (in this case) Customer Locations GI (AR3030P1). Edit the GI. Under the Entry Point tab, select "Enable Mass Record Update." A new tab, "Mass Update Fields," will appear. Add "FOB Point" to the list. Now go to your GI, and under Actions, you will find "Update" or "Update All." The nice thing about this method is that you can update filtered data.

Remember the mass update will be available to any user with access to edit the specific form. So you might want to turn off the mass update to avoid user mistakes.

I hope this helps!

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

8 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2209 replies
  • September 28, 2022

Hi @CodyK 

Have you tried an import scenario? Here is one I have created that you could use:

 


PatrickSchlenker90
Jr Varsity II
Forum|alt.badge.img+1

@CodyK, i also suggest to do this with an import scenario. Prepare the data in your excel and update the data wihtin an import...


Forum|alt.badge.img+3
  • Jr Varsity I
  • 62 replies
  • Answer
  • October 3, 2022

As an alternative to Import Scenario (which might be easier in this case), you can utilize mass updates on Generic Inquiries.

To do this, go to (in this case) Customer Locations GI (AR3030P1). Edit the GI. Under the Entry Point tab, select "Enable Mass Record Update." A new tab, "Mass Update Fields," will appear. Add "FOB Point" to the list. Now go to your GI, and under Actions, you will find "Update" or "Update All." The nice thing about this method is that you can update filtered data.

Remember the mass update will be available to any user with access to edit the specific form. So you might want to turn off the mass update to avoid user mistakes.

I hope this helps!


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13
yhartman wrote:

As an alternative to Import Scenario (which might be easier in this case), you can utilize mass updates on Generic Inquiries.

To do this, go to (in this case) Customer Locations GI (AR3030P1). Edit the GI. Under the Entry Point tab, select "Enable Mass Record Update." A new tab, "Mass Update Fields," will appear. Add "FOB Point" to the list. Now go to your GI, and under Actions, you will find "Update" or "Update All." The nice thing about this method is that you can update filtered data.

Remember the mass update will be available to any user with access to edit the specific form. So you might want to turn off the mass update to avoid user mistakes.

I hope this helps!

Please review this article for Mass GI update

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


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13
manikantad18 wrote:
yhartman wrote:

As an alternative to Import Scenario (which might be easier in this case), you can utilize mass updates on Generic Inquiries.

To do this, go to (in this case) Customer Locations GI (AR3030P1). Edit the GI. Under the Entry Point tab, select "Enable Mass Record Update." A new tab, "Mass Update Fields," will appear. Add "FOB Point" to the list. Now go to your GI, and under Actions, you will find "Update" or "Update All." The nice thing about this method is that you can update filtered data.

Remember the mass update will be available to any user with access to edit the specific form. So you might want to turn off the mass update to avoid user mistakes.

I hope this helps!

Please review this article for Mass GI update

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

I verified Mass Update of FOB and did not find that option in the Customer GI,

 

AS @kbeatty21 Mentioned using the below Import scenario to update the customer FOB.

Thanks


Forum|alt.badge.img
  • Author
  • Freshman II
  • 11 replies
  • October 3, 2022
CodyK wrote:

Needing to change all customer profiles FOB point to a certain ID. We were able to change the description but need to change or delete the ID. Any suggestions? Thanks!

 

 

This worked GREAT!! Simple and efficient. Thank you!


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2209 replies
  • October 3, 2022
manikantad18 wrote:
manikantad18 wrote:
yhartman wrote:

As an alternative to Import Scenario (which might be easier in this case), you can utilize mass updates on Generic Inquiries.

To do this, go to (in this case) Customer Locations GI (AR3030P1). Edit the GI. Under the Entry Point tab, select "Enable Mass Record Update." A new tab, "Mass Update Fields," will appear. Add "FOB Point" to the list. Now go to your GI, and under Actions, you will find "Update" or "Update All." The nice thing about this method is that you can update filtered data.

Remember the mass update will be available to any user with access to edit the specific form. So you might want to turn off the mass update to avoid user mistakes.

I hope this helps!

Please review this article for Mass GI update

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

I verified Mass Update of FOB and did not find that option in the Customer GI,

 

AS @kbeatty21 Mentioned using the below Import scenario to update the customer FOB.

Thanks

HI @manikantad18  It was under the Customer locations GI, I was unable to find it at first also. 


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13
kbeatty21 wrote:
manikantad18 wrote:
manikantad18 wrote:
yhartman wrote:

As an alternative to Import Scenario (which might be easier in this case), you can utilize mass updates on Generic Inquiries.

To do this, go to (in this case) Customer Locations GI (AR3030P1). Edit the GI. Under the Entry Point tab, select "Enable Mass Record Update." A new tab, "Mass Update Fields," will appear. Add "FOB Point" to the list. Now go to your GI, and under Actions, you will find "Update" or "Update All." The nice thing about this method is that you can update filtered data.

Remember the mass update will be available to any user with access to edit the specific form. So you might want to turn off the mass update to avoid user mistakes.

I hope this helps!

Please review this article for Mass GI update

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

I verified Mass Update of FOB and did not find that option in the Customer GI,

 

AS @kbeatty21 Mentioned using the below Import scenario to update the customer FOB.

Thanks

HI @manikantad18  It was under the Customer locations GI, I was unable to find it at first also. 

Thank you @kbeatty21 


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