Question

Reference Nbr API Error in Payment Details after upgrading to 2021R2

  • 3 April 2023
  • 7 replies
  • 152 views

Userlevel 1
Badge

Hi,

We recently upgraded to 2021R2 and I am now unable to apply invoices to a payment via the API.

The invoice can be applied manually without issue.

 

I am seeing this error message:

"An error occurred during processing of the field Reference Nbr.: Reference Nbr. 'IN150421' cannot be found in the system.\nPX.Data.PXOuterException: An error occurred during processing of the field Reference Nbr.: Reference Nbr. 'IN150421' cannot be found in the system.",

 

This is the PUT command, using Default/17.200.001/Payment

 

{
  "ReferenceNbr":{"value":"013185"},
  "DocumentsToApply":[   
                    {
                        "AmountPaid": {"value" : "641.99" },
                        "DocType": {"value": "Invoice" },
                        "ReferenceNbr": {"value" : "IN150421" }
                    }
                   ]
}

 

Thanks in Advance for any help.


7 replies

Userlevel 7
Badge +4

@cdelacruz I dont see any issues with your REST payload but reflecting on error message, are you sure that Invoice IN150421 exists in the system and has not be paid yet?

Userlevel 1
Badge

Hi @RohitRattan88,

Thanks for confirming the code.

Yes, IN150421 is still open, I have tried multiple other invoices without luck.

I am able to create an empty payment record but unable to apply any invoices since our upgrade to 2021R2 (21.212.0039).

 

 

Userlevel 4
Badge +2

Are you able to apply the payment via the user interface inside of Acumatica?

Userlevel 1
Badge

Yes, we are able to apply via the user interface, see the screenshot:

 

Userlevel 4
Badge +2

Seeing several posts having the same issue. 

Are you on the latest build for 2021 R2?

Userlevel 1
Badge

Saw the same ones when searching for a solution.

We can apply with no problems with the UI.

Waiting a few minutes and trying again, does not work.

Production is on 21.212.0039 and we have upgraded the sandbox to test to the latest 2021 R2 21.224.0015 and the issue remains.

Userlevel 7
Badge

Hi @cdelacruz were you able to find a solution? Thank you!

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