Error executing the statement insertPrimaryAccountsintoReceiptLineJournalAccountPairs

When attempting to post a payment batch via Payments Journal, the posting fails due to Error executing the statement insertPrimaryAccountsintoReceiptLineJournalAccountPairs

• Payments Journal

• Payment Entry

• Accounts Receivable Charge Codes

• Accounts Receivable

• General Billing

The system is unsuccessful at pulling the required gl accounts from the charge code(s), by way of the GL Allocations tab on the receipt. The GL Allocations tab may be missing from the receipt or required account types may be missing from the charge code(s).

If a receipt in the batch is missing the GL Allocations tab, you'll want to reverse the unposted payment. When you go on to post the batch in Payments Journal, the receipt and its reversal will be dropped from the posting.

Additionally, you may want to review the charge codes in General Revenues > Accounts Receivable > Setup > Accounts Receivable Charge Codes to make sure that all accounts are populated under the Accounts tab.