The description of the project is a synopsis of the total project. More details will be given to the qualified bidder.
Please post details of how you can assist in completing project. Do Not post general company information as I am looking for specific information on how you or your company will accomplish fulfilling the requirements of this project. I am looking for a fast turnaround and someone experienced in creating accounting programs & scripts as well as someone skilled in formulas and algorithms and using those formulas in scripts to create the desired result for the customer. Successful completion of this project will result in another project immediately following completion and more work down the road.
Must be available via instant messenger and available for me to call by phone for clarification
INVOICE AUTO GENERATOR IN EXCEL
a. Randomly select a customer from a list
b. Auto generate 2 invoices per customer by randomly selecting products or service items from a list and arrange the data in a pre-designed excel template (All invoice fields must be populated)
c. Auto generate 2 payments per invoice in an separate pre-designed excel template each invoice being paid within a specific range of days as to satisfy invoice amount & invoice balance percentages (program must have an imput area for specifying % of Invoice amount to invoice balance(ie. 10% will have an invoice amount from 20,000 -25,000 and a balance owed less than 5% of that amount - and the script will randomly choose the amounts and the customers to apply this too, but it will fall within those ranges), % of product and service categories
d. Ability to select certain companies for manual data manipulation
e. Program will randomly select data but must allow program to specify % of Invoice amount to invoice balance, % of product and service categories
f. Create additional payment terms in customer categories: Anticipate, Discount, Discount- Prompt, Prompt, Prompt-Slow, etc.
g. %'s of Termed customers: Anticipate, Discount, Prompt, Slow etc
h. Benfords law used to prevent duplicate data from being used
i. Rule to disallow any whole dollar amounts
j. Only actual credit limits can possess whole dollar amounts