Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Flynno

    Fill fields in GP/Wennsoft service with external data VBA?

    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...
  2. Flynno

    Integrate external data into Great Plains fields

    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...
  3. Flynno

    Integrate external data into Great Plains fields

    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...
  4. Flynno

    Fill fields in GP/Wennsoft service with external data VBA?

    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...
  5. Flynno

    Integrate external data into Great Plains fields

    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...
  6. Flynno

    Integrate external data into Great Plains fields

    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...
  7. Flynno

    Integrate external data into Great Plains fields

    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.
  8. Flynno

    Integrate external data into Great Plains fields

    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...

Part and Inventory Search

Back
Top