Acumatica ERP is adaptable and effective solution that keeps on improving by adding new features. Here we are going see one of the features of Acumatica which helps in updating records more efficiently and saves time as well. As working with the Acumatica ERP, we are mostly familiar with the generic inquiries. Using generic inquiries, we can access data in Acumatica and all those data is available for Acumatica reporting, dashboards, Export Scenarios, etc.
There are always situations where a user must update the details of multiple records with same set of values. Navigating to each record and updating it individually is not an ideal way and its time consuming. Alternatively, a user will either use the standard import functionality or create a custom import that can run from external sources. Acumatica provides a MASS UPDATE option within generic inquiries.
In this blog, we will discuss about the about Mass update feature considering the Generic Inquiry screen of Customers (AR3030PL).
Suppose an organization is no longer maintaining the multiple currencies and only uses “USD”. Here, we need to change all the customers to use “USD” as Currency ID where Mass Update is the best solution in such cases. Also, some of the customers need to be made inactive.
Navigate to the Generic Inquiry screen of customers, expand Customization, and click on “Edit Generic Inquiry”.
The Generic Inquiry screen will be opened with “AR-Customers” as auto-selected.
Go to “Entry Point” tab and select “Enable Mass Record Update” checkbox. This will make the new “Mass Update Fields” tab available.
Go to ‘Mass Update Fields’ tab, add the available fields from the list for which update is required and Save the Generic Inquiry.
Reload the Customer Generic Inquiry screen (AR3030PL).
After refreshing, you will see new Action buttons added as ‘Update’ (updates selected records only) and ‘Update All’ (updates all records).
Update All: Update Currency of all the customers to USD
Click on Update All, select the fields that needs to be updated and choose/enter the values as per the options available for the selected field control (Selector, Drop-down, Checkbox, …).
On click of Finish button, processing starts for update operation. Once completed, user can see the records with updated Currency ID ‘USD’ for all customers.
Update: Update the customers to set it as Inactive
Click on Update, select the fields that needs to be updated and choose/enter the values as per the options available for the selected field control (Selector, Drop-down, Checkbox, …)
On click of Finish button, processing starts for update operation. Once completed, updated records are listed on the screen with Customer Status as Inactive.
So, Generic Inquiry’s Mass Update feature makes it very simple to modify the data for multiple records with multiple fields. Depending on the field type, the available control for data selection ensures that one can use the system data which in-turn reduces the possibilities of errors.
Since, the update operation runs based on the standard Acumatica business logic, the data is modified only if it passes standard validations and throws error if the selected field is allowed for update.
About Us
Greytrix – a globally recognized and one of the oldest Sage Development Partner and a Salesforce Product development partner offers a wide variety of integration products and services to the end users as well as to the Partners and Sage PSG across the globe. We offer Consultation, Configuration, Training and support services in out-of-the-box functionality as well as customizations to incorporate custom business rules and functionalities that require apex code incorporation into the Salesforce platform.
Greytrix has some unique solutions for Cloud CRM such as Salesforce Sage integration for Sage X3, Sage 100 and Sage 300 (Sage Accpac). We also offer best-in-class Cloud CRM Salesforce customization and development services along with services such as Salesforce Data Migration, Integrated App development, Custom App development and Technical Support to business partners and end users.
Salesforce Cloud CRM integration offered by Greytrix works with Lightning web components and supports standard opportunity workflow. Greytrix GUMU™ integration for Sage ERP – Salesforce is a 5-star rated app listed on Salesforce AppExchange.
The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.
For more information on our Salesforce products and services, contact us at salesforce@greytrix.com. We will be glad to assist you.