Skip to main content
Question

The system failed to commit the Adjustments row.

  • March 1, 2021
  • 3 replies
  • 949 views

 I am trying to create a payment and apply it to a select Invoice. When I attempt it, I get the error message “The system failed to commit the Adjustments row.” Would love it if someone could help point out what I’m missing here. Below is a slightly edited version of the JSON request body...

{
"ApplicationDate": {
"value": "2021-01-16T00:00:00.000+05:00"
},
"ApplicationHistory": [],
"AppliedToDocuments": {
"value": "73.07"
},
"CardAccountNbr": {
"value": "8888"
},
"CashAccount": {
"value": ""
},
"CreditCardProcessingInfo": [],
"CurrencyID": {
"value": "USD"
},
"CustomerID": {
"value": "7656TSGDB"
},
"Description": {
"value": ""
},
"DocumentsToApply": [
{
"AmountPaid": {
"value": "73.07"
},
"BalanceWriteOff": {
"value": null
},
"CustomerOrder": {
"value": ""
},
"Description": {
"value": ""
},
"DocType": {
"value": "Invoice"
},
"ReferenceNbr.": {
"value": "IN888888"
},
"WriteOffReasonCode": {
"value": ""
}
}
],
"Hold": {
"value": true
},
"OrdersToApply": [],
"PaymentAmount": {
"value": "73.07"
},
"PaymentMethod": {
"value": "CREDITCARD"
},
"PaymentRef": {
"value": "NNN-000001"
},
"ReferenceNbr.": {
"value": null
},
"Status": {
"value": "Closed"
},
"Type": {
"value": "Payment"
}
}

Thanks in advance!

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • March 2, 2021

Hi @Everville

We need to provide the details in API as the same we are giving in screen level. (DocType, Customer ID, Payment Method and etc...) Also observed an issue that you have given Hold = true and Status = Closed. (Document will never be in this condition)

 

Can you please try with the below JSON and verify.

 

{
"Type": {
"value": "Payment"
},
"CustomerID": {
"value": "7656TSGDB"
},
"PaymentMethod": {
"value": "CREDITCARD"
},
"Hold": {
"value": true
},
"PaymentAmount": {
"value": "73.07"
},
"CardAccountNbr": {
"value": "8888"
},
"Description": {
"value": ""
},
"ApplicationDate": {
"value": "2021-01-16T00:00:00.000+05:00"
},
"CashAccount": {
"value": ""
},
"CurrencyID": {
"value": "USD"
},
"DocumentsToApply": [
{
"DocType": {
"value": "Invoice"
},
"ReferenceNbr.": {
"value": "IN888888"
}
"AmountPaid": {
"value": "73.07"
}
}
]
}

 

 


  • Author
  • Freshman I
  • March 2, 2021

Hi @Naveen B,

Thanks for the info. Unfortunately, I still get the same error message.


Forum|alt.badge.img
  • Jr Varsity III
  • September 9, 2024

Hi @Naveen B,

Thanks for the info. Unfortunately, I still get the same error message.

Hello! Could you get the result with it?