Hi, I'm still learning access and I'm having some trouble with a database I am trying to make. Below is a photo of the relationships I generated for the proposed invoicing system called Direct Pay Voucher ("DPV"). Here is the set up:
Does the relationship report below match what I explained above.i am having issues with how to find the current balance of each account. Also how would I show the balance of accounts who don't have a DPV attached to it as of yet??? [Approved Budget]-[Amount]-[Encumbrance]=Balance but what if amount and encumbrance aren't avaiable for the account. How to I design that query???
Thank you for any help you can give me!!
- Many employees can generate a DPV (we want to track who made the DPV). Therefore one employee can make many DPV's.
- A vendor can be attached to multiple DPV's
- A DPV can be paid for from multiple accounts
- A DPV can be paid through a Purchase Order
- A Purchase Order is connected to an Account (Encumbrance)
- An Account has an approved budget based off the fiscal year (although some accounts carry on beyond one fiscal year, if this is an issue i can solve it by manually transfering the funds by to different fiscal year. Example: 100k left in fy 2018 so make account with same number fy 2019 and enter 100k instead of original budget of account)
Does the relationship report below match what I explained above.i am having issues with how to find the current balance of each account. Also how would I show the balance of accounts who don't have a DPV attached to it as of yet??? [Approved Budget]-[Amount]-[Encumbrance]=Balance but what if amount and encumbrance aren't avaiable for the account. How to I design that query???
Thank you for any help you can give me!!
Last edited by a moderator: