How to Reinitialize Work Order Transaction Data Entry Files in Sage 100


How to Reinitialize Work Order Transaction Data Entry Files
Backup Warning
Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.


Warning: Caution should be taken whenever Repair utilities in the Library Master module are used. 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 NEVERbe used for “fixing” an interrupted update attempt. Please read General Guidelines for Reinitialization below.
1. Open Library Master, Utilities, Reinitialize Data Files.
2. Select Work Order module and Company Code from look ups.
3. Select ONLY the following files for Reinitialization:
WOK – Trans Register Sort Of WOR
WOR – W/O Transaction Entry Header File
WOS – W/O Transaction Entry Detail
WOT – W/O Transaction Entry Additional Header
WOU – W/O Transaction Entry Tier Distribution File
WO_04 – W/O Batch Masterfile (if using batches)
4. If using Batch Entry, delete all batch files in the format WOR#####.soa, WO_04#####.soa, and WOK#####.soa files (where “#####” is a 5-character batch number such as “00123” or “D_123”, etc.). These batch files are found in the \WOXXX\ sub-directory within the \MAS90\ directory (xxx=company code).
5. Open Library Master, Utilities, Rebuild Sort Files.
6. Select Work Order module and select applicable Company Code, click Proceed
7. Click Yes at the message, “Would you like to recalculate Open Work Order Quantities in the Inventory Masterfile also?”


1. General Rule: The previous update of data in Work Order Transaction Entry was successful for ALL those entries. Since then, no attempt has been made to update any data entered into Work Order Transaction Entry. (Note: Printing is generally OK. Choosing “Yes” when prompted to update is NOT OK.). Loss of data is acceptable, re-keying of entries is feasible.
2. If Data Entry is Empty: If 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.


If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.