Results 1 to 2 of 2

Thread: Pastel Partner SDK Integration Issue - Software Development

  1. #1
    New Member
    Join Date
    May 2017
    Location
    South Africa
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastel Partner SDK Integration Issue - Software Development

    Hi All,

    I am unsure if this is the right place for these types of questions, or even the correct forum to be using for this. (If not, could someone possibly point me to the right place?)

    Right now, our company is Developing a System for a Client, which has a requirement for a Console Application to be developed (It could in theory be any Desktop used application, but we went with a Console Application), which is used to Integrate and Pull Data from their Pastel Databases by use of the Partner SDK.

    Now, while the majority of these requirements are done and have been achieved, I am having an issue with Pulling Data from 1 table.
    Currently we pull from 3 Different Tables, namely the:
    • [ACCHISTH] - Account History Header
    • [ACCHISTL] - Account History Lines
    • And [ACCJCODE] - Cost Codes


    The way we Pull Data from these tables are all using the same Calls to the SDK, such as Below:

    The initial call to the Table
    Code:
    var returnCode = SDK.GetNearest(document, 1, "0"); //"document" is representative of the above mentioned Tables Codes
    The above generally Pulled the table we need, where thereafter (for each record) we use the following:

    The call for the next Record within the Table
    Code:
    returnCode = SDK.GetNext(document, 1); //"document" is representative of the above mentioned Tables Codes
    And the data Retrieved from this is stored within our Systems Database, for use in it's internal functions.
    Now all of this works fine, with no issues, we get our Data, convert it and store it. However, we are in the need for Accessing one last table, which is where it just fails.

    We need to Pull Information from one last table, called:
    [ACCCCTRN] - Cost Code Transactions

    Now the problem is, even though we use the exact same process as the previous tables, we get errors when using it for this one.

    The Following (Exactly the same as earlier)
    Code:
    var returnCode = SDK.GetNearest(document, 1, "0"); //"document" is representative of the above mentioned Tables Codes
    returnCode = SDK.GetNext(document, 1); //"document" is representative of the above mentioned Tables Codes
    Throws us with this error:
    {"Object required"}
    Data: {System.Collections.ListDictionaryInternal}
    ErrorCode: -2146827864
    HResult: -2146827864
    HelpLink: null
    InnerException: null
    Message: "Object required"
    Source: "SDKPasV14"
    StackTrace: " at PasSDK.PastelPartnerSDKClass.GetNearest(String& FileName, Int16& KeyNumber, String& KeyValue)\r\n at ReadFromPastel.Program.QuoteHeaderExport(String document, String license, String authcode) in C:\\Source VSO\\LicenceServer\\GMC Project Management Web App\\Source\\ReadFromPastel\\Program.cs:line 175\r\n at ReadFromPastel.Program.DocumentExport(String license, String authcode, Int16 docType) in C:\\Source VSO\\LicenceServer\\GMC Project Management Web App\\Source\\ReadFromPastel\\Program.cs:line 129"
    TargetSite: {System.String GetNearest(System.String ByRef, Int16 ByRef, System.String ByRef)}
    Now one thing I do notice in there, is the "Source" is indicating "SDKPasV14". This I find odd, since we are using V17 pastel and the updated SDK with it.
    So I tried rebuilding the tables, in hopes it may have been a version issue (Even though the SDK is backwards compatable) This did not work. Neither did removing our Reference to the SDK V17 reference, and re-adding it.

    I just have no idea how to resolve this issue. The tables are there, all other tables tested are accessible, but not this one.
    If anyone could provide some assistance or Guidance in the direction that would lead to this being resolved, it would be greatly appreciated.

    If needed, we are developing using Pastel Partner V17 for Pastel Partner V17. (Along with its relevant version SDK) Code language being C#.

    Thanks in advance!

  2. #2
    New Member
    Join Date
    May 2017
    Location
    SA
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hey Evendyce,

    1. File Names
    I don't see [ACCCCTRN] but I do see [ACCTRN] in the SDK Help File.

    2. SDK Version
    The Pastel Partner Version is not directly related to the SDK Version.
    SDK Version 14 is the correct one to use with Pastel Partner 17.


    Hope this helps!

Similar Threads

  1. Pastel Partner V12 - Locate server/Open company issue
    By DSKotze in forum Accounting Forum
    Replies: 12
    Last Post: 23-Jun-17, 09:16 AM
  2. PASTEL PARTNER ISSUE
    By Coolblue in forum Accounting Forum
    Replies: 2
    Last Post: 17-Sep-15, 08:54 AM
  3. Software development process
    By Genevie Vince in forum Technology Forum
    Replies: 19
    Last Post: 21-Aug-09, 12:17 PM
  4. the issue of having a business partner
    By raven147 in forum General Business Forum
    Replies: 8
    Last Post: 23-Apr-09, 03:43 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •