PartPlant Updatable Dashboard Site Selection

Kinetic ERP
,
1

I’m a novice to updatable queries and updatable dashboards. I have created an updatable baq and deployed that in a dashboard. The intended use of the dashboard is to allow me to update min max safety stock levels quickly for partplant records.

Everything works fine so long as I am trying to make updates to the first site ever created in Epicor. However if I want to update the partplant record in another site, when I go to save the record it changes the site back to the first site and pulls the data related to that record and never makes any changes to the table.

I have even tried going the route of using the uptake from excel function and the dashboard exhibits the same behavior. Im not getting any errors (red fields) it just changes the displayed values back to the first site if Im trying to update records in another site.

Any ideas on how to resolve this?

Below is the current setup for the BAQ and the Dashboard

image
image1132×443 18.9 KB

image
image
image902×866 43.3 KB

image
image

2

This doesn’t specifically answer your question, but have you looked at the Min Max Safety Mass Update form? From here you can see the parts and the min max values and update them right in the form. you can also use the tools to apply a mass update to all parts based on the proposed min/max values. I think you need your MRP settings to have the automatic min max values calculate properly.