Dynamics Community Forum Thread Details

Purchase Orders that won't delete due to ‘Qty. Rcd. Not Invoiced’ stalemate

I believe I’ve discovered why some Purchase Orders can’t be deleted in BC. It boils down to 2 fields in the Purchase Order detail line: ‘Quantity Received’ & ‘Quantity Invoiced’ and the rule:
‘Quantity Received’ - ‘Quantity Invoiced’ must equal zero.

A possible sequence of events is as follows:

Purchase Order raised.
Goods received from Vendor.
Post action launched in Purchase Order page and Receive chosen at dialog below.
Posted Purchase Receipt created, which has P/O No. raised above in its Order No. field (see below):
Also, field ‘Quantity Received’ value in the Purchase Order line record auto-incremented to 1. Field ‘Quantity Invoiced’ remains unassigned (or zero).
For whatever reason, no invoice is created possibly because the customer decides they don’t want to go ahead.
An attempt is made to delete the no longer required Purchase Order and the error below is encountered. Field ‘Qty. Rcd. Not Invoiced’ contains the result of: ‘Quantity Received’ - ‘Quantity Invoiced’. Stalemate reached.

My question is: What is the text book solution to this? I could write some custom code to force a delete of the P/O, but that would leave a Posted Purchase Receipt pointing at a order that doesn't exist anymore.

Categories:

Purchasing

Hello,

On point#6 where you mentioned no invoice is created possibly because the customer decides they don't want to go ahead.

Are you doing drop shipment?

The straightforward way is to run the Undo function on the posted purchase receipt to 'return' the item to the vendor and delete the purchase order.