I am trying to locate which table the results from Purchase Advisor are housed in, so that I can get at them for a customization. When I look in Field Help, the EpiBinding is “PurchasedBefore” which isn’t helping me. I have included a screenshot below:
When the External checkbox is checked means it is a calculated column. I would have to check, but I’m guessing this column is the same as the PO date on the summary tab?
Is there any way to view the query that drew back the grid results? Is it a query that I can access through a BAQ search? I really want to see what tables are linked to access the data. Thank so much.
There is no way to see the query that returns these results, it is a custom data view created by Epicor in the background. Which column are you wanting to reference in a customization, I can tell you that Order Date is POHeader.OrderDate.
Hi, I actually was able to create what I needed using a BAQ with the vendor, PO and RcvDtl tables. Thank you so much for your guidance;)
1 Like