Understanding Intacct Cash Management Data Integration Error Messages

This article lists common error messages which may be returned from Intacct when exporting Nexonia company card transaction expense data to the Intacct Cash Management module.

In Nexonia, view these error messages from Intacct* > Integration Setup > Expense Reports > [Choose the Integration from the drop-down menu if you have more than one] > [In the Message column on the right, click "Failure" or "Partial Success" from the most recent integration log entry]. 

1967: 1967(13): source 'COMPANY CARD' is not exported 

The company credit card used on expense report 1967 belongs to comes from a transaction import source that is not enabled for export to Intacct Cash Management. 

To resolve this error:

1. In Nexonia, go to Intacct* > Integration Setup > Edit Parameters > Cash Management
2. Locate the transaction source name and change "Not Exported" to "Exported". 
3. Scroll down and locate the "Charge Card" field for all cards that come from this transaction source. 
4. Populate those fields with the Charge Card Account ID from Intacct Cash Management. 
5. Initiate the data integration again from within Nexonia at Intacct* > Expense Reports > [choose the Cash Management if you have more than one] > Transfer Now.

6666(33): card 'User Name, Cardholder Name XXXX********9999' doesn't have an Intacct Charge Card ID

The company credit card used on expense report #6666 item #33 comes from a transaction import source that is enabled for export to Intacct Cash Management, but this particular card is not mapped to an Intacct Cash Management "Charge Card Account". 

To resolve this error:

1. In Nexonia, go to Intacct* > Integration Setup > Edit Parameters > Cash Management
2. Scroll down and locate the "Charge Card" field for the card referenced in the error message. 
3. Populate that field with the Charge Card Account ID from Intacct Cash Management. 
4. Initiate the data integration again from within Nexonia at Intacct* > Expense Reports > [Choose the Cash Management option if you have more than one] > Transfer Now. 

4242: Intacct Message: Your transaction date (MM/dd/yyyy) is within a period that's been closed. You can add, modify, or delete a transaction only if the date of that transaction is within a period that's open.Enter a date that occurs on or after the date of the relevant entity, listed below. Note that different entities may have different dates: ENTITYID--Entity Name ( MM/dd/yyyy )

The accounting period into which the card transaction from report #4242 falls is closed in Intacct. The transaction date at the start of the error message is earlier than the start date of the oldest open accounting period shown at the end of the error message. 

Intacct Cash Management transactions do not have separate posting and transaction dates; the transaction date is the posting date. 

To resolve this error: 

• In Intacct, re-open this accounting period for the entity mentioned in the error message

    OR

• In Nexonia, set an export override for the transaction date. The transaction date itself will be changed to allow Intacct to accept the transaction (a Cash Management transaction has no separate posting date). Consider the implications of this step for your reconcilation process

1. Navigate to Intacct* > Integration Setup > Configuration Data > Edit Parameters > Cash Management
2. Set "Open Periods Only: Yes"
3. In the field "Period Close Date Override", enter a date that is after the start date of the oldest opening accounting period in the Intacct Entity. Exported tanasction dates that fall before this date will be exported to this date. The dates will not be changed in Nexonia. 
4. Click "OK"

The credit card 'card name' is invalid.
Currently, we can't create the transaction.
The entire transaction in this operation has been rolled back due to an error.

The charge card in Intacct likely has a an expiration date set in the past which is invalidating the card. To correct this you will have to edit the expiration date in the Intacct platform for the charge card.

1. Log in to your Intacct platform. Ensure that you have the access permissions necessary to edit charge cards in Intacct.
2. Navigate to Applications > Cash Management > Set up > Credit Card > [Click "Edit" next to the charge card ID which is producing the error in Nexonia] > Under "Credit Card details" you will see the field "Expiration"] > [Update this field with a date in the future] > Save
3. In Nexonia, attempt another export by navigating to Intacct* > Expense Reports > [Choose the Cash Management option if you have more than one] > Transfer Now. 
4. The transfer should now be successful.

1037: The credit card '<card name>' doesn't exist. [Support ID: wBBRm%7EX5vOcWENBSR3RRU9SkLyUQAAAA0] Currently, we can't create the transaction The entire transaction in this operation has been rolled back due to an error.

This means that the card name in the Nexonia Integration does not actually exist in your Intacct environment. You need to update the card names in the Nexonia integration so that they match the card names as they are in Intacct. To do so, in Nexonia,  navigate to:

1. Intacct* > Integration Setup > Configuration Data > Edit Parameters > Cash Management > [For the cards that are stated in the error, edit the names in the text fields to correct them] > OK

2. Attempt triggering another export and the issue should be resolved.

*May be labelled differently in your configuration