Skip to main content
Question

The system failed to commit the Adjustments row.


 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
  • 3381 replies
  • 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
  • 1 reply
  • 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
  • 22 replies
  • September 9, 2024
Everville wrote:

Hi @Naveen B,

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

Hello! Could you get the result with it?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings