Would this type of integration be easier if instead of an excel file it was an XML file? I have not done anything like this before, again its all in the linked thread in my first post, but in essence I need to grab data from an excel file and pre populate fields in GP/Wennsoft with said data...
I feel that this should be possible, but I really don't know where to start. If using VBA is not the preferred method to do this integration is there an easier way maybe?
I have written basic scripts to fill fields with pre poulated text under the condition that the ticket is for a specific...
No but it easily can be relocated to a network share that everyone can access. It is formatted with just a title and then a table containing everything except the inventory info. That is in another table below the first. However it still is set up with the standard Letter column - number rows...
I am uncertain how to accomplish pre populating fields in a service ticket from an external document. The current business process in this place I am interning at seems redundant to me and leaves the possibility for constant typographical errors and such. My full post was originally in VBA for...
The ticket must be created in Great Plains as we are a telecommunications company and when the fields in this program are filled and then processed our customer database/ transaction databases are updated, everything is done through great plains except for that original excel file created in the...
No the original "request for service is done in excel" then from that excel file (printed document) the service department has to sit and recopy all of the information in the accounting program(great plains/Wennsoft). This is the combo that creates the work ticket. The excel file is created in...
It is Microsoft Great Plains (More Specifically it is Wennsoft addon for Microsoft Great Plains, it integrates seamlessly and functions from within Great Plains 2010. Sorry, forgot to mention that.
I do not know if this is possible and any direction/help would be great.
I am doing and internship at a small company and I am trying to find a way to limit typographical errors that seem to be quite common and also reduce redundant data entry. As of now when a sales person lands an account...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.