You need to know how much cash you need to pay all vendors who billed you 30 or more days ago.
SELECT SUM(Invoice) FROM AcctsRec WHERE (CURRENT_DATE - InvDate) >= 30;
You need to know how much cash you need to pay all vendors who billed you 30 or more days ago.
SELECT SUM(Invoice) FROM AcctsRec WHERE (CURRENT_DATE - InvDate) >= 30;