Error on Invoice Post

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