but gives site is used in “Purchase Requis Line Part”
3- i couldn’t find the Requis Line part so i checked on DB and found the Requisition No which is in planned state
4- but i couldn’t find in IEE
how can i delete this Requisition and delete site, then i will delete the site’s company.
Need help.
Thanks.
PS EDIT: i created this question in wrong topic, sorry for this, it is my fault, can moderators move it to relevant topic.
Page 1 / 1
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
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.
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_Yazithank 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?
