Dynamics GP Purchase Return - Cannot select PO Receipt. number is not available. Number is not in list.

This can happen in any of the following situations

• PO Receipt has a corrupt or stuck record in the POP10300 and POP10310 table from a previous return against this line item
• Run this to identify any corrupted transactions. If it returns anything, you need to run check links.
• Select * from POP10300 where poptype = 0
• Run Check Links against your purchasing module
• If this does not remove the errant record, update the type, pull up the record and delete it
• update pop10300 set poptype = 5 where poprctnm = 'RCT00001'
• PO has an Unposted Receipt - Cannot do purchase return
• If the item has not been received, it cannot be returned
• Go to Purchasing>Receiving Transaction Entries
• Look through unposted receipts to see if any are for your PO
• Or use this script to check for any unposted receipt lines
• select * from pop10310 where PONUMBER = 'PO001'
• PO Receipt has an Unposted Invoice - Cannot do purchase return with credit
• If the invoice has not been posted, there is no credit to be given
• Go to Purchasing>Enter/Match Invoices
• Look through Unposted invoices to see if any are for your PO Receipt
• Or use this script to check for any unposted invoice lines for your PO number
• select * from pop10500 where PONUMBER = 'PO001'
• Item has already been sold or removed from the cost layer
• Go to Inventory>Inquiry>Receipts
• Enter the item and the location
• Look for the Receipt Number
• If there is a value under "Quantity Sold", you cannot do a purchase return for what was sold
• You must do an inventory adjustment
• You can Return w/Credit for receipts of non-inventory items with item cards
• You can Return w/Credit for receipts of non-inventory items without item cards
• Choose Return w/Credit
• On the Purchase Return Line, Type in the Item Number first
• Now the Receipts lookup should populate correctly