What I need done:
We do debt management and are using sugarcrm.
1. I need the ability to associate to a contact in sugarcrm; multiple creditor/liabilities accounts wich includes the creditor name, account number, balance, and age. (4 fields) I need this data saved in the database.I currently have sugarcrm running. We have created a module that allows us to add creditor/liabilities with the fields; creditor name, account number, balance, and age. We do not know if this is the best way to accomplish our goals, but it is what we are using now.
2. I also need the ability to add all the balances together and display and record the balance in the database. We do not have a field for the balance of all the creditor/liabilities for that contact.
3. I also need to have 2 pages designed and a script written that do some mathematical calculations. The mathematical calculations are the same for both pages. The difference is that I need 1 page to pull the data to be calculated from the creditor/liabilities fields from the database for that specific contact and then display the results and save the results (either in Sugarcrm or a completely seperate database). I currently have an excel spreadsheet that does the calculations I am looking for. I can also have a design of how I want the page to look when its done. its more important that we first get the script to do the calculations working.
4. The 2nd page needs to use data that will be input in fields on that page and then after calculated, be displayed on the page but not saved anywhere.
5. I would like the pages to be graphically appealing and similar to the look and feel of my current sugarcrm design.
Timeframe for delivery:
I need to have this up and running as soon as possible.