Error: Automation error - when merging receipts with a stack and custom data file in Hosting

When hosting users merge their custom data file receipts using a receipt stack this automation error occurs when sending to word merge wizard or merging records to the receipt file. This will occur for anyone using receipt stacks along with a custom data file. This impacts Canadian clients who are hosted.

Article
Number:67836

Products:

Raiser_s_Edge_RE

This error can occur for several different reasons. If related to the regional setting of English (Canada), this was resolved in Raiser's Edge 7.96, patch 1, released and applied to databases in Blackbaud Hosting Services in fall 2016.

If your Raiser's Edge is not hosted by Blackbaud (self-hosted/locally installed): Download and install the Raiser's Edge 7.96 patch 1, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch.

Note: This will change the date format printed on the receipts, so may require manual correction of the receipts if the date format of dd/mm/yyyy is needed.

OR

Use the Receipt function to generate receipt numbers and choose to create an Output query. Use the Output query from Receipts to create a custom merge document in the Export module.

Run the existing template with receipt type custom data file and no stack (this will allow you to copy the template and see which fields you need, I would paste this into a new word document for the time being)

Run the receipts with type preprinted and the proper stack and choose at the bottom to output a gift query (this will allow you to generate the proper receipt numbers for the gifts) preview and then close the preview, choosing to receipt the gifts

Use the gift query from Step 2 in export with a gift export and the type Blackbaud Simple Word Merge.

Output the fields from your template in step 1 and choose to edit the document

Paste your template into the document and replace all merge fields (pasted merge fields will not work properly)

Choose Return to RE 7 to merge from the add-ins tab

Click the Merge button on the bottom right

This will generate the receipts on your template with the proper receipt stack numbers. Once this export template is set up then it will be a simple two step process moving forward, until we resolve the issue in hosting.

OR

Use Acknowledgement Letters in Mail, which can include receipt numbers: