Error: "This purchase order number already exists in receipt of goods/Invoice/Return of Goods entry number xxxxxx. Do you want to continue with this receipt?"
Description
Cause
  • If one employee's job is to enter Receipt of Goods and another's job is to enter Receipt of Invoices, selecting Yes may be a valid selection for the situation.
  • If there are no entries currently if Receipt of Goods or Receipt of Invoice see the Resolution (below)
Resolution
[BCB:1:Backup warning:ECB]
  1. Select Yes to continue if enter the same invoice number for two separate records is a valid response. On record will be updated as an (I) Invoice and the other as an (a) Adjustment.
  2. Consider clearing the P/O Receipt Data Entry files:

Caution: The following procedure involves steps to clear (erase) all data entry files related to P/O Receipt of Goods Entry and P/O Receipt of Invoice Entry. Some files are shared with other data entries (e.g. PO_ReceiptReturnMatRqByPO is also used by PO Return of Goods and P/O Material Requisition Issue Entry) Therefore, do not proceed if there are any unposted entries in these data entry locations:

  • Purchase Order, Main menu, Receipt of Goods Entry
  • Purchase Order, Main menu, Receipt of Invoice Entry
  • Purchase Order, Mat. Req/Return menu, Return of Goods Entry
  • Purchase Order, Mat. Req/Return menu, Material Requisition Issue Entry

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:

  1. Open Library Master, Utilities, Rebuild Sort Files
  2. Click OK through the warning
  3. In the Module field select Purchase Order
  4. In the Company field select the Company affected
  5. Click the Proceed button

If Batch Entry is enabled (in Purchase Order Options), delete the batch record from GL_CompanyActiveBatch:

  1. Open Library Master, Utilities, Data File Display and Maintenance
  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:
    • Module code: 2 characters (P/O)
    • Batch Type: 2 digits (01)
    • Batch Number: 5 digits (e.g. 00002)
  5. Click Delete

DocLink: How to use the Data File Display and Maintenance (DFDM) utility
DocLink: How to erase or manually recreate data files using the Reinitialize Data Files utility
DocLink: Error: “Receipt of goods xxxxxx in batch is currently referencing this purchase order”.
Defect ID
Steps to duplicate
Related Articles