Cannot Delete duplicated Purchase Order

Question

Hi,&nbsp;I inadvertently created two purchase orders for the one inventory item and turned them into bills. One bill has been paid but not the first one created.&nbsp;The item cost is 70.07 and the Item Register display of the item shows;Date Source Qty Amount On Hand Current Value&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PJ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp;70.07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 70.07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PJ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp;70.07&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;140.14 - so far so good...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SJ&nbsp; &nbsp; &nbsp; &nbsp; -1&nbsp; &nbsp; &nbsp; -$82.44&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 57.70&nbsp; - WTF! Where does this number come from?&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PJ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;65.28&nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;122.98 - yes, there was a cost reduction&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SJ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-1&nbsp; &nbsp; &nbsp; &nbsp;-65.28&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 57.70&nbsp;The Transaction Recap for the first SJ where the weird value appears, shows it correctly took 70.07 from Inventory (a 1- account) and offset that against Cost of Sales (a 5- account). So why is that item showing as 57.70 value on hand?&nbsp;When I try to delete the first (unpaid) Purchase order, I get an error saying "Deletion of this sale of item (number) would value your inventory at less than $0.00" - well yes, because the PO has 70.07 value and the SOH has 57.70 value...If I try to add an inventory line to the PO of Qty -1 value 57.70 and save the PO, I end up with Zero stock at Zero value, but the PO has a value of 12.37. If I try deleting the PO now, I get the same error as above!&nbsp;How can I delete this PO without stuffing up my stock or GL?&nbsp;Can I make a misc PO credit (not a stock item) and apply that to the PO to "cancel" it? But will that stuff up my GL?&nbsp;This is all very frustrating and I'm hoping someone has a simple solution for me :-)&nbsp;Cheers,Philip&nbsp;&nbsp;

komal_s · Accepted Answer

Hi&nbsp;DueWest&nbsp;
&nbsp;
Yes, I meant deleting the latest transaction first and then the other ones. If it doesn't work, your file may require further analysis and so we can arrange for that to occur, send us your serial number by Private Message.&nbsp;

komal_s · Answer

Hi&nbsp;DueWest&nbsp;
&nbsp;
So we can investigate this further, can you please attach a screenshot of the Item Register Window and Item Register report ( both future-dated) for this item? Generally, if you delete the latest transaction first and then delete the transactions dated earlier, you should be able to delete all the transactions and re-record them. But if you're still getting this error, please attach the above screenshots and we can then advise accordingly. You're also welcome to send these by Private Message if they contain sensitive information.&nbsp;

duewest · Answer

Hi Komal_S,&nbsp;I've attached the grabs as requested.As you can see, I am left with the top PO having a value of $12.37 and therefore cannot delete it.&nbsp;Were you suggesting that I delete the sale (101589), then try to modify the highlighted PO (11673) back to the one item at the original price, save it and then try to delete that PO?&nbsp;Cheers,Philip

Forum Discussion

Cannot Delete duplicated Purchase Order

3 Replies

Related content

Duplicate Purchase Orders

Duplicate purchase numbers

Duplicate Purchase order number

duplicated pay

Duplicate invoice and purchase numbers

Duplicated Bank feeds

Sales invoices being duplicated

Duplicate bank transactions