Specifications for Tracking & Calculating Annual Software Maintenance
Our company is a Software Distributor for a principle in the US.
We have resellers that we sell through as well as direct customers.
Maintenance is always calculated for the end customer, the reseller gets a percentage of the maintenance depending on there status.
I require a system that can allow me to input the following:
1. Initial maintenance amount to the customer and customer details.
2. Automatically allocate a margin assigned to the reseller if applicable.
3. Maintenance cost from supplier based in US$.
4. The system must be able to cater for at least 5 other currencies on the customer (output side).
Note that most customers purchase several times in a year and in different months in that year. The system should calculate and prorate the number of month to the anniversary date. The system must be able to true up to a specific date which is selected to meet the customers requirements.
This date can also change and the system should then recalculate the maintenance to the new anniversary date.
Customer side documents required.
Generate a renewal notice 2 months & 1 month prior to the renewal date.
Generate a final notice on the renewal date.
Generate a pro-forma invoice.
Templates provided.
Supplier side documents required.
Generate a P.O to the Supplier
Template provided.
Reports required
Total Maintenance
Maintenance by customer
Maintenance by reseller
Maintenance by month
The system must link with a Microsoft Windows calendar.
Hi,
Would you want this program to run at your as well as customer's end (as the client side currency is mentioned so i guess it would be required to run at client's end as well). We have worked in the past on a similar project for a reprographics company (Xerox) to calculate commission and maintenance data. If interested, please reply back.
Thanks.
I am an experienced senior MIS executive working for large Automobile company of India. I do freelance programming in my spare time.
My expertise includes, Visual Basic, Visual FoxPro, and Visual C++
our software house "Spectrum Soft" located in Rawalpindi, Pakistan has lot of databases projects and most of them are in vb6.0 and i will provide you component base solution if and only if u ask for it
Regards
syed muhammad jawad