Posted: 2013-04-05 12:03 |
1) Please can you tell me how I tally a payment that we have received to an invoice that we have produced on workbooks and sent to a customer. 2) How can I see what invoices are outststanding at any one time? i.e have not yet been paid. 3) How do we show that we have paid a supplier invoice/order in workbooks for items we have ordered from our supplier. Many Thanks Paul |
Posted: Mon, 08.04.2013 - 13:48 |
Hi Paul The easiest way to do all of the above would be to create a custom field (or fields) on your records. You could simply create a checkbox on an Invoice record and one on a Supplier Order record which you can tick when you've been paid/made payment respectively. This would allow you to create a filter to show any invoices that haven't been paid. If you need more data, you can take things further by creating a couple of custom fields: one to show the amount paid and the other to show the date. This would enable you to build a report showing how much was outstanding (by creating a formula that takes the amount paid from the total amount due) as well as being able to calculate things like how long on average a particular customer takes to pay. |