Hey People!
I'm looking to soon customize our system to handle Event Expenses for non-elevated events. I realize there are many ways to go about it, so before i go down the wrong road, i figured i should poll the community.
In the end, i'm looking for way for users to enter Event specific expenses, as well as generate reports on said expenses. My best guess is to create a custom SSRS screen or 2, passing input to a stored procedure. Considering I'm yet to make a custom screen, i'm not sure what type of bumps i'll run into. My understanding of SSRS is that there is little support for INSERTing data, and it is primarily for reporting, but you can use a SP?
Then, the question becomes Table Setup. Keeping it rather simply, i would guess:
Expense_ID | INV_ID | Expense_Description | Expense_Amount | Expense_Note | Created_by | Create_dt | Updated_dt
Thoughts?
Thanks, and see ya'll in FL on Sunday!James