Hello Team,
I found the following error with payments.
1. I have created a payment via API. The payment is being created successfully.
2. Then I use a payment to allocate with invoice or credit memo via API to pay it.
3. Send the payment with allocation to the invoice or credit memo to Acumatica via API.
Acumatica returns the following error message:
Payment update request returns the error message - "exceptionMessage": "An error occurred during processing of the field Reference Nbr.: Reference Nbr. 'AR.......' cannot be found in the system.\nPX.Data.PXOuterException: An error occurred during processing of the field Reference Nbr.: Reference Nbr. 'AR......' cannot be found in the system."
When I repeat the same Payment update request after a period of time (in 1,5,10,20 minutes), Acumatica creates a payment successfully.
Could you clarify what is the reason of this behavior?
Error during the payment updаte via API
The API is throwing an error that you are not populating the ReferenceNbr field correctly. Since you are updating the record, you need to provide a correct primary key field for the system to know what record to update. It looks like your Reference Number is literally: AR...…
So maybe this was some stub code where the correct concatenation isn’t in there yet to properly populate the field?
We use our integration.
I mean that our connector uses API calls to receive data.
As for the error message, here the real example of the error message:
"innerException":{"message":"An error has occurred.","exceptionMessage":"An error occurred during processing of the field Reference Nbr.: Reference Nbr. 'AR006170' cannot be found in the system.","exceptionType":"PX.Data.PXFieldProcessingException","stackTrace":" at PX.Data.SessionRollback.ProcessUpdateException[ExceptionType](ExceptionType ex, PXCache cache, IDictionary keys, IDictionary values)\r\n
It means that we created the allocation between payment and Invoice AR006170.
When we sent this request firstly, we received this error message presented above.
But during the second attempt in a few minutes, Acumatica returned the successful answer that payment with allocation to the invoice AR006170 was created.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.