Issue

The following errors may occur when attempting to print or preview a custom report or form:

• Error 1: File does not exist.
• Error 41: MEMO file is missing/invalid.

Report Form File [formname] not found.

Solution or Workaround

In Sage Pro ERP 7.3, the following tables are affected when a custom form or report is created or deleted:

Custom Form and Report Tables

Table	Description
SYRFCUS (custom reports)	Stores customized report files
SYDFCUS (custom forms)	Stores customized report form

When a custom form is created or deleted the SYDFCUS table is updated and the SYRFCUS table is updated if it is a custom report. In SYDFCUS or SYRFCUS, the Cuspath field contains the location of the customized form or report.

If a custom form is manually deleted outside of the program, one of the error messages listed in the table below may appear when attempting to use the custom form or report. This may occur because the record for that customized form or report has not been deleted from the SYRFCUS or SYDFCUS table. As a result, the program attempts to locate the custom report based on this record but cannot find it.

Possible Errors That May Occur

File Type	Table Updated	Process	Error message if file is deleted manually
REPORT.FRX	SYRFCUS	Preview	Error 1: File does not exist.
REPORT.FRT	SYRFCUS	Preview	Error 41: MEMO file is missing/invalid.
REPORT.FRX	SYRFCUS	Print	Report Form File not found.
REPORT.FRT	SYRFCUS	Print	Report Form File not found.
FORM.FRX	SYDFCUS	Print	Report Form File [formname] not found.
FORM.FRT	SYDFCUS	Print	Error 41: MEMO file is missing/invalid.

To avoid these issues, it is recommended that customized forms or reports be deleted from within System Manager or in the corresponding module where the report or form is used. Review the following two solutions to resolve this issue:

Important
Any data edits should only be done by a Sage Certified Consultant or Business Partner. Please ensure that there is a full and verified backup before proceeding. This should first be attempted in a test installation and the results should be fully verified before implementing in a live system.

• Set the Sage Pro standard form or report as default.
• Restore the custom form or report files that were deleted and complete the following steps:
  1. Remove the custom forms and reports through. System Manager. Under the Maintain, point to Customize and click either Reports or Forms. Select the form that is to be deleted.
  2. Delete the form and exit the screen.
  3. Remove the orphan records from the SYDFCUS or SYRFCUS tables.

© Copyright Sage Software