Sage 100

v4.4 advanced. Need to remove a couple of SO Invoice form codes. One code is blank. Neither code is displayed in Library master report settings. If there a table(s) I can edit?

Problem / Description: How to remove graphical forms (checks, invoices, etc) which do not show in the Sage 100 ERP Report Manager and therefore cannot be removed via standard functionality Resolution: - References to the form code must be removed manually: - Expand Modules, Library Master, and Utilities. Double-click Data File Display and Maintenance (DFDM). - In the File Name field, select the ...\MAS_SYSTEM\SY_ReportSetting.M4T file. - Delete the key associated with the form code. Repeat this step for the following files: - SY_ReportOption.M4T - SY_LastFormUsed.M4T - In Windows Explorer, browse to the ...\MAS90\MAS_xxx\Reports\ folder. - Delete the folder associated with the form code. Note: Review the SY_Company file in DFDM and match the Company Key with the company name to determine the correct records to delete. As always, make a backup prior to making changes to files in DFDM. Date Created: 11/10/12 Created By: WES

As always, backup anything that you would miss if it were permanently changed for the worse.

How can you remove reports when they cannot be deleted normally through Library Master - Utilities - Report Manager? Resolution: - Open Library Master / Utilities / Data File Display and Maintenance - Click on Ok to message - For Filename enter SY_ReportManagerFormat - Browse for corresponding record that references form to be removed - Select and Delete - For Filesname enter SY_ReportingSetting - Browse for corresponding record that references form to be removed - Select and Delete - For Filename enter SY_ReportOption - Browse for corresponding record that references form to be removed - Select and Delete

Thanks a million @WayneSchulz !