Skip to main content
Question

Inserting 'AR Payment' record raised at least one error. CashAccountID: 'Cash Account' cannot be empty

  • July 9, 2025
  • 11 replies
  • 169 views

Hello,

I get below error when trying to create prepayment from Sales order API, where the payment method is “BACS”: Direct deposit.

Errors - message - An error has occurred.
exceptionMessage - Inserting  'AR Payment' record raised at least one error. Please review the errors.
CashAccountID: 'Cash Account' cannot be empty.
exceptionType - PX.Api.ContractBased.OutcomeEntityHasErrorsException

The error indicates Cash Account is missing, even though I am sending both payment method and cash account in my request. 

I can create payment for other payment methods, but same request doesn’t work when payment method is BACS. Are we missing any configuration at Acumatica? I found discussions on same error in the forum but the fix did not work in my case. 

Has anyone faced this issue, please share your inputs.

TIA

11 replies

dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • July 9, 2025

@RealisableSoftware If you can share the details of the call here then might help troubleshoot it.

Have you tried setting a default cash account on the Payment Method of Bacs just to see if that works for testing.


mohammadnawaz51
Jr Varsity I
Forum|alt.badge.img+4

Forum|alt.badge.img
  • Varsity I
  • July 9, 2025

Generally, I have found this issue is caused by branch restrictions.  The best test is try creating the payment manually.


@johnw51

I am able to create the payment manually in the UI, but doesn’t create from API.


Forum|alt.badge.img
  • Varsity I
  • July 9, 2025

And you are sure that the branch the API is logged into, the branch of the sales order are the same, and it is an allowed branch for the cash account?

Also, are you trying to use the Create Prepayment action on the sales order or are you creating a payment document with the type of Prepayment and linking it to the sales order.  I have only had success with the latter. 


Hi ​@johnw51,

I am trying to create payment document with pre-payment type in Sales order. This is actually working when the payment method is “credit card”. The same response fails when the payment method is changed to any other.

My Payment request looks like this:
"Payments": [
    {
      "PaymentAmount": {
        "value": 31.76
      },
      "Currency": {
        "value": "EUR"
      },
      "AppliedToOrder": {
        "value": 31.76
      },
      "DocType": {
        "value": "Prepayment"
      },
      "PaymentMethod": {
        "value": "BACS"
      },
      "ExternalRef": {
        "value": "420"
      },
      "CashAccount": {
        "value": "20010"
      }
    }
  ]

We do not have multiple branches in this Acumatica, so I doubt if this error could be branch related.


Forum|alt.badge.img
  • Varsity I
  • July 14, 2025

As I mentioned, I found that creating the prepayment and applying it to the sales order worked better.  Try doing a PUT to the Payment entity like this:

{

    "Type": {

        "value": "Prepayment"

    },

    "ApplicationDate": {

        "value": "2020-11-11T10:24:56-05:00"

    },

    "PaymentRef": {

        "value": 1006

    },

    "CustomerID": {

        "value": "S-0007231"

    },

    "CashAccount": {

        "value": "10500"

    },

    "PaymentAmount": {

        "value": "43.89"

    },

    "Description": {

        "value": "Mary Jones"

    },

    "OrdersToApply": [

        {

            "OrderType": {

                "value": "DT"

            },

            "OrderNbr": {

                    "value": "000405"

            },

            "AppliedToOrder": {

                    "value": 43.89

            }

        }

    ]

}

 


ricoybanez
Jr Varsity III
Forum|alt.badge.img+3
  • Jr Varsity III
  • July 15, 2025

@RealisableSoftware 

Please check on the Payment Methods (CA204000) select the Payment Method ID = BACS, if you added Cash Account on the ‘ALLOWED CASH ACCOUNTS’ Tab

 

 


Hi ​@ricoybanez,

Thanks for checking, the cash account is added in Allowed cash account. Sharing my payment method setup. 
 

 

Thanks,

Indhu.


ricoybanez
Jr Varsity III
Forum|alt.badge.img+3
  • Jr Varsity III
  • July 16, 2025

@RealisableSoftware 

 

your welcome


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • September 24, 2025

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