Skip to main content
Question

The system failed to commit the Adjustments row.

  • 1 March 2021
  • 2 replies
  • 759 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": t],
   "AppliedToDocuments": {
      "value": "73.07"
   },
   "CardAccountNbr": {
      "value": "8888"
   },
   "CashAccount": {
      "value": ""
   },
   "CreditCardProcessingInfo": I],
   "CurrencyID": {
      "value": "USD"
   },
   "CustomerID": {
      "value": "7656TSGDB"
   },
   "Description": {
      "value": ""
   },
   "DocumentsToApply": p
      {
         "AmountPaid": {
            "value": "73.07"
         },
         "BalanceWriteOff": {
            "value": null
         },
         "CustomerOrder": {
            "value": ""
         },
         "Description": {
            "value": ""
         },
         "DocType": {
            "value": "Invoice"
         },
         "ReferenceNbr.": {
            "value": "IN888888"
         },
         "WriteOffReasonCode": {
            "value": ""
         }
      }
   ],
   "Hold": {
      "value": true
   },
   "OrdersToApply": p],
   "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

Naveen Boga
Rank
Userlevel 7
Badge +19

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

 

 

Naveen B
E
Rank

Hi @Naveen B,

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

Reply


Terms & ConditionsCookie settings