With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
We are using Vtiger as our CRM and as our invoicing tool.
Every month we have a custom php program that generates the Sales Orders for our customers with some recurring invoiced items. We also have separate excel files with other products to be invoiced. So our office manager has to manually encode all entries in the existing sales orders in the Vtiger CRM system.
This is source of error and is time-consuming.
What we need is the following:
- a php application that allows the upload of excel (CSV) files;
- the files will be composed of identical lines. Every line will detail one invoice item.
- the program will check for every line in the file if the mentionned customer does exist, if the mentionned product does exist and if one and only one open Sales Order does exist for this customer in the Vtiger System.
- the page displayed after the pre-upload of the file will display all erroneous entries (wrong customer or product, missing quantities or price, no or many Open Sale Order(s) ...
Sign in or Register to see more