If a file is reinitialized its contents are erased. The file can only be restored from a backup - assuming the backup copy is recent enough to have all the desired/required data records within.

Warning: The Reinitialize Data Files utility is used to erase and initialize individual data files. Make a backup before reinitializing any files because this process is irreversible. This utility should ONLY be used under the direction of a Customer Support Representative.

How to manually Reinitialize Data Files:

Note: The Manual method is generally safer than the "How to reinitialize data files" procedure after it. A file cannot be manually reinitialized unless it is first renamed or moved. Accidentally reinitializing the wrong file is much less likely using this procedure.

1. In Windows Explorer, open ...\Mas90\MAS_xxx\yyxxx folder (where xxx = company code and yy = module code).
2. Rename the applicable files to be manually reinitialized (for example, rename AR_InvoiceHeader.m4t to AR_InvoiceHeader.bad)

In Sage 100 ERP:

1. Select Library Master, Utilities, Reinitialize Data Files
2. Review the warning message, then select OK
3. Click Manual button
4. Type the file name (for example, AR_InvoiceHeader.m4t), press ENTER
   • NOTE: If reinitializing a legacy module file (i.e. Payroll, Job Cost, Work Order), the file name will include the applicable company code (i.e. pr6xxx.soa)
5. Select Company Code
6. Select Proceed

Note: If the file still exists, the message "File Already Defined" occurs. Either the wrong file was renamed in Windows Explorer (or the correct file in the wrong location), or the wrong file was specified in Reinitialize Data Files.

How to Reinitialize Data Files:

In Sage 100 ERP:

1. Select Library Master, Utilities, Reinitialize Data Files
2. Review the warning message, click OK
3. For Company Code, enter or select the desired company code from the lookup
4. For Module, select the desired application module
5. For each file to reinitialize (erase), select (check) the check box to the right (under the Reinitialize column)
6. Verify the correct files are selected, and that no other files were accidentally selected
7. Click Proceed
8. Select Yes at the prompt: "Warning: The Reinitialize File utility will delete all information stored within the selected data files for the company XXX. Proceed with reinitializing?" (where XXX is the company code)

For Sage 100 ERP Premium:

Note: Make a backup of the database MAS_XXX and MAS_SYSTEM. Back up the MAS90 application folder directory. Consult your network administrator or database administrator for assistance.

1. Select Library Master, Utilities, Reinitialize Data Files
2. Review the warning message, then select OK
3. Click Manual button
4. Type the file name (for example, AR_InvoiceHeader.m4t), and press ENTER
5. Select Company Code
6. Select Proceed
7. Select Erase when the "File Already Defined..." message occurs

Note: The old table is dropped, and a new table is created in the database.