Hi
I have downloaded and started using the time and billing template.
I have two issues that i do not know how to address.
1. Because i have some projects that run through more than one month but at the same time i need to raise and invoice for each one of these projects at the end of each month, i need to modify the database so that i can issue an invoice depending on the month i need the invoice for.
for example: i have a project running from September 2021....i will have to issue an invoice on September 30, October 31st, November 30th and so on....And each invoice should contain only the manhours and fees spend on this particular month, i.e. the October 31st invoice should contain only the manhours for October. But should also show any outstanding amounts from the previous month(s).
2. there is now way (or at least i cannot find how to do it), to have a unique number allocated (and subsequently stored in the database) and printed on each invoice i issue. Then, when at a later time i need to reissue this invoice, the database should somehow return the same invoice with the same number.
Any help is really appreciated and welcome. i am not really experienced with programming but i do understand some basic and intermediate Access concepts.
I am using the template as it was and i have made no changes to the structure.
Thank you very much in advance for your time to look into this post and your help if you can help
SK