When trying to create the BAQ I get the below error. I am trying to give the sales dept more info so they can adjust the sell price based on what it will cost us to make.
Severity: Exception, Table: PriceLstParts, Field: , RowID: 6beb42d6-a02a-4907-ae92-1fe5aee956fd, Text: Update not allowed.
Query returned 1 row(s).
Can you post your BAQ?
PriceList_Parts_Update.baq (36.4 KB)
Cal you should what it shows in your query phrase? I this a new UBAQ? or one that was upgraded?
This one is a bit harder to debug since you have custom fields on the PriceLstParts table. The error though Field: Looks to be blank.
That is fine can you create one to PriceLstParts and update the comments field or the base unit price?
Where you able to create an updatable BAQ on PriceLstParts lets say changing the base price.
Can anyone help me out with this. I have had a ticket with Epicor since late March with no luck.
Sorry I looked above and saw what i asked.
We don’t use that feature and I am getting create not allowed.
Did you run trace when doing it manually? Is the Erp.PriceLstParts.UpdateExt being called?
My edited my UBAQ to only the comment field and the basePrice and it still does not work. I have been able to get it to work once but with a long delay or even having to kill Epicor and come back in and it is updated. But if I try again it does not work.
Bill Tunis
Senior Systems Administrator
SUN Automation Group
Phone: 410-472-2900 x159 Mobile: 443-421-9639
12201 Long Green Pike, Glen Arm, MD 21057
Email: Bill.Tunis@SunAutomation.com
Are you able to do this in the client?
What do you mean by client? If you mean using the client vs web we only use the local client
Bill Tunis
Senior Systems Administrator
SUN Automation Group
Phone: 410-472-2900 x159 Mobile: 443-421-9639
12201 Long Green Pike, Glen Arm, MD 21057
Email: Bill.Tunis@SunAutomation.com
How is this done in local client?
Not sure what you are asking. I run the UBAQ at this point once I get it to work I will make a dashboard that my end users can use.
Bill Tunis
Senior Systems Administrator
SUN Automation Group
Phone: 410-472-2900 x159 Mobile: 443-421-9639
12201 Long Green Pike, Glen Arm, MD 21057
Email: Bill.Tunis@SunAutomation.com
There isn’t a lot of information to go on other than the uBAQ, which isn’t working, so we need to tackle the project from a different angle to understand how to proceed.
Maybe walking through how the process is done today so that we can identify a path to success. How do users do this today?
I am creating a new process for the purchasing dept. to input the cost of a part in the pricelstparts table so the sales dept. can set the sell price. So the 1st step was to create a field which I done. Then do a UBAQ which I am trying to do but with no luck. I have changed the UBAQ to the default comments field but still no luck.
PS I have since been able to get it to work but it takes hours for it to update just one field that I changed. I believe it is some bad logic in Epicor that it is running against the whole data results not just the updated field. Will test this by setting BAQ to just one part when ever it gets done updating a field.
I would like to know if you would have the same results if you created a UBAQ for pricelstParts and tried to update a comment.
Bill Tunis
Senior Systems Administrator
SUN Automation Group
Phone: 410-472-2900 x159 Mobile: 443-421-9639
12201 Long Green Pike, Glen Arm, MD 21057
Email: Bill.Tunis@SunAutomation.com
I am unable to get the ubaq to work. I am getting an error cannot create new record. Sorry.
I have found that Epicor does update more than it should on UBAQ at times. The grid of data that you are trying to update. Is it only one record? or everything? You may want to make sure the grid you are updating is as small of a data set as possible. We have also moved to custom BPM on uBAQs because of this, as our data sets were larger and couldn’t be reduced.
another word of caution. if you have multiple people using the uBAQ at the same time, whomever saves last wins. We had folks overwrite other folks work, we had to implement a pre processing BPM to check the sysrevid of the records before things were saved. If something was changed in the database since the time of the data pull, users were not allowed to save.
When you get there I can share some of that, though that is posted on this site somewhere as well.
I have filtered the UBAQ to 1 part and it still takes 1hr and 45 minutes before it releases and the change made.
Bill Tunis
Senior Systems Administrator
SUN Automation Group
Phone: 410-472-2900 x159 Mobile: 443-421-9639
12201 Long Green Pike, Glen Arm, MD 21057
Email: Bill.Tunis@SunAutomation.com