• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Simple AS400 task for procurment

I need to delete a line absolutely, remove completely from the Purchase order, but I am told there is a limitation in the programing that will not let you remove the line. Anyone have dealings with this?
If possible, please refrain from performing deletions at this point in time.

There's more at stake than just deletiing a line. The PO detail file has references to the Cardex and other files. Deleting lines without respect to the referential integrity of your database could (and likely will) corrupt it.

Please answer the following questions:
<ul type="square"> [*]Why would a line need to be deleted? [*]Is there anything that can be done to ensure that only "correct" records enter the PO files? (This assumes that the records you need to delete are somehow incorrect.) [*]Could a purge-and-archive utility like Dave Shea's ARCTools be your answer? [/list]
I implore you to think very carefully about this.

Best regards,

-Keith Viverette, Sr.