uBAQ error - Access Denied. Cannot Modify memo table

Epicor ERP 10
1

Hi all, I’ve inherited a uBAQ that has an upper grid for Invoice info, and a lower grid for adding/updating Memo descriptions and Text. I need to be able to add a new row to the lower grid to add new record to the Ice.Memo table. I’m able to successfully modify existing fields and update with no errors. The problem is after adding a new row and then changing the required fields then click Update, I get the error “Access Denied - Cannot modify memo table”. I’m making sure to fill in all required fields. I’ve looked on the forum, googled it and found nothing. Hopefully someone has seen this before and can help me out. Thanks!

3

Make sure you have to enter correctly two fields

image

4

How are you adding a record? If you are using the BPM that the uBAQ generates, please issue a trouble ticket so it can get resolved. This means the UpdateExt has a bug.
That being said, you may need to use the BO widgets to mimic a user’s steps.

5

Jason, I’m using the native functionality of the uBAQ and deployed dashboard. I haven’t created any BPMs or customizations for this. When I looked at the #Base# AddNew ExecuteCode widget, it only had one statement that updated an initial value for Company. Nothing else. I’m still pretty new to Epicor, but I thought it would have had more code to add the rest of the fields from the dashboard grid. The person who created the dashboard is getting the same error as well.

6

The Add New function just defaults values for you. The work is being done in the Update function. It sounds like there is a bug that should be reported. There is likely still a way to accomplish this through BPM widgets in the uBAQ.

7

Thanks for your help! I’ll submit a case in the morning, and also trace the process from addnew to update and see what I can do with BPMs.

8

Me thinks you probably dont need to be overwriting the base functionality on New. From the sounds of it, you probably dont need code at all. Typically, you would never overwrite base functionality unless you were in an “advanced update” situation, this is where you would write all of your own code.

9

We had same issue earlier while adding Memo using UBaq, end up with as i mention above to set two fields correctly

  1. RelatedToSchemaName = “Erp”
  2. RelatedToFile = “LinkedTable your case InvoiceHead or InvoiceDetail”
2 Likes