Hello I'm looking to build a sharepoint site for my department. My department handles report requests from our internal cusotmers. A person sends me an email with the following:
Request Date: 9/3/09
Job number: YEARidJOB# (id will be used when creating my billing reports)(id tells me what division ordered the report for billing reasons)
UNDERLINE ONE: Lender / Other Client Type
PAYMENT STATUS: Not Paid
Report location on server: J:\report\path
Report Type: Final
Delivery date to client: 9/3/09
Asset name & location: name of Asset, City, State.
Number of copies: 2
Number of CDs: 1
Include Invoice: Yes
Name, physical address, and phone number for recipient:
city, State and Zip
Electronic Transmission: Yes
Delivery e-mail if required:
Additional instructions: None
This system works fine, but is far from being automated. Every quarter I have to go through these emails and determine billing. I would like our internal clients to go to a sharepoint site and enter all the data above and then hit submit. After submitting I still receive an email with the above info, but now it's in a database so that I can create billing reports at the end of the quarter or year. We use Feex for shipping so I'm curious if there is a way to automate the printing of labels based on the data entered. One snag is that we bill based on page count so I will need to be able to manually go into the database once the clients report is created and enter the page count. The Job Number is key here becuase it tells me which division requested this report. We can use this number to build my billing report. I'm not sure if this is feasable, but I would love to be able to use the adderss information entered in the form to create FedEx shipping labels. If this is possible, I will need to be able to choose different fedex account numbers. I would like to use the Number of Copies section and the Number of CDs section to automate the billing. For example, let's say the ask for 2 copies and 1 CD. Let's say each copy is 100 pages and I charge $5 for a CD and $.01 per page. The billing would automatically calculate to be $7. I would need to be able to manually enter what i charge per CD and per page. Please let me know if there are any questions I can answer.
10 freelanceria on tarjonnut keskimäärin 779 $ tähän työhön
Hello, I have extensive experience with SharePoint and Database creation. I chose the low bid because I am immediately interested in getting exposure on this web site. Please consider me. Thank you!