Skip to main content
Solved

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

  • December 8, 2020
  • 4 replies
  • 1114 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://www.linkedin.com/in/arline-welty

    4 replies

    Irina
    Community Manager
    Forum|alt.badge.img+8
    • Irina
    • Acumatica Platform Analyst
    • 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:

     

    Best regards, Irina
      arlinewelty93
      Jr Varsity III
      Forum|alt.badge.img
      • arlinewelty93
      • Author
      • Jr Varsity III
      • December 10, 2020

      Understood- thank you Irina.

      https://www.linkedin.com/in/arline-welty
      K
      Semi-Pro II
      Forum|alt.badge.img+1
      • krausef77
      • Semi-Pro II
      • July 30, 2024

      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:

       

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

      R
      Freshman I
      • rgaynor
      • Freshman I
      • August 17, 2026

      Picking up on krausef77's question above - not sure if it's on Acumatica's roadmap, but wanted to share what I found for anyone still hitting this: Attribute values are reachable and writable through the standard Default REST/OData Connected-app API. I tested this directly against a live instance rather than relying on older threads, and confirmed a written Attribute value actually persists - even though mass actions and import scenarios remain the only paths inside the native UI.

       

      I'm building AcuTidy on top of that finding - a bulk-edit tool for Acumatica that lets you mass-update fields, including Attributes, through a grid, backed by that same API, no customization or import scenario setup required. Still pre-launch, but if this gap is blocking you regularly I'd like to hear about your situation, and can add you to the beta list.

      Terms & ConditionsAccessibility statement
      About Acumatica ERP system
      Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
      © 2008 — 2024  Acumatica, Inc. All rights reserved