Skip to main content

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

 

 

 

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


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 


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


Ah Ok. I will try that out.


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


Reply