Question

The system failed to commit the Adjustments row.

  • 1 March 2021
  • 2 replies
  • 731 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!


2 replies

Userlevel 7
Badge +17

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"
}
}
]
}

 

 

Hi @Naveen B,

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

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved