Overview
If you cannot export sales invoices due to the following error message:
Crystal Report error has occurred:
Report 'filepath ending with file .rpt' was not found.
The steps below should help you to resolve this.
How to stop the error from occurring
After copying the Crystal Report (.rpt) file from the old server to the new server, please complete the steps below:-
Right-click the customised menu option to launch the Crystal report and select Edit Menu Option.
Enter the correct file path in the Report Location field.
Enter the file path, omitting the Crystal Report filename, into the Folder location.
Enter the Crystal Report file name in the File Name field.
Click OK.
How to change the file path if I am using a unique ERP system?
You may have to change the file path via a different method if they are using a unique ERP system e.g. Xero, which can be done by following the steps below:
Select Options.
System Maintenance.
System Settings.
General System Settings.
Accounting Package Details.
Select User Defined.
Click Options.
Click the Sales Export Files chevron button.
Click into Report Path and press F5.
Enter the new file path and click Open.
Click OK.
What was the cause of this error?
The Crystal Report may not open as the file path was putting '??0' at the end of it on some PC's. This was caused by the offending PC's using the wrong Unicode as the ?? were replacing the Pilcrow symbol.
The difference on the affected PC's was an option in their region settings that was a beta tick box which reads 'Beta: Use Unicode UTF-8 for worldwide language support' - unticking this resolved the issue.