I have been racking my brain trying to figure out what tables would be best to query so that I can report on all X, N, and I type items that our organization purchased last year using one of our medical supply accounts. The problem I run into is that if I pull from the POLINE table, I'm not able to see the inventory purchases because our inventory orders all go through a balance sheet account. I can look at REQLINE, but our leadership says that they aren't comfortable using those figures because they may not accurately reflect what was actually paid for the items. I have tried using Crystal Reports to write a query that joins the MMDIST table with the REQLINE table and the POLINE table, but it isn't working no matter how I do my joins (I either end up with hundreds of thousands of duplicate lines, or I only get 120 results for the entire year, which isn't possible). There has to be an easy way to do this that I haven't considered! Any help would be greatly appreciated!