Sage 100: “A Goods Receipt is currently referencing this P/O”

  • Error: “A receipt of good is currently referencing this purchase order” when accessing an existing purchase order in Purchase Order Entry
  • Error: “A receipt of invoice is currently referencing this purchase order” when accessing an existing purchase order in Purchase Order Entry
  • Error: “Receipt of Goods XXXXXX in batch is currently referencing this purchase order” when accessing an existing purchase order in Purchase Order Entry (where no batch number is referenced)

Backup Warning

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

Cause

  • A Receipt of Goods Entry or Receipt of Invoice Entry actually exists in data entry, referencing the purchase order.
  • No Receipt of Invoice Entry or Receipt of Goods Entry exists for the purchase order – the system is mistaken

Check to see if there is an actual receipt entry referencing the purchase order.

  1. Open Purchase Order, Main menu, Receipt of Goods Entry to check,
  2. Open Purchase Order, Main menu, Receipt of Invoice Entry to check.
  3. If a receipt entry is found, update the receipt or delete the receipt.

If no Receipt of Goods Entry nor Receipt of Invoice Entry exists for the purchase order, then consider clearing the receipt data entry files

Note: Reinitializing data files will erase (delete) all records in the selected file(s) and is irreversible.

Always make a backup before performing this procedure.

Before attempting to reinitialize, verify that there are no batches or entries in the following four areas:  If batches or entries exist, update them or manually delete them.

  • 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.

Reinitialize the data entry files for Purchase Order Receipt of Goods Entry and Receipt of Invoice Entry.

The files to reinitialize are:

  • PO_ReceiptDetail
  • PO_ReceiptHeader
  • PO_ReceiptInvoiceVarianceWrk
  • PO_ReceiptReturnMatRqByPO

Note: This file is shared by Receipt of Goods, Receipt of Invoice, Return of Goods, and Material Requisition Issue Entries.

  • PO_ReceiptTaxAllocation
  • PO_ReceiptTaxDetail
  • PO_ReceiptTaxSummary
  • PO_ReceiptTierDistribution
  • PO_ReceiptVarianceCalculation