Sage 100

Sage 100 advanced 2014.06. Custom statement form code gives cache error (see screenshot). KB 51884 checked out and not the problem. Standard statement works fine. Custom one works in 4.5 - brought that over to 2014, did verify database, same problem. The report does show up in the path the error mentions. Report opens from designer button correctly. Any ideas?

@PhilMcIntosh - it is possible that the user does not have permissions to the folder(s) on the server?

It happens even on the server with me logged in.

KB says to recreate the form code again and once created, then copy and paste the modified report back over the new path. It seems like they are saying that the task is corrupt.

Did that - no joy

Did you use the conversion utility? Was that successful?

Just start over with a new formcode?

Did you try this? Article Products Sage 100 Description Error: ""Report file C:\ProgramData\Sage Software\Cache\MAS 200\<report name>.rpt is not found or does not exist. Load Report Fails"" when printing from Sage 100 ERP The full error message lists each directory on a separate line. Note: ""C:\ProgramData"" is a hidden system folder. Not all users have enabled the option to display it. Disclaimer Operating System Warning This solution requires advanced knowledge of your computer's operating system. Contact your system administrator for assistance. Modifying your Windows Registry incorrectly can severely affect system operations. Sage is not responsible for operation issues caused by incorrectly modifying your Windows Registry. Always create a backup of your data before proceeding with advanced solutions. Resolution 1.From the Windows Desktop, select Start, Run ?Note: With some operating systems, select Start, Search programs and files 2.Enter System Properties Advanced 3.Press Enter or select OK to open the System Properties window, Advanced tab 4.Click the Environmental Variables button to open the Environmental Variables window 5.In the User variable for <Windows user> section, click the TEMP variable 6.Verify the path in the Value colunm for TEMP variable is correct and that the user has Read/Write access to that folder ?Note: The default value is exactly this: %USERPROFILE%\AppData\Local\Temp ?Note: Verify by accessing the location via Windows Explorer and checking the permissions. If you don't know the location, do the following: 1.From the Windows Desktop, select Start, Run ?Note: With some operating systems, select Start, Search programs and files 2.Enter CMD 3.Press Enter or select OK to open a Command Prompt window 4.Enter the following command and press the Enter key: echo %userprofile% 5.The result will display where the User Profile is stored, such as C:\Users\<Windows login> 6.The location will therefore be C:\Users\<Windows login>\AppData\Local\Temp 7.If the path in the Value column is incorrect, change it back to the default value. 8.Click OK to close the Environmental Variables window 9.Click OK to close the System Properties window 10.Reboot the workstation for changes to take affect.

new form code, KB checked and not the problem, reran conversion utility...still no joy

Is this report doing something unusual - like a strange linkage?

There is a subreport using AR_InvoiceHistoryHeader and AR_OpenInvoice

Have you tried saving the work table without the extension and running it in Crystal?

I have narrowed the problem down to the subreport. Remove it, and the statement loads. Trying to test the subreport by itself in Crystal generates a strange (non-Sage ODBC) login prompt. I hate bogus error messages...

@phil - did you ever get this figured out?

The customer is going to recreate the subreport