 |
Excel /electronic invoice and work flow project
| Status: |
Closed
(Project expired)
|
| Budget: |
€250-750 |
| Project Creator: |
markmorahan
View PM Post PM
Buyer Rating: (No Feedback Yet)
|
| Created: |
06/27/2009 at 16:10 BST |
| Bidding Ends: |
07/02/2009 at 16:10 BST
|
| Description: |
The project is to build an invoice process form for approval purposes.
Function One:
The template receives a flat file feed of data which populates the invoice fields. The requirement is to put a template in place which automatically downloads the data from flat file files arriving by email.
The next function is to put in place a simple work flow process.
Function Two:
There is a field for the 'approver'. If this has a name installed, then the invoice should be routed to that person.
If it is blank it will go to the accounts department for this field to be filled in by a drop down box.
The invoice then goes to the approver where they can:
a) Change the nominal codes,
b) Change the cost centre
c) select tick boxes to approve or reject
d) Buttons which have three options: 1) Approve and send to Accounts Department, 2) Approve and release to the accounts package, 3) Reject, which returns the invoice to the vendor. There needs to be a text box created, adjacent to each line item, which allows the reason for the rejection to be stated.
Audit trail showing who took which action and date/time
e) A text box for the vendors messages
f) A text box for the users comments
g) A look up feature for a purchase order. This looks up the PO number field in the invoice and search a list of PO's and brings up the matching PO.
h) an automated PO lookup feature (each line item will have a PO number) which compares the line items/totals against the PO and changes the colour of the invoice field if they do not match.
Function Three:
The file is released into the accounts /ERP package. This will require an automated upload process.
Administrators Module:
Additional Fields: allow the administrator to add additional fields
Add users: import a list of employees, security/approvals levels and email addresses.
Security levels:
Users will have different levels e.g. approve invoices up to a certain figure, when they go over that figure they can approve but this will need further approval.
Some users will be able to release data directly to the accounts package others will not.
Access to management information
Other Lists: A module for importing the following
Nominal Codes
Cost Centres
Product Codes
user defined lists
Look up features:
example:
a) Product. The invoice arrives with a product name. If there is is no product number/ nominal code or cost centre, a lookup takes place to put the data in that field. If there is no match, the field changes colour.
b) default cost centre. The user needs to be able to set defaults for relationships between products/services/people for cost centres
We need to provide a simple way of customising the application so that organisations can add own logo. Ideally this will not have the 'look and feel' of excel but more of a stand alone application.
Interface to set up the receiving of data from the email.
Interface to set up the release of data to the accounts/ERP package
Management Screen: This allows users to view lists of invoices and set up reports. A number of standard reports will need top be built. e.g. number of invoices by data, vendor and cost centre. Rejected invoices.
Automated tracking and reminder process, which if an invoice has not been approved, sends a reminder email.
|
| Project-related Files: |
|
| Job Type: |
|
| Database: |
(None)
|
| Operating system: |
(None)
|
| Bid count: |
15 |
| Average bid: |
€435 |
|
 |
 |
Service buyers, who haven't posted any projects, are allowed to post a free trial project once.
It's completely free to post a Trial project. Learn more. |
|
View Project Clarification Board Post Message on Project Clarification Board
Messages Posted:
0
If you are the project creator or one of the bidders Login for more options
|
|
Project Bids |
|
|
Bid on This Project
| please see PM..... |
| Hi, I have made a lot of forms and software mechanisms as Yours. I can help You and provide solution in good price. Best regards. |
| I'm ready to start this jobs right now. |
| Hi..I am Priyanka Mukherjee...I want to do your work..pls dont hopeless.... |
| Data Processing
Are you searching professional data processing service provider with manpower? Want to get accurate solutions for all your data processing requirements? If you are looking for data processing service with high quality at affordable rates then your search ends here.
Outsource Data Processing is a giant data processing company in Maharashtra Pune provide data processing services at lowest possible rates.
Whatever data processing requirements you have, you will get ideal solutions by our experts. We are best in the industry with 99.98% accuracy, strong quality in work. We ensure you will get excellent output of your projects before closing date.
Our data processing services include:
• Forms processing
• Word processing
• Image processing
• Survey processing
• Insurance Claim.
Data Entry
Data Entry Services means processing of data or text documents into programs with job specific instructions. The objective of companies offering these services is to have all data entry instructions standardized across the various text processing jobs so that retraining of operations will not be necessary for any new text processing jobs.
Our Services are Data entry Services, Data Conversion Services, Imaging Services, Data Processing Services, Catalog Conversion Services.
Webvishcom Data System provides whole range of data entry services including.
Data Cleansing, Data Mining, Directory Services, Data Capture, OCR, Conversion, Document Digitizing, Image Enhancement, Photo Enhancement, Data Processing, Forms Processing, Litigation Services, Catalog...
If you have any questions, please contact us as per mention below are details.
Head of the Department
Mr.: Vishal G Bobade.
Contact us: - +919271225961
|
| The work seems to be interesting to me. But You have not mentioned about volume of work. Please mention me the number of entry I have to make. Considering the number of entry I can assure you the days to complete the job. Without knowing the volume of work it is really useless to mention days to finish the work. Please communicate with me to discuss the above issue.
Sharif |
| Dear sir, we have a team of 15 member and working since last 10 yr, on data processing,data entry, data converting at nominate rate, if you are interested plz reply us at dashrath.shekhawat at gmail dot com we will finish your work as per your desire, thanks
|
| I know how to do this...i only work with excel, and VB macros... |
| hello sir/madam, i have big team and totally saported in 24x7. and i have good speed internet connection and 24 hw ups and genset. so pls give me details i am ready to start ur work.
pls ad me on yahoo msnger. infotech_san[at]yahoo.com and gtalk santosh150187[at]gmail.com
thanks san infotech. |
| Dear Sir,
I am interested in this project. Please see PMB.
Kind regards! |
| Sir, I am good at excel, you can trust me for your project. Regards. |
| Hi,
I am interested to do this job work
|
| Please, check your PM box. |
| i m intrested in this project and im excellent at excel.waiting for respornce. |
| NEW FOR WORK BUT KNOWS HOW TO WORK ACCURATE ON TIME
RENESH JAIN - INDIA - AGRA
|
Bid on This Project
|
|
|
Provider Rating
