Solved

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

  • 8 December 2020
  • 2 replies
  • 813 views

Userlevel 2
Badge

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

icon

Best answer by Irina 8 December 2020, 18:13

View original

2 replies

Userlevel 2
Badge

Understood- thank you Irina.

Userlevel 7
Badge +8

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:

 

Reply


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