Use caution before reinitializing data files

• Only take these steps after you’ve carefully reviewed the situation.
• You’ll need help from a qualified support technician to diagnose complex issues.
• Don’t use data file reinitialization to fix an interrupted update.

 NOTE: If needed, contact a Sage Customer Support analyst for help. See general guidelines at the end of the article. 

General guidelines for reinitializing

1. The previous update of data was successful for all entries. Since then, you've made no attempt to update the current data.
2. You can print, but don’t select Yes when prompted to update.
3. If Data Entry’s empty and the system finds no entries, you can safely reinitialize the data files.
   • This is typically for cases of ghost batches or ghost entries.
   • or to clean up possible corruption in data files after you update data in the files.
4. Click the Manual button in the Reinitialize Data Files window if the data files look damaged.
5. Type the file name and select the company code (PO_ReceiptHeader.M4T).
6. Click Proceed.
7. Click Erase to the prompt "File already defined". Do this for all the above listed files.

 CAUTION: Update all Receipt of Goods and Receipt of Invoices before you continue. Don’t continue if you didn't post any entries in PO_ReceiptReturnMatRqByPO or P/O Batch Masterfile. Receipt of Goods, Return of Goods, and Material Requisitions uses these files.  

Reinitialize the Purchase Order Receipt of Goods/Receipt of Invoice Data Entry files

1. Open Library Master, Utilities, Reinitialize Data Files.
2. In the Company field, select the affected company code.
3. In the Module field, select Purchase Order.
4. Select the following files:
   • PO_ReceiptDetail
   • PO_ReceiptHeader
   • PO_ReceiptRestart
   • PO_ReceiptReturnMatRqByPO (also used by PO Return of Goods data entry)
   • PO_ReceiptTaxAllocation
   • PO_ReceiptTaxDetail
   • PO_ReceiptTaxSummary
   • PO_ReceiptTierDistribution
   • PO_ReceiptVarianceCalculation.m4t
5. Click Proceed and Yes to the warning.
6. If you installed Sage 100c Multi-Bin Basic, also select files:
   • MB_POReceiptBinDistribution
   • MB_POReceiptTierBinDist

If batch entry is used 

1. Open Library Master, Utilities, Data File Display and Maintenance (DFDM).
2. Browse to ..\Mas90\MAS_xxx\Glxxx (xxx = company code) file.
3. Select GL_CompanyActiveBatch.
4. Click Key Scan, and select the batch number. For example, the key P/O0100002 has the following format.
   • Module code: Two characters (P/O)
   • Batch Type: Two digits (01)
   • Batch Number: Five digits (00002)
5. Click Delete.
6. Open Library Master, Utilities, Rebuild Sort Files.
7. Select to rebuild the Purchase Order sort files for the applicable Company Code.
8. Select Yes to recalculate open purchase order quantities.

Erase or manually recreate data files using the Reinitialize Data Files utility
How to Rebuild Sort Files