How to reinitialize Accounts Receivable Invoice Data Entry files in Sage 100


How to reinitialize Accounts Receivable Invoice Data Entry files in Sage 100

How to erase A/R Invoice Data Entry files

How to reinitialize or erase Accounts Receivable Invoice Data Entry files


Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions.


General Guidelines for Reinitialization:3

  1. The previous update of data must be successful for all those entries. Since then, no attempt has been made to update the current data since entered.
    Note: Printing is generally safe. Selecting “Yes” when prompted to update is not safe, since that represents an attempt to update.
  2. If Using Batch Entry: If possible, any good batches have been successfully updated. No attempts had been made to update any remaining batches that may be corrupted and are to be lost.
  3. 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.

Sage MAS 90 and 200 4.10 and later:

  1. Open Library MasterUtilitiesReinitialize Data Files
  2. Select the Company Code being used and Module = Accounts Receivable.
  3. Select the following files (file list is in alphabetical order), and click Proceed:
    • AR_InvoiceDetail
    • AR_InvoiceHeader
    • AR_InvoiceTaxDetail
    • AR_InvoiceTaxSummary
    • AR_InvoiceMemo
  4. Before Invoice Data Entry can resume, the following steps must be processed to add back the embeddedio attribute to the appropriate files:
    1. Select FileRun. enter SYZCON as the program name, and click OK.
    2. At the prompt, type the following, and press ENTER:
    3. Enter the following, and press ENTER:
      PRINT O’ACTIVATE(“A/R”,”xxx”) (where xxx = company code)
    4. The number 1 is returned if the last command was successful.
    5. Type BYE and press ENTER.
  1. If batch entry is used, delete the batch record from GL_CompanyActiveBatch.
    1. Open Library MasterUtilitiesData File Display and Maintenance (DFDM).
    2. Select the lookup, and browse to ..\Mas90\MAS_xxx\Glxxx (xxx = company code).
    3. Select GL_CompanyActiveBatch
    4. Click Key Scan, and select the batch number. For example, the key “A/RO0100002” has the following format:
      Module code: 2 characters (A/R)
      Batch Type: 2 digits (01)
      Batch Number: 5 digits (00002)
    5. Click Delete
  2. Open Library MasterRepairRebuild Application Sort Files
  3. Select to rebuild the Accounts Receivable sort files of the company.

For version 4.05 and earlier:

  1. Open Library MasterUtilities (version 3.71and below – Repair), Reinitialize Data Files
  2. Select the company code and Accounts Receivable
  3. Select the following files, and click Proceed:
    • AR7 – A/R Invoice Data Entry Header File
    • AR8 – A/R Invoice Data Entry Line File
    • AR_01 – A/R Invoice Tax Detail File (if using Sales Tax Reporting)
    • AR_02 – A/R Invoice Tax Summary File (if using Sales Tax Reporting)
    • AR_05 – A/R Invoice Batch File (if using Batch Entry for Invoice Data Entry)
  4. If using Batch Entry, delete all batch files in the format AR7#####.soa (where “#####” is a 5-character batch number such as “00123” or “D_123”). These batch files are found in the ..\ARxxx\ sub-directory within the ..\MAS90\ directory (where “xxx” is the company code).
  5. Open Library MasterRepairRebuild Application Sort Files
  6. Select to rebuild the Accounts Receivable sort files of the company.


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