I work with a company who is needing to use Access 2010 to receipt in checks for paid invoices. Our issue came when our auditor found we had duplicate receipt numbers using serial numbered receipt books. Therefore, My boss is wanting a database where "we can use ONE receipt # per check even though they may be paying for more than one invoice at a time". I am wanting to be able to run reports to show which invoice has or has not been paid. Can someone give me an idea on how to build this?
If I am not mistaken I will need separate tables for the following:
*Agencies that we bill (Agency being primary key)
*Receipt table (receipt# being primary key)
What I am not sure on how to build:
*How I can enter multiple invoice numbers that are being paid with ONE check using ONE receipt #)
What completely confuses me:
*Would it be a good idea to have a uniform structure on our invoice numbers? At the current time, we use an alpha numeric invoice number with the numeric changing every month to the month it's being billed for. i.e AAAA-01-14.
*Would it be easier to keep the i.e. AAAA and have a separate field for the month and year being billed, or is that something completely different?