How to reinitialize Sales Order Invoice Data Entry files

Products

Sage 100

Country

North America

Description

How to reinitialize Sales Order Invoice Data 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.

Resolution

This procedure will remove all records related to Sales Order Invoice Data Entry. Update all Sales Order Invoice Data Entry entries/ batches before proceeding, where possible.
1. Select Library Master, Utilities, Reinitialize Data Files
2. Select the Company Code from the Company Code Lookup
3. Select Sales Order from the Module drop-down list
4. Select the following files:

SO_DailyShipment (if Enable Shipping is selected in Sales Order Setup Options)
SO_DailyShipmentPackage (if Enable Shipping is selected in Sales Order Setup Options)
SO_InvoiceDetail
SO_InvoiceHeader
SO_InvoiceRestart
SO_InvoiceTaxDetail
SO_InvoiceTaxSummary
SO_InvoiceTierCostCalcWork
SO_InvoiceTierDistribution
SO_InvoiceTracking
SO_PackageTrackingbyItem (if Enable Shipping is selected in Sales Order Setup Options)
SO_ShippingQtybyItem (for version 4.30 and earlier)

5. Click Proceed
6. 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. Select Library Master, Utilities, Data File Display and Maintenance (DFDM)
2. Browse to ..\Mas90\MAS_xxx\GLxxx (xxx = company code) file.
3. Select GL_CompanyActiveBatch.M4T and click the Open button
4. Click Key Scan button, and select the batch number. For example, the key S/O0100002 has the following format:

Module code: 2 characters (S/O)
Batch Type: 2 digits (01)
Batch Number: 5 digits (00002)

5. Click the Delete button
6. Rebuild the Sales Order sort files, and select to Yes, “recalculate open sales order quantities.”