You need to sign in to do that
Don't have an account?
Database Development
Hi,
As part of exploring the salesforce.com and its powerful services, i have tried to develop an app.
The App that striked me was, Expense Managment( where Bills and Payments are shared among college friends, roommates).
In this process, i have developed custom objects(not many though) and custom fields.I need some help in designing the database and then going ahead with further additions to the model.
Now, what i am trying to achieve is:
1) Develop an app that would help manage expenses.
Example: Assume there are 4 people as part of a group and want ot manage their expenses on a monthly basis.People would then add their bills/reciepts as per their spending.
Now, it has to do a Math calculation and show who owes how much to who.
As part of this i have created 2 custom objects called "Expenses" and "Receipts". They have a master-detail relationship between them.Expenses is Master object and Receipts is a detail object.
To now show the split up calculation, i am using Visualforce.I want to create it as a PDF with a Button click.
Now on Expenses Object i have a Button called " Split & Calculate", when clicked should then perform the math and display who owes how much to who.
I am not quite sure how to do that, but just have a vision that it can be done this way. Can any one help me with any ideas or any other way we could achieve this altogther.
Also, any other ideas to this are always welcome!
There aren't any business rules, process or procedures to be followed.
Thanks ,
Sales4ce
Have you considered that one receipt actually may be related to multiple expenses? For example, a hotel bill will have to be accounted for food, lodging, taxes. I would think that the relationship is mxn.
It is not clear from the description how the groups and users come into the calculation. Could you elaborate on the design more?
Hi,
Thanks for your reply!
I guess, we could categorize the receipts and have sub categories. The sub categories would be a dependent picklist on Categories.
for ex:
Category:
Rent
Grocery
Insurance
Bills
Entertainment
Travel
Food
Sub-Category:, for Bills
Utility Bill,
Internet Bill
Telephone Bill.
To be more precise on Design,assume a use case:
we have 4 people sharing a room and expenses:
User1-Tom, User2-Chris,User3-Pat,User4-Sam.
Now, assume that we have a custom field of Type PickList(Multi-select) named "Applies To". This would have that group of users.
There is a reciept which is applied only to two users, chris and Sam.Assuming that chris and sam share a restaurant bill for dinner. Their bill was worth $50 and Chris has paid the bill. It has to be shared between Chris and Sam only.
Chris would then select that it would apply to Sam(from Applies To field). I hope i did not confuse and you are able to understand what i am looking for.
So final ouput would be this way:
User Owe
Tom $0
Chris $0
Pat $0
Sam $25 to Chris.
I hope i could describe my problem and design clearly.
Thanks,
Sales4ce