Hi guys!
I need your advice on how I can create a Report to track the outstanding balance of Bills per PO.
I tried to customize the "Purchase Order History" report to include Vendor Prepayments and Bill Payments but there is no way to bring it on the report. I also tried to create the report through "Analytics" but still there is no way to show analysis per PO > Open Bills less (Prepayments + Bill Payments) and subtotals, to show the outstanding balance to be paid.
How would you tackle this? How is possible to get this information through NetSuite?