Skip to main content
Solved

Mass Update from Generic Inquiry : Why are my availalble fields so limited?

  • December 8, 2020
  • 3 replies
  • 950 views

arlinewelty93
Jr Varsity III
Forum|alt.badge.img

Greetings all,

I’m trying to mass update the value of a Business Account attribute, ideally through a Generic Inquiry. I’ve got the inquiry written, and it joins multiple tables including Contact (the ‘parent’ table) and Business Account. (I want to update the Business Account attribute values based on values at the Contact level.)

But when I search the ‘Mas Update’ field list, I’m only seeing fields from the Contact table.

Must I write a new inquiry with Business Account as the ‘parent’ table in order to see Business Account attribute fields show up in the ‘mass update’ area?

I’m confused, because since my Inquiry returns Business Account attributes I assumed I’d be able to update them.

Props to Sergey Marenich for writing this article https://asiablog.acumatica.com/2016/09/mass-processing-using-gi.html

Best answer by Irina

Hello Arline,

Unfortunately, updating attributes is impossible through mass actions.

You may utilize the import scenario for this purpose. An example of such a scenario can be found here:

https://community.acumatica.com/maintenance-and-troubleshooting-15/how-to-import-records-with-required-attributes-validation-on-import-scenario-301

 

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

3 replies

Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Support Analyst
  • 524 replies
  • Answer
  • December 8, 2020

Hello Arline,

Unfortunately, updating attributes is impossible through mass actions.

You may utilize the import scenario for this purpose. An example of such a scenario can be found here:

https://community.acumatica.com/maintenance-and-troubleshooting-15/how-to-import-records-with-required-attributes-validation-on-import-scenario-301

 


arlinewelty93
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 19 replies
  • December 10, 2020

Understood- thank you Irina.


Forum|alt.badge.img+1
  • Semi-Pro I
  • 184 replies
  • July 30, 2024
Irina wrote:

Hello Arline,

Unfortunately, updating attributes is impossible through mass actions.

You may utilize the import scenario for this purpose. An example of such a scenario can be found here:

https://community.acumatica.com/maintenance-and-troubleshooting-15/how-to-import-records-with-required-attributes-validation-on-import-scenario-301

 

Is this on the Agenda to be added at some point?


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