Finance | Project Operations, Human Resources, ...

Deleted Purchase Order Lines Still Exist and New PO Lines Start from Line Number 11

(0) Share

Report

Posted on by CU05062024-1

Hi Everyone,

I am facing an issue with a Purchase Order in Dynamics 365 Finance & Operations.

The PO originally had 10 lines, which were deleted.
When I create a new PO line, the line number starts from 11 instead of 1.
I checked the PurchLine table using Table Browser, and the original 10 lines still exist.
I also checked Procurement and sourcing > Periodic tasks > Cleanup > Correct purchase order lines manually, where all 10 lines are listed with the Deleted checkbox set to Yes.
In the Excel Add-in, no PO lines are displayed for this purchase order..

I would like to check

Same PO number how I can add the lines with line number 1

Is there a supported way to permanently delete this purchase order lines from the front end

any guidance or recommendations would be highly appreciated

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Abishek Jagadeesh 108 on at

Like (0)

Report
Copy link

Link copied!

Hi, unfortunately there's no supported way to reset the line number back to 1 on the same PO, the sequence is based on all existing records including soft-deleted lines. Best option would be to create a new PO.

Thanks,
Abishek

If this helps, please mark it as Verified so it can help others

Was this reply helpful? Yes No
CU05062024-1 18 on at

Like (0)

Report
Copy link

Link copied!

Hello Abishek

Thanks for you reply ? Is there any why this issue happened? How I can avoid this kind of issue in future ? Any possibility I can delete this lines from front end

Was this reply helpful? Yes No
Suggested answer

Abishek Jagadeesh 108 on at

Like (0)

Report
Copy link

Link copied!

Hi, this happens because when PO lines are deleted, they get soft-deleted (marked as deleted) rather than permanently removed, so the line number sequence continues from where it left off. To avoid this in future, try not to delete all lines on an existing PO, instead cancel or close it and create a new one. For permanently deleting the lines from front end, use Procurement > Periodic tasks > Cleanup > Correct purchase order lines manually, that's the only supported way. Thanks,
If this helps, please mark it as Verified so it can help others

Was this reply helpful? Yes No
CU05062024-1 18 on at

Like (0)

Report
Copy link

Link copied!

Hi, thank you for your response.
I would like to proceed with permanently deleting the PO lines. However, when I navigate to Procurement and sourcing > Periodic tasks > Cleanup > Correct purchase order lines manually, I don’t see any option to permanently delete the lines. I can only view the lines, and they are marked as Deleted = Yes.
Could you please let me know which action or option should be used from this page to permanently remove th PO lines?, I’d appreciate your guidance.

Was this reply helpful? Yes No