Error on Invoice Post

Zachary Thigpen
Zachary Thigpen
Fifth Anniversary Name Dropper Facilitator 1
in Blackbaud Financial Edge NXT® APIs
We're working on an integration that includes processing invoices and we're receiving an error when testing the Invoice POST. Any guidance would be much appreciated.

48a9e924afc62dede0f298f1c7daa7fc-huge-bl


Request Body:
{

"vendor_id": 2,

"amount": 29.0100,

"description": "Invoice description",

"invoice_number": "793149-20200819",

"payment_details": {

"remit_to": {

"address_id": 8

},

"payment_method": "Check"

},

"invoice_date": "2020-08-19 00:00:00",

"post_date": "2020-11-04 13:07:12",

"distributions": [

{

"distribution_splits": [

{

"ui_project_id": "1100",

"transaction_code_values": [

{

"name": "Spendable/Non-Spendable",

"value": "Spendable",

"id": 233

}

],

"amount": 29.0100,

"percent": 100,

"account_class": "Unrestricted Net Assets"

}

],

"amount": 29.0100,

"description": "Distribution description",

"account_number": "01-5000-00",

"type_code": "Debit",

"custom_fields": []

},

{

"distribution_splits": [

{

"ui_project_id": "1100",

"transaction_code_values": [

{

"name": "Spendable/Non-Spendable",

"value": "Spendable",

"id": 233

}

],

"amount": 29.0100,

"percent": 100,

"account_class": "Unrestricted Net Assets"

}

],

"amount": 29.0100,

"description": "Distribution description",

"account_number": "01-2000-00",

"type_code": "Credit",

"custom_fields": []

}

]

}

Comments

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


    My name is Eddie Barker and I'm one of the product managers for Financial Edge NXT. I looked at this and then had one of my engineers take a deeper look (because your payload looks right). Since it looks like you're testing this on our sample database, there's another transaction code that is being used in this database. We added that to your payload, and it validates and posts the invoice. Here's the updated payload with the "Grants" section added:


    {
    "vendor_id": 2,
    "amount": 29.0100,
    "description": "Invoice description",
    "invoice_number": "793149-20200819",
    "payment_details": {
    "remit_to": {
    "address_id": 8
    },
    "payment_method": "Check"
    },
    "invoice_date": "2020-08-19 00:00:00",
    "post_date": "2020-11-04 13:07:12",
    "distributions": [
    {
    "distribution_splits": [
    {
    "ui_project_id": "1100",
    "transaction_code_values": [
    {
    "name": "Grants",
    "value": "None"
    },
    {
    "name": "Spendable/Non-Spendable",
    "value": "Spendable",
    "id": 233
    }
    ],
    "amount": 29.0100,
    "percent": 100,
    "account_class": "Unrestricted Net Assets"
    }
    ],
    "amount": 29.0100,
    "description": "Distribution description",
    "account_number": "01-5000-00",
    "type_code": "Debit",
    "custom_fields": []
    },
    {
    "distribution_splits": [
    {
    "ui_project_id": "1100",
    "transaction_code_values": [
    {
    "name": "Grants",
    "value": "None"
    },
    {
    "name": "Spendable/Non-Spendable",
    "value": "Spendable",
    "id": 233
    }
    ],
    "amount": 29.0100,
    "percent": 100,
    "account_class": "Unrestricted Net Assets"
    }
    ],
    "amount": 29.0100,
    "description": "Distribution description",
    "account_number": "01-2000-00",
    "type_code": "Credit",
    "custom_fields": []
    }
    ]
    }
    From the looks of it, it seems like we'll need to address this longer-term in the software, but this should be an easy addition that lets you move forward. In a nutshell, if you have setup your database to use one of the five transaction codes, you should provide for that in your payload.


    If this doesn't work for you, feel free to reply to this post, and we'll go from there, probably outside the Community.


    Thanks!


    Eddie Barker

Categories