Question about creating a database that track unpaid bills and...
I have created a database for my venders which contains the following fields:
|Vender Invoice||Discount %||Discount Amount||Subtotal||Grand Total|
Next, I would like to create another database called "Payment" which will contain the following fields:
|Bill Amount||Total Amount|
What should I do so when I run a report I can easily see what bills still remained unpaid, and their balance if I make a partial payments for certain bills? Like QuickBooks; when making payment from QB, after select a payee, it will list the unpaid bills and allow me to enter the amount that I want to pay for each bills.
I am wondering if FMP can do it or similar task? Please help~