The COD Check Number is greater than 6 characters(s) in Sage 100 Purchase Order
Summary
The COD Check Number is greater than 6 characters(s) When going to the totals tab of a Receipt to Goods
Description
In several cases, a new User ID was created to resolve the error.
Resolution
Update all PO receipts because the next steps will clear out all receipts that were entered and not updated.
To Reinitialize the P/O Receipt Data Entry files:
1. Open Library Master, Utilities, Reinitialize Data Files
2. In the Company Code field select the affected company
3. In the Module field select Purchase Order
4. Select the following files to erase:
- PO_ReceiptDetail
- PO_ReceiptHeader
- PO_ReceiptInvoiceVarianceWrk
- PO_ReceiptReturnMatRqByPO
- PO_ReceiptTaxAllocation
- PO_ReceiptTaxDetail
- PO_ReceiptTaxSummary
- PO_ReceiptTierDistribution
- PO_ReceiptVarianceCalculation
- PO_ReturnDetail
- PO_ReturnHeader
- PO_ReturnRestart
- PO_ReturnTaxDetail
- PO_ReturnTaxSummary
To Rebuild Sort Files for the Purchase Order module:
- Open Library Master, Utilities, Rebuild Sort Files
- Click OK through the warning
- In the Module field select Purchase Order
- In the Company field select the Company affected
- Click the Proceed button
If Batch Entry is enabled (in Purchase Order Options), delete the batch record from GL_CompanyActiveBatch:
- Open Library Master, Utilities, Data File Display and Maintenance
- Browse to ..\Mas90\MAS_xxx\Glxxx (xxx = company code) file.
- Select GL_CompanyActiveBatch
- Click Key Scan, and select the batch number. For example, the key P/O0100002 has the following format:
- Module code: 2 characters (P/O)
- Batch Type: 2 digits (01)
- Batch Number: 5 digits (e.g. 00002)
- Click Delete