I ran an open payables report but the issue is, if we have an invoice that is split between four different school locations, but only paid out of one location, it should only show up on open payables for the NY Location. Currently it shows up on all four location open payables report for the full amount which is incorrect. eg: $100 is split: $25 to NY, $25 to CT, $25 ot NJ and $25 to PA...this invoice is paid out of the NY Bank location. When I run the open payables it should show as $100 open on NY location only. How do I run a report to show the correct amount?