payment status (folio) errors

This guide will be addressing several Payment Status Errors (previously known as “Folio”) that occur when trying to send a payment to accounting. These errors will prevent payments from being successfully received by Business Central and will need to be resolved in a timely manner.

In most of these cases you will need to follow all steps before returning to the payment in question.

payment status error messages

“Exception in Business Central execution; Line 20000: Contact No. IND-013956 not found -or- ORG-xxxxxx not found”

This error is often due to a new record in CRM which has not had any accounting activity yet. Because this error can occur in a number of different scenarios, we have a separate guide - “Fiscal Transfer Error: IND -or- ORG not found” located in the Knowledge Base on the GOsupport portal. 

This error can occur when there is a contact or “customer” connected to an ORG record in Business Central when there shouldn’t be.

Solution: In Business Central, look up the ORG-xxxx shown in the error and make sure there isn’t a contact/customer connected to it. If there is, delete the ORG from record.

(Very similar steps for the error: Line #20000: Customer Account No. is blank)

“Business Central Exception; Line 20000: Customer Account No. is blank:”

When this error occurs, something needs to be changed with the ORG/Contact/Donor connected to the payment which is failing to send to Business Central.

The error can occur when a contact (Gary, for this example) has a parent constituent and a donor record without a constituent (or with a different parent constituent.) Essentially, Gary was connected to more than one record.

Solution: From the Donors tab in Business Central, search for the appropriate donor (In this case The ____ Family Trust) and click on the ORG

Open the Donor Card -> Click More Options -> Related -> Customer -> Contact

When the next screen shows the “related contacts,” you want the ORG in question to be the only contact to show up. Before resolving this issue, Gary was showing up beneath “The ___ Family Trust.”

Before resolving the error in question, Gary’s IND Contact Card had information listed in the “Company No.” and “Company Name” fields. (Having an ORG listed in a Contact’s card in Business central tends to cause errors, even if the Contact is associated with the ORG in akoya.)

To resolve, remove any information in the above highlighted fields.

This error most often occurs when the Akoya Constituent/Contact does not yet exist as a contact in Business Central. Follow through these steps, and try sending payment again after each step:

• Ensure that the Constituent/Contact is Active in akoya and activate if not (Inactive records will not transfer).
• If neither of the above steps worked--Go into the contact or constituent’s record and make a change (for example: Add Male/Female, change Street to St, or add a middle initial) SAVE the record. Go back to Business Central and re-sync. Go back to payment and try sending to accounting.
• (Go back to Contact/Constituent and undo the change only if you need to and SAVE.)

This error can be similar to the first error mentioned in this guide. For more detailed instructions, please refer to our guide - “Fiscal Transfer Error: IND -or- ORG not found” located in the Knowledge Base on the GOsupport portal

Solution: Follow the steps taken for the “Exception in BusinessCentralController.CreateGiftPayment execution; System.InvalidOperationException” error (Shown above.)

This error can occur when the contact has a parent constituent but a donor record without a constituent (or with a different parent constituent). 

Solution: Locate the Business Central Contact Record for the Contact on the Payment (usually an IND record) and remove the Company No. Value & Company Name.

Fund 00XXX DT Accounts total 0% on dd/mm/yyyy

This error usually occurs when a new fund has been created, and the DT Account “start date” is later than the posting date used on the gift payment they are trying to send to business central. In this example, the payment was 6/9/22, but the ‘start date’ for the DT account was set to 6/13/22

Solution:  Go into the fund connected to the Gift payment and back-date the “Start Date” to accommodate for the gift payment date.

We could not update the data right now. Please try again later. Technical details: A record in table Gen. Journal Line was locked for use in another session. 

This error can occur when automated entries are attempting to/failing to post in the background.

Solution: Check the General Journals "NetAssets" and "DT" for unposted entries. 

If you find entries in these journals, delete them, and then Reapportion.

(Another possibility could be that more than one user is trying to work on the same record)

“Fiscal Transfer Error…. Department is required”

This error can occur when attempting to push through a payment from CRM to Business Central. The likely cause is that the Fund attached to the payment does not have a Department connected to it. Each fund must be assigned a Department. This value is assigned to the payment once the fund is selected.  

Solution: Remove the fund value from the payment, save, then re-add the fund value. If Department is still missing, ensure the fund has a department value, and try previous steps again.