How to Reinitialize Purchase Order Receipt of Goods or Receipt of Invoice in Sage 100

Description

How to Reinitialize Purchase Order Receipt of Goods or Receipt of Invoice

Purchase Order Receipt of Goods/Invoice Reinitialize List

Disclaimer

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

Resolution

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