Skip to main content

 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!

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.

Hi @Naveen B,

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

Hello! Could you get the result with it?

Reply


Terms & ConditionsCookie settings
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