Skip to main content
Solved

Payments Import Error


Hi All,

I am running into an issue while importing check payment transactions to the AR payments and application screen. 

My scenario setup is given below along with the error I am getting. I have Integrated CC processing enabled under 3rd party integrations and I suspect that is what is causing the problem but it really shouldn’t since this is a check payment and not a CC payment. Let me know if you guys have any ideas. Acumatica version: Acumatica 2023 R1 Build 23.111.0019

 

 

 

Best answer by Laura02

Hello,

I think the problem is missing key field Reference Nbr (2nd field on screen shot below).

For clarity, can you please show us “AR Payment Summary” screen? Do you mean Receivables → Payments and Applications?

Possibly hard-code ‘Check’ in place of Payment Method calculation above.

Thank you.

Laura

View original
Did this topic help you find an answer to your question?

5 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • January 18, 2024

Hello,

I think the problem is missing key field Reference Nbr (2nd field on screen shot below).

For clarity, can you please show us “AR Payment Summary” screen? Do you mean Receivables → Payments and Applications?

Possibly hard-code ‘Check’ in place of Payment Method calculation above.

Thank you.

Laura


  • Author
  • Freshman I
  • 3 replies
  • January 18, 2024

Hi Laura,

Thank you for your response. The reference number is not required since that is an auto generated field. The error is given on the second screenshot in my original post. 

I have edited my OP to clarify that this is for the Payments and Applications screen. 

I have tried hardcoding “CHECK” already.

Regards,
Abbas 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • January 18, 2024

Hello,

I think the Reference number is needed in the Excel data, and in the Import Scenario to tell Acumatica when one payment ends and the next begins .  If Automatic reference numbers are being used, Acumatica will assign the next number in line, during import, and will correctly number your documents.  See example, Acumatica-included Import AR Payments scenario:

Laura


  • Author
  • Freshman I
  • 3 replies
  • January 18, 2024

Ah Ok. I will try that out.


  • Author
  • Freshman I
  • 3 replies
  • January 18, 2024

Thanks Laura. That worked like a charm. Really appreciate your patience with me.


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