Open Search - EP_PO_PURCHASE_ORDERS - Purchase Order
Financials/SCM 9.20.46.000 Tools 8.60.08 Open Search (not Elastic Search)
I have two questions related to the data that I am seeing in the delivered Purchase Order (EP_PO_PURCHASE_ORDERS) Search Definition/Search Category that I am hoping can be answered.
Question 1 - I have noticed that if I go directly into the Advanced Search with no criteria that it states that I have 221,969 results. However, if I added up the individual facet amounts for the PO Date Facet it totals 221,920 the difference equals to 49 POs. I have run the query behind this and I am finding it seems to be missing 49 1995 Purchase Orders. This does not make sense why the data is not displaying.