How to Reinitialize Bill of Materials Production Entry Files

Products

Sage 100

Country

North America

Description

How to Reinitialize Bill of Materials Production Entry Files

Disclaimer

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.
Support

Sage Customer Support does not provide assistance for issues related to third party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions. Please contact your Sage business partner, network administrator, or accountant for assistance. Please review this document for additional information on the scope of Sage Customer Support Services.

Resolution

1. Open Library Master, Utilities, Reinitialize Data Files
2. Select the Company Code being used and Module = Bill of Materials
3. Select the following files and click Proceed:
   •  BM_ProductionDetail
   •  BM_ProductionHeader
   •  BM_ProductionTierDistribution
   •  BM_TierCostCalcWork
4. If Sage 100c Multi-Bin Basic is installed (valid for versions 2016 and beyond), also select files:
   •  MB_SOInvoiceBinDistribution
   • MB_SOInvoiceBinDistribution

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

1. Open Library Master, Utilities, Data File Display and Maintenance (DFDM)
2. Select the lookup and browse to …\MAS90|MAS_xxx\GL_xxx (xxx = Company Code)
3. Select GL_CompanyActiveBatch
4. Click Key Scan and select the batch number. For example, the key “AR0100002” has the following format:
   • Module Code: 2 characters (AR)
   • Batch Type: 2 digits (01)
   • Batch Number: 5 digits (00002)
5. Click Delete
6. Open Library Master, Utilities, Rebuild Sort Files
7. Select to rebuild the Bill of Materials sort files of the company