I am trying to create an updatable BAQ that would allow a user to update the XRelQty field in the POrel table. In the ‘Analyze’ tab of the BAQ designer module, when I click on Get List I can update the required field. When I click on Update, I get a message telling me the field was updated without error but when I go in my PO the quantity does not updated. What Am I doing wrong ?
Here are the update settings that I used:
Could be several things.
It appears you have several PODetail and PORel tables in the query. That could be causing some confusion in the update even if you are only using 3 and 6 in the update.
POs that are approved need to be unapproved and then reapproved for an update to happen. You could unapprove a PO and try the update to see if this is the fix.
Hi Greg,
your help is much appreciated as usual.
The query is pretty complex and has 7 subquerries. I am not sure if I can simplify it. What can be done to mitigate this ? The mapping was done automatically by the software. I tried to manually modify it but I get error messages every time I do and Epicor always revert back to this mapping.
The PO I am trying to update is already unapproved.
I would look at a trace or a PORel quantity change. Sometimes you have to update a couple of fields or only the Doc ones do the update the others are copied.
I simplified my query to only have one PORel and one PODetail table in it. Now when I try to update the field, I get the following error which is very odd as this field is not selected as an updatable field.
Uncheck the allow new.
1 Like
Got the UBAQ to function properly after simplifying my query. Thank you for your help Greg.
2 Likes