Erase or Recreate Data Files Using using the Reinitialize Data Files utility
Description
Cause
Resolution

 CAUTION: Always make a backup of the data before reinitializing as this process is irreversible. Follow this procedure only under a Customer Support Representative guidance. 

To manually Reinitialize Data Files:

  1. Open Windows Explorer and go to ...\Mas90\MAS_xxx\yyxxx (xxx = company code, yy = module code).
  2. Rename the target file (for example: rename AR_InvoiceHeader.m4t to AR_InvoiceHeader.bad).
  3. In Sage 100 ERP, select Library Master, Utilities, then Reinitialize Data Files.
  4. Review the warning, then select OK.
  5. Click the Manual button.
  6. Type the file name (for example: AR_InvoiceHeader.m4t), then press ENTER.
    1. For legacy modules (Payroll, Job Cost, Work Order), include the company code (for example: pr6xxx.soa).
  7. Select Company Code.
  8. Select Proceed.

 NOTE: If the message “File Already Defined” appears, verify that you rename the correct file. 

To Reinitialize Data Files using the standard method:

▼ For Sage 100 ERP
  1. In Sage 100 ERP, select Library Master, Utilities, then Reinitialize Data Files.
  2. Review the warning, then click OK.
  3. Enter or select the Company Code.
  4. Select the Module.
  5. Check the box under the Reinitialize column for each file to erase.
  6. Confirm the selected files are correct.
  7. Click Proceed.
  8. Select Yes when prompted to confirm deletion for company XXX.
▼ In Sage 100 ERP Premium
  • Back up the MAS_XXX and MAS_SYSTEM databases and the MAS90 application folder
  • Consult a network or database administrator if needed
  1. Select Library Master, Utilities, then Reinitialize Data Files.
  2. Review the warning, then select OK.
  3. Click the Manual button.
  4. Type the file name (for example: AR_InvoiceHeader.m4t), then press ENTER.
  5. Select Company Code.
  6. Select Proceed.
  7. Select Erase if the “File Already Defined” message appears.

 NOTE: The utility drops the old table and creates a new table in the database. 

[BCB:155:Chat 100 US:ECB]
Steps to duplicate
Related Solutions

How to reinitialize Payroll Data Entry Files. Payroll 2.x and above