I am running 10.1.500.8 and I created a BAQ that shows the history of orders for a customer.
I would like to add a sheet to the Order Entry form that I can use to display the output of the BAQ I created (based on the custnum of the sales order entered).
I have seen this done from one of my customers - so I know it can be done. However, I was hoping someone here could coach me on how to do a simple example.
I am not a C# programmer - so please excuse my newbie questions.
Yes, we did this at a previous employer. Create the dashboard and then in
customization mode add the sheet to the tab layer you want. I would look at
the ice manual or is it user experience guide for the details. We set the
new sheet to require a retrieve button so the order screen doesn’t bog down
every time you change to a different order/customer.
I would recommend what Brad said… Create your BAQ… Create a Dashboard probably Updatable and then inside your Customization under Tabs you can Add Dashboard… Then you can continue to Customize it on your UI layer… Let Epicor handle building the Grid, BAQ etc… if possible… you dont need the extra 500 lines of code that come with building your own Grid.
Create a tab and add it to the Sales Order Entry Screen. Then create a
dashboard for your BAQ. Then Add the dashboard to the new tab you created
through the screen below
From that I was able to distill the bare code down to:
private void epiButtonC1_Click(object sender, System.EventArgs args)
{
// ** Place Event Handling Code Here **
DynamicQueryAdapter dqa = new DynamicQueryAdapter(oTrans);
dqa.BOConnect();
dqa.ExecuteByID(“02-DeleteMe2”);
epiUltraGridC1.DataSource = dqa.QueryResults.Tables[“Results”];