You’re offline. This is a read only version of the page.
95
I'm trying to mass-close old POs that have not been closed or cancelled using SQL.
Can I just do the following?
UPDATE POP10100 SET POSTATUS = 5 WHERE PONUMBER in ('PO1', 'PO2','PO3'...)
This only changes the header level status, but not line-level status. I'm not sure if I will be able to remove them to history afterwards.
Or do I need to change the line-level status too? If so, would I be changing to 5 (closed) or 6(cancelled)?
Does this interfere with GP's normal process?
Any input would be appreaciated. Thank you.
*This post is locked for comments
I have the same question (0)
We do not recommend to update information on the backend unless you have to. With that being said please make sure you have backups:
UPDATE POP10100 set STATGRP = 2, POSTATUS = 5 where DEX_ROW_ID = 240843
The above script would be an example
Share
Report
All responses (
Answers (
