Hi All,
Lets assume that you have multiple records where you need to mass execute some action or update multiple fields to the new value.
From the I100 Acumatica Integration Services Training course you may know that you can do it with Export or Import scenarios. Integration Scenarios are some sort of the small program inside your ERP where you can update multiple fields, calculate depended values, execute actions and so on.
But what if you want to have more control on records need to be updated. Some sort of semi-manual mass updating tool? In this case Generic Inquiry Mass Update feature can be more interesting and useful.
Lets try to use it.
I will share with you example based on Non-Stock Inventory items and we will click Update Cost button for multiple records.
To use GI Mass Actions you need to complete following steps:
- Create a generic inquiry for the required entity
- Add new inquiry to the sitemap
- Select needed tables – In my case it is Inventory Item
- Define filters – In my case I filter non-stock items with standard cost valuation method
- Add field to result grid.
- On the Entry Point tab
- We need to select Data Entry page – exactly this page will handle all actions and business logic. In my case it is Non-Stock Items
- We need to activate “Mass Records Update” and “Mass Actions on Records” – this will show you 2 new tabs on GI designer screen
- On the Mass Update Fields select fields that you want to maintain. In my case it is Pending Cost and Pending Cost Date
- On the Mass Actions select all actions you want to use. In my case it is just Update Cost. Please not that all actions will have 2 buttons – Action and Action All – to handle one an all records.
Actually now you can use it:
You also can apply all required filters, conditions and other iterations on GI, so your mass processing will be as much interactive as it possible.
Have a nice configuration!
Nector,
There is some rules how new fields appears on "Update Fields" tab. For example field should be visible in UI and be enabled and be not read-only. You also cannot add fields from DACs other than primary.
Hope it helps.
How can we add fields on mass update fields?
I am trying to add FOB Point on Vendor GI and I cannot find the FOB point field in Mass Update Fields tab.
Thank you!
Hi Jvanh,
I see what are you trying to do, but personally haven't tried it. Could you please create a case for that with acumatica?
How would one go about calling the UpdateAll method from the contract api? I have implemented the following but receive a null reference exception
try
{
BatchUpdate updateBatch = new BatchUpdate { BranchID = new IntSearch { Value = branchID }, Start = new IntSearch { Value = start }, End = new IntSearch { Value = end } };
updateBatch = client.Put(updateBatch) as BatchUpdate;
UpdateAll action = new UpdateAll()
{
FieldName = new StringValue { Value = "IVBatchNbr" },
Name = new StringValue { Value = "Batch Nbr" },
Selected = new BooleanValue { Value = true },
Value = new StringValue { Value = batchNbr }
};
InvokeResult invokeResult = client.Invoke(updateBatch, action);
ProcessResult result = LongRunProcessor.GetProcessResult(client, invokeResult);
}
catch (Exception e)
{
}