Add a new grid panel to existing form

Hi All!

Hoping for a little help here. I’ve added a new panel grid to the Reminder letter Details for the invoice.

Created a new data view with the relationship for InvcReminder and InvcDtl Table with parent child relationship using the invoiceNum. .

added it as an epibinding feels like everywhere and then removed it everywhere during troubleshooting.

Why isn’t it returning any rows?

What am I missing? Do I need to create an event?

There needs to be an event to populate the data in your data view.
When you created the data view, did you have it automatically generate the event that fills it in? You’ll have to call that event at some point - maybe after your panel grid is created? or probably best to see what events already fire when the detail page is loaded, and choose one of them to fire your data fill event after.

1 Like

I didn’t add an event.
I guess this is where I’m lost.
I tried to follow this training, but I’m not using a BAQ. I just need to access the InvcDtl Table.

There isn’t any reference when creating this dasbboard to create an event.

Go to the left toolbar and select the Data Views (second to last) button.
The three data views you created in the Application Wizard display on the panel.
2. Select the SalesOrders data view.
The SalesOrders data view details now appear.
3. Go to the Parent Data View drop-down and select Customer.
4. Press New.
5. Go to the Parent Column drop-down and select Customer_CustNum.
6. Go to the Child Column drop-down and select OrderHed_CustNum.
7. Press Save.
8. Now link the DetailLines data view to the SalesOrders data view. Go to the left toolbar and select the
Data Views (second to last) button.
9. Select the Detail Lines data view.
10. Go to the Parent Data View drop-down and select SalesOrders.
11. Press New.
12. Go to the Parent Column drop-down and select OrderHed_OrderNum.
13. Go to the Child Column drop-down and select OrderDtl_OrderNum.
14. Press Save.

You should be able to create a new event as @jwphillips mentioned.

Give the event a decent name (so you can find it later).

Set the trigger to maybe:
Type: DataView
Hook: Row Changed
Target: InvcReminder

(that way the rest call will fire every time you change rows in the InvcReminder grid)

Then… add a rest-erp widget to make your rest call.

Properties > Rest Advanced > Rest Services

Service Name: Erp.BO.ARInvoiceSvc (my best guess)
Service Operation: GetByID

Method Parameters:
Field Name: invoiceNum
Data Type: (should be an integer, I think)
Field Value: {InvcReminder.InvoiceNum}

This event should then make the rest call, any time you change rows in the Invoice Reminder grid (trigger) and pass the corresponding InvcReminder.InvoiceNum value into the call and “Get” the corresponding AR Invoices.

… hopefully.

1 Like

This is important… events can bite us when we don’t take into account the way the screen is supposed to function

If you have any troubles, we’re here to help!

You guys are awesome!

I’m not sure that this is going to work here. :frowning: This isn’t a BO.

image

Did you try the above event set up?

You’re not trying to use the ReminderLetterSvc… the above should be using the ARInvoiceSvc… you’re just passing the VALUE of InvcReminder.InvoiceNum.

Everything runs through BOs (as far as I’m aware)

The function that David suggested should get you the data you need

1 Like

Yes, I guess I must have something else set up incorrectly :slightly_frowning_face: My guess is an epi binding.
I’m confused to what I’m supposed to put in there and which ones need to be filled in.
Would the technical reference guide help me?

Are you getting errors? or just no returned data (empty grid)?

Are you familiar with debugging in the browser? Can you see if your event and rest call are firing and if anything is being returned?

1 Like

I’m familiar with the debugger. It doesn’t look to me like the event is triggering.

This is what I’m seeing.

Network
image

Errors and warnings
image

There isn’t an error just nothing being returned

Thank you for your support!

Hit Ctrl+Alt+8 in Kinetic to enable console debugging to see the events firing in the Console.
The Network tab is useful to see what REST methods are getting called - it looks like CustomerReminderSearch and GenerateReminderLetters are called to populate the other grids. You can click on them to get some more information (how the method was called, what the response looks like, etc.)

Thanks!
This is the error I get from the console
image

But I get the exact same error on the form without the customization.

So I’m not sure. I’ve created a case with EpicCare. I hope that they support.

That’s so frustrating!
There are definitely times where nothing “normal” seems to work…
It might still be good to know where in the sequence of Events this error is happening

It really is! :frowning: