Cannot Delete A Site

first delete PR line, then PR (Purchase Requisition header) and finally the site 
if you cannot find using IEE, then delete it SQL DELETE statement 

@SaaAvinak  Thank you for reply,

but i couldn’t find it on IEE, i tried to delete it with SQL;

exec Purchase_Requisition_API.Remove(117)

it gives me errors.

don't use Remove function, simply use

DELETE from Purchase_Requisition_tab where Requisition_no =’117’

and same for line.

Is it enough to delete from both PURCHASE_REQ_LINE_TAB and PURCHASE_REQUISITION_TAB tables, is it that simple?

Hi @Noriro2 

Please query “show all fields” and do a search to site “SS’’ like this “%SS%” and check whether PR gets view.

To delete the PR, please follow the below steps;

Did you try deleting all the lines and then the header? It should work in this manner. Also, the status should be in “Planned” to be able to delete a Purchase Requisition.

Try to delete the PR and see whether you could be able to delete the site’s company.

Or delete this from the table.

Use below SQL query.

DELETE from Purchase_Requisition_tab where Requisition_no =’117’

and the same for the line.

I'm happy to share my advice on this. If you found the answer helpful, please mark it as the correct answer. This will allow us to close the thread and make it easier for other community users to find and benefit from in the future.

Regards,

Chanuka

 @Chanu_Yazi thank you for reply, please follow red texts for my replies.

Hi @Noriro2 

Please query “show all fields” and do a search to site “SS’’ like this “%SS%” and check whether PR gets view.

 

I tried this and no hope can’t find it

To delete the PR, please follow the below steps;

Did you try deleting all the lines and then the header? It should work in this manner. Also, the status should be in “Planned” to be able to delete a Purchase Requisition.

 

 

Try to delete the PR and see whether you could be able to delete the site’s company.

 

Or delete this from the table.

Use below SQL query.

 

DELETE from Purchase_Requisition_tab where Requisition_no =’117’

and the same for the line.

Is it enough to delete from both PURCHASE_REQ_LINE_TAB and PURCHASE_REQUISITION_TAB tables, is it that simple?

PLEASE CONTINUE ON Cannot Delete Site | IFS Community