Đang Thực Hiện

153770 Invoice Generator in Excel

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

Kỹ năng: Bất kì công việc gì, Thiết lập Bản thảo

Xem thêm: invoice generator, program algorithms, product list excel template, looking duplicate data excel, list accounting programs, information accounting, create algorithms, algorithms work, excel 16, dollar days, customer data excel template, company invoice template excel, balance accounting, anything dollar, algorithms programs, less excel, excel less, terms used accounting, invoice generator excel, excel invoice template , customer data excel, invoice, generator, excel service, excel formulas

Về Bên Thuê:
( 9 nhận xét )

Mã Dự Án: #1899953