By using this website, you agree to our Terms of Use (click here)
I am working on a GI that I want to mass update the Sales Order Status from open to complete; however, when I create the entry point for the GI the field: Status is not in the Mass Update Fields and Save is not in the Mass Actions. The status on the main Sales Order screen says completed, but the status in the OrderNbr selector says open. How do I fix this with a Mass Update on a GI?
Thanks,
Casey,
I don't think you are going to be able to update the status field via a mass update. You can't affect a change to a field via an import scenario or a mass update action that you couldn't otherwise adjust through the UI.
Within the Sales Order screen, you can't manually change the status field.
Per Help under Form Reference, Completed: Indicates that all related inventory documents required for the order type have been generated and released.
The only way to make a sales order 'Complete' is to ship and invoice all quantities on all lines.
Shawn,
That is what we were thinking, but we wanted to exhaust all of our options first.
Thanks,
The only option I could think of is Customization, you would have to create a new Processing screen allowing to select multiple sales orders and then have that process check all orders being allocated, shipped and invoice prepared automatically allowing the system to change the status from Open to Completed, more like "quick order" function being called in recursive ... such complex process GI's wouldn't be much of help ...
Hi Everyone,
I have a similar issue where I have added a custom field to the mass update fields in my GI, but when I run the update the records are not getting updated. Any ideas as to why this is happening?
Ronita,
We use "Mass Update" on Custom fields nearly every day. We have Project and Sales Order GI's and our Project Managers and Coordinators update 3 or 4 custom fields, as well as "Hold". The custom fields are combo boxes, check boxes, etc.
Hi Kelly,
Thank you for your response. Acumatica literally said "I found a user defined field in the header can not be updated via a GI mass update." I hate it when they're wrong about their own stuff! I am able to add the user defined field in the the Mass Update Field tab in my GI and it shows up in my GI, but when I go to Actions, Update, select my value and click finish, nothing is updated. Any idea whats I'm doing wrong?
RR
Hmmm...I'd have to know a bit more.
- In your GI, on the ENTRY POINT tab, do you have it set "Replace Entry Screen..."? I do not.
- What ScreenID are you updating with the data fields?
I can PM you a screenshot...or if you have GTM or Skype capability...I don't mind showing you how mine is setup.
So you can update the custom field through the screen, but not through the Mass Update feature on the Generic Inquiry? I haven't used Mass Update much myself. Not sure if it works with custom fields.
We had figured out a way to use an import scenario.
Tom- exactly. Casey - good job. I contacted Acumatica and they said Import Scenario was the only way around it.
Ah, so it seems like we're talking about User Defined Fields (Attributes) and not Custom Fields here. Doesn't surprise me that Generic Inquiry Mass Update wouldn't work with User Defined Fields.
I assumed Custom Fields, yes. The GI's I have include Custom Data Fields, as well as a field using CSAnswer data to make the Attribute value visible (for filtering, etc) ...but it does not appear in the Mass Update Fields selection list. I'm too impatient to ask questions, so I jump right to creating a Custom Data field. : ) Just Kidding!! (sorta)
=IIf([CSAnswers.AttributeID] = 'RMA', 'RMA' +[CSAnswers.Value], IIf([CSAnswers.AttributeID]= 'Related Project' , 'Related Project' + [CSAnswers.Value], 'n/a' ))
Online Members
