Dynamics GP RRS feed

  • Question

  • really hoping someone can help me out here. I am working with Microsoft Dynamics Great Plains (GP) web services. Basically we need to directly integrate with GP through our app. I have been doing some digging around in an attempt to map my internal business objects to the dynamics GP business objects for saving. I am having some major confusion on how the webservices work. Go figure, the microsoft documentation is garbage once again and only provides a very very basic overview of the objects with absolutely no examples (or very lackluster examples that lack any depth of explanation). I have gotten the proper permissions setup to execute the following methods:

    • GetGLPostedTransactionByKey
    • GetGLTransactionByKey
    • GetGLTransactionList

    I also have access to the database I need to view the database data. Only problem is this doesnt exactly give me a full view on the mapping from the GLTransaction/GLPostedTransaction objects to my internal objects. So I am targeting some same records by using the DB to find journalIds and dates to enter as criteria. I executed the GetGLTransactionList and was able to see a set of data that I want to test. I also cross referenced the database to identify the records. The biggest problem, however, is that and array of the GLTransactionSummary object is returned and the GLTransactionSummary object is a smaller/lighter/summary version of the entire object. I am trying to map the GLTransaction or GLPostedTransaction object which contain many more fields.

    I setup some tests in my application and based off of some of the summary objects returned by the GetGLTransactionList I took some test data. I grabbed the Key.JournalId and Key.Date properties. Our upload process allows multiple gl transactions to have the same journalId (maybe an issue?). My next step was to attempt to use the GLTransactionKey information to query GP and pull back an object. After setting up 2 methods for GetGLTransactionByKey and GetGLPostedTransactionByKey and using the test key data...both methods return the "Business object not found" exception.

    What am I doing wrong? Could it be because of the way these are being entered? As I said, currently they are being entered where multiple records can have the same journalId. I initially thought this to be an issue because the GLPostedTransaction and GLTransaction objects are not an array, collection, list, or enumerable. Past that I have no idea where these could be hiding or how to access them. I could really use any help at all.

    Thursday, March 6, 2014 7:08 PM

All replies

  • Tom, This is a CRM forum. For help from GP experts pls post it @ http://community.dynamics.com/gp/f/32.aspx

    If my response helps you in finding your answer then please click 'Mark as Answer' and 'Vote as Helpful'

    • Proposed as answer by Mamatha Swamy Thursday, March 6, 2014 7:59 PM
    Thursday, March 6, 2014 7:59 PM
  • Thank you
    Thursday, March 6, 2014 8:27 PM