| How to reinitialize Accounts Receivable Cash Receipts Entry files |
Description |
General Guidelines for determining when cash receipt files can be reinitialized:
- General Rule: The previous update of data had to have been successful for all entries. Since then, no attempt has been made to update the current data entered.
Note: Reinitializing is generally acceptable if the register was printed, as long as no attempt was made to update.
- If Batch Entry is used: If possible, all good batches should have been successfully updated. No attempt had been made to update any remaining batches that may be damaged and will be lost when the files are reinitialized.
- If Cash Receipt Data Entry is empty: If everything has been updated and no existing entries can be found, it may be acceptable to reinitialize. This is typically true for cases of "ghost" batches or "ghost" entries, or to clean up possible damage in data files after data in the files are updated.
|
Resolution | [BCB:1:Backup warning:ECB]
Note: Reinitializing or recreating data files deletes all records in the selected files and is irreversible. Always make a backup before performing this procedure. Users should not be in the system when this procedure is being performed. Data files should never by reinitialized to "fix" an interrupted update. If necessary, seek the assistance of a qualified Sage Software business partner or Sage Software Customer Support analyst.
Reinitialize the following files for A/R Cash Receipts:
Sage 100 versions 4.10 and later:
- Open Library Master, Utilities menu, Reinitialize Data Files
- In the Company Code field, select the affected company
- In the Module list, select Accounts Receivable.
- Select the following files, and click Proceed:
- AR_CashReceiptsDeposit
- AR_CashReceiptsDetail
- AR_CashReceiptsHeader
- AR_CashReceiptsRestart
- Open Library Master, Utilities menu, Rebuild Sort Files
- In the Company Code field, select the affected company.
- In the Module list, select Accounts Receivable, and then click Proceed.
Note: It is not necessary to recalculate aging or open order amounts.
- If batch entry is used, delete the batch records from the GL_CompanyActiveBatch.m4t file
-
- Library Master, Utilities menu, Data File Display and Maintenance (DFDM)
- Click the Browse button, and select "..\MAS90\MAS_XXX\GLXXX\GL_CompanyActiveBatch.m4t (xxx = company code).
- Click the Key Scan button, and select A/R Cash Receipts batch records that share the following format:
-
- Module code: 3 characters (Always "A/R")
- Batch Type: 2 digits (Always "02")
- Batch Number: 5 digits (#####, where ##### is a batch number) For example, the key "A/R0212345" would be a sample A/R Cash Receipts batch record for Batch Number 12345.
- Click the Delete button.
- Perform the steps above for any other valid A/R Cash Receipts batch record in the file.
DocLink: How to erase or manually recreate data files using the Reinitialize Data Files utility DocLink: How to Rebuild Sort Files
[BCB:155:Chat 100 US:ECB] |
|