We import a spreadsheet in a database and we need to make sure the data is correct.
1. We need to check if the product exists in our tbl_invoiceIt.xlx. If it does not we either need to flag/update our listing or correct it (the most common)
2. We need to check if a purchase order and/or work order have been received in JCA_received. If not, we need to flag it so that we can’t import it
3. We need to match the purchase order and the work order. Sometimes the logistic company sends us older purchase order or work order. If a PO exist in DB, then it could have already been assigned to another job. But sometimes the PO is for multiple jobs and it needs to allow import after checking
4. We also need to check if the work order is for one or more jobs. [login to view URL] list the quantity
More details in the zip file
57 фрилансеров(-а) в среднем готовы выполнить эту работу за $20/час
Dear, I need to have a short discussion about the requirements. Specially for how you want to "flag" records. Also some explanation about the logic. Best regards, Issam
Dear Client, I would like to discuss with you about the project. I have good knowledge in excel and I can definitely help you in this project. So please contact me. Roy
I am a professional Excel expert holding years of experience in utilizing advance level tools and functions of Excel to prepare highly dynamic and automated excel based dashboards and templates.
I am a statistical analyst, with strong background of Pure Statistics including a strong grip on statistical software including SPSS, Excel, Minitab, STATA, SAS, Mathematica, Statistica and Eviews.