hi all,
I have developed a timesheet in Infopath i would like to use to populate time tickets in GP. My thought is that i collect timesheets from the field, run a custom VS2010 workflow on the infopath form to extract the info and load it into GP. Currently, my payroll guy hand-types all the paper timesheets into the system, which takes about a day and half. I would like all our project managers to enter these tickets in one place, and have it load up in GP automatically. My thought is that if i load up the timesheets in the system, then GP can do all the work of posting to projects and the GL....i just want to eliminate payroll from hand-entering all these timesheets.
I know there is this functionality in the SharePoint Business Portal for GP, but we decided to let me just write the whole thing. As of now, i have the workflows done for approval, and set permissions on the library, but the one MAIN workflow still has a major peice missing: connecting to GP to load up timesheet batches.
I have never used eConnect or the web services, so i was wondering if someone could point me to a document showing how to connect to GP and load records. I could probably do this by simply doing inserts in the timesheet tables, but i would like to follow the best practices and do it through the GP web services or eConnect.
So what would be the best way to do this and where do I start?
thanks in advance!
george