General guidelines for reinitializing:

1. The previous update of data was successful for all entries. Since then, no attempt has been made to update the current data.
2. You can print, but do not select Yes when prompted to update.
3. If Data Entry is empty, everything has been updated, and no existing entries can be found, it may be okay to reinitialize. This is typically for cases of ghost batches or ghost entries, or to clean up possible corruption in data files after data in the files are updated.
4. If the data files are damaged, manually reinitialize the data entry files by clicking the Manual button in the Reinitialize Data Files window. Type the file name and select the company code ( PO_ReceiptHeader.M4T) and click Proceed.
5. Click Erase to the prompt "File already defined". Do this for all the above listed files.

These steps should only be taken after careful determination of the situation. Assistance by a qualified support technician may be necessary for diagnosis. Reinitialization of data files should never be used to fix an interrupted update attempt. See notes at end for general guidelines. If necessary, seek the assistance of a qualified Sage Customer Support analyst.

Caution: Be sure to update any good Receipt of Goods and Receipt of Invoices. The PO_ReceiptReturnMatRqByPO data file is also used by PO Return of Goods and the P/O Batch Masterfile (Batch Manager) data file is used by Receipt of Goods/Invoice, Return of Goods, and Material Requisitions. Do not proceed if there are any unposted entries in these files.

To reinitialize the Purchase Order Receipt of Goods/Receipt of Invoice Data Entry files, perform the following:

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 warning
6. If Sage 100c Multi-Bin Basic is installed (valid for versions 2016 and beyond), also select files:
   • MB_POReceiptBinDistribution
   • MB_POReceiptTierBinDist

If batch entry is used, delete the batch record from GL_CompanyActiveBatch.

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:
5. 1. Module code: 2 characters (P/O)
   2. Batch Type: 2 digits (01)
   3. Batch Number: 5 digits (00002)
6. Click Delete
7. Open Library Master, Utilities, Rebuild Sort Files
8. Select to rebuild the Purchase Order sort files for the applicable Company Code, and select Yes to recalculate open purchase order quantities

DocLink: How to erase or manually recreate data files using the Reinitialize Data Files utility
DocLink: How to Rebuild Sort Files

[BCB:155:Chat 100 US:ECB]