List items present in table (Fin & Ops) - Check if record in entity A exists in entity B
I have two List items present in table actions to get data from two entities.
What is the best method to build a list of Items with Sales price i.e. check if Item number from Items entity exists in Sales price entity? I tried researching best methods but did not find the most suitable one for the 'list items' action as above.
Would also need the reverse approach e.g. Item doesn't have Sales price/doesn't exist in Sales price entity. I guess this should be straight forward once above example is working.