Duplicate logic only checks first 15 characters for API Post calls

Bob Devine
Bob Devine
Fifth Anniversary Kudos 1 Participant Facilitator 1
in Blackbaud Financial Edge NXT® APIs
At the very least we have identified Post <Vendor> in Accounts Payable and Post <Project> that appear to have this characteristic. Are there any others users have found?

if the first 15 characters are the same but 16th is different it still throws a duplicate error for Vendor and Project posts. Any known fix/work-arounds?

Comments

  • Eddie Barker
    Eddie Barker
    Tenth Anniversary Kudos 2 Name Dropper Participant
    Hi Bob,

    What's your duplicate checking criteria set to on these records? If you go to database view, then Accounts Payable>Configuration>Business Rules>Vendors, what's your duplicate vendor criteria set to, and what's the "Automatically check for duplicate vendors" set to (checked/unchecked, and then "warn" or "do not allow").


    The same thing for projects, except under General Ledger>Configuration>Business Rules>Projects.


    These should be respected when you're creating/running POST requests on these records. The one wrinkle that I will mention in regards to creating these through an endpoint rather than in an interactive UX is that we assume "warn" means "don't create" since we don't have a way to interact for a decision.


    Does this help? Thanks!
  • Bob Devine
    Bob Devine
    Fifth Anniversary Kudos 1 Participant Facilitator 1
    Does anyone know if a change to the checkbox <check for duplicates> would cause api/NXT calls to fail with <Object reference not set to an instance of an object> upon a Vendor Create call?


     
  • Bob Devine
    Bob Devine
    Fifth Anniversary Kudos 1 Participant Facilitator 1
    Pragma: no-cache Cache-Control: no-cache Date: Mon, 27 Jul 2020 08:45:54 GMT Content-Length: 118 Content-Type: application/json Expires: -1 { "<span>Error</span>": <span><span style="color:rgb(196,26,22);">"Failed to save vendor"</span></span>, "<span>Details</span>": <span>[<span style="color:rgb(196,26,22);">"Object reference not set to an instance of an object."</span>]</span>, "<span>ErrorPath</span>": <span><span style="color:rgb(170,13,145);">null</span> </span>}<br /><br /><br /><br/>Linked to BB support case:
    Case number


    017912830

     


Categories