Hey everyone,
I am following the building Data Views video from Epicor. I am trying to create the Data View getting info from the Vendor Table. However, none of the table columns are being pulled in. Any idea why?
If you change the “Data Table” field to a different table (E.G. VendBank), then switch it back to Vendor, do the columns populate? Did they populate for VendBank?
What happens if you save, close the view, then reopen the view. What if you do it for all of App Studio?
2 Likes
@hmwillett yesterday I tried everything but changing the table to something else. However, when I came in this morning my session on the browser had timed out. I logged back in, deleted the old layer, added a new one and voila. It worked, all the columns came in. No idea why it worked today, it’s identical to yesterdays.
You’re the second person where that was the “fix”. Seems to be the Kinetic version of “Clear your Cache.”
3 Likes
Quick question guys. I understand that I used a Data View to get the vendor table in this case. They used the aftergetbyid event to trigger my event that fills the Data view and holds the info. Then I just made a text box to display the additional information I wanted.
I would like to do this but in Invoice tracker. I would like to display the SO of the line selected on the invoice. What system event could I use to do that (or what would my event target be)?
@hmwillett, So I made my Data View and used OrderHead as my ERP table. I added the row change event like you suggested. I am now working on the Rest-Erp → Rest services where I am trying to use the OrderHed as the service name. However, ERP.BO.OrderHedSVC is not coming up for me. Is this table not an option?
SalesOrderSvc includes all Order-related tables.
@hmwillett I’m having trouble selecting the correct Service Operation to pull in the SO #. Do you know of a guide that describes what these Service OPs do? I’m feeling bad having you walk me though this.
If you do SalesOrderSvc/GetByID and pass the order number, you’ll get all of the relevant order tables for that order number.
I play around with a lot of the BOs in Swagger: https://<YourServer>/<NameOfAppServer>/apps/resthelp/#/home
The BL Tester might be another option to play with.
There are also various Tech Ref guides on EpicWeb, but I don’t recall which one would be useful.
Otherwise, enable Tracing, then replicate some steps in the client and see what Epicor is calling.