Failure Creating Invoice due to

Hello,

Our organization is utilizing the Invoice (Create) call to move invoices from a third party application into the Financial Edge NXT environment.

In doing so we have been successful in all invoice and credit types except one. There are cases where a negative line is required to offset the invoice due to deductions or credits noted on the invoice. The way our AP department prefers to handle this is as follows:

Total Amount of Bill: $1,924.00


Debit | Credit
2113.00 | (2113.00)
(189.00) | 189.00

1,924.00 | (1,924.00)

The way we are handling this in our distributions is sending a debit and corresponding credit line as noted in the documentation.

"distributions": [
{
"amount": 2113,
"description": "DESCRIPTION HERE",
"account_number": "EXPENSE ACCOUNT 1 HERE",
"type_code": "Debit",
"distribution_splits": [
{
"transaction_code_values": [],
"amount": 2113,
"percent": 100
}]
},
{
"amount": 2113,
"description": "DESCRIPTION HERE",
"account_number": "ACCOUNTS PAYABLE ACCOUNT HERE",
"type_code": "Credit",
"distribution_splits": [
{
"transaction_code_values": [],
"amount": 2113,
"percent": 100
}]
},
{
"amount": 189,
"description": "DESCRIPTION HERE",
"account_number": "EXEPENSE ACCOUNT 2 HERE",
"type_code": "Credit",
"distribution_splits": [
{
"transaction_code_values": [],
"amount": 189,
"percent": 100
}]
},
{
"amount": 189,
"description": "DESCRIPTION HERE",
"account_number": "ACCOUNTS PAYABLE ACCOUNT HERE",
"type_code": "Debit",
"distribution_splits": [
{
"transaction_code_values": [],
"amount": 189,
"percent": 100
}]

}

]

Based on the above we are sending the expense account line and the corresponding offset line for AP. We are receiving this error when we attempt to send the invoice data as noted above “The total percent distributed must equal 100%”. Looking at the distributions, we should be balanced per the total amount of the bill.

Has anyone run into this or have an idea of what needs to change on our distributions to accomplish the goal of creating invoices with a negative expense account line? They are able to do this manually in Financial Edge but, we have not been able to get the same results via the Create Invoice endpoint.