It seems the record is visible in Time Phased Inquiry, but one is not able to delete via this program. It does not appear there is a DMT or a conversion that fits the need of deleting a PartDtl record tied to a PO line. The reason for wanting to delete the PartDtl record is there is a PO Line that …

Isnt PartDtl essentially a copart reporting? Couldnt you correct the Labor record that reported it?

Thanks Chris, To the best of my ability I do not believe there is any labor associated with this PartDtl record, instead it was created from a PO release. This is why the system does not allow the deletion of the PO line, even though there are no receipt or PartTran records.

Ah, correct, sorry I got it confused with the LaborPart record. Here is yours: PartDtl : Part Detail. Contains all of the open demand and supply records. Seems like there must be a driving record either supply or demand. The record should help you pinpoint the source. Perhaps sharing the fields fro…

I suppose details will help :slight_smile: The only place I know to interact with this record in the UI is in Time Phase Inquiry: [image] A select * from erp.partdtl where partnum = ‘4100080’ and PONum = ‘41974’ yields this result: [image]

It appears there is a receipt against it.

I presume it’s an expected receipt. If you have a PO/Line/Rel, you expect to receive it on the due date.

I have seen PartDtl be corrupted. I put in a ticket and Epicor sent a fix to get rid of the bogus line. (Which is basically an Epicor-blessed SQL delete…) For me it was a job mtlSeq that was like -9995 (negative!).

Best Way to Delete a Record from PartDtl (Other than SQL Delete)

Epicor ERP 10

bmartin (Blake Martin) May 6, 2021, 3:15pm 7

It does not appear there is a receipt in PO Tracker or any records in the RvcHead or RcvDtl for this PO. Note, I did press retrieve

Mystery source for PO Suggestion Operation

Topic		Replies	Views
Partdtl Table JobSeqNo - Negative Epicor ERP 10 part	7	1677	June 5, 2023
Cannot delete a Rcv with wrong UOM, and missing PO Epicor ERP 9	9	1921	September 6, 2018
Part Time Phrase Inquiry Epicor ERP 10 epicor	2	414	October 13, 2021
How do I delete this PO Receipt? Epicor ERP 10 epicor	8	1982	October 4, 2023
PO Detail problem with DMT Epicor ERP 10	15	4578	October 21, 2016

Best Way to Delete a Record from PartDtl (Other than SQL Delete)

Related topics