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.
@Chanu_Yazi than you for reply, please follow red texts for my replies.
Chanu_Yaziwrote:
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
Chanu_Yaziwrote:
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?
@Chanu_Yazi than you for reply, please follow red texts for my replies.
Chanu_Yaziwrote:
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
Chanu_Yaziwrote:
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?
Hi @Noriro2
Hi Yes. That should work.
Have you tried to search this from the front-end as I advised?
@Chanu_Yazi than you for reply, please follow red texts for my replies.
Chanu_Yaziwrote:
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
Chanu_Yaziwrote:
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?
@Chanu_Yazi than you for reply, please follow red texts for my replies.
Chanu_Yaziwrote:
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
Chanu_Yaziwrote:
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?
Hi @Noriro2
Hi Yes. That should work.
Have you tried to search this from the front-end as I advised?
Regards,
Chanuka
@Chanu_Yazi i did, as you suggested i checked on IEE but i couldn’t find it.
i did delete the data from DB, but it still gives exactly the same errors, i cannot delete the site. what else i should check?
kinds.
Hi @Noriro2
Very strange.
Is this issue in a live environment or a test?
Regards,
Chanuka
it is on TEST env. i want to delete site and the company then i will create new one because the one exists has created with incomplete information and cannot change it.
i did delete the data from DB, but it still gives exactly the same errors, i cannot delete the site. what else i should check?
kinds.
Hi @Noriro2
Very strange.
Is this issue in a live environment or a test?
Regards,
Chanuka
it is on TEST env. i want to delete site and the company then i will create new one because the one exists has created with incomplete information and cannot change it.
i did delete the data from DB, but it still gives exactly the same errors, i cannot delete the site. what else i should check?
kinds.
Hi @Noriro2
Very strange.
Is this issue in a live environment or a test?
Regards,
Chanuka
it is on TEST env. i want to delete site and the company then i will create new one because the one exists has created with incomplete information and cannot change it.
Hi @Noriro2
Please restart the application and see.
Regards,
Chanuka
i found why it gives exact same errors because i didn’t commit, my fault.
After commit, i receive different error;
i checked Cost Template “P-110” it is for different Site, not for the one i want to delete.
i did delete the data from DB, but it still gives exactly the same errors, i cannot delete the site. what else i should check?
kinds.
Hi @Noriro2
Very strange.
Is this issue in a live environment or a test?
Regards,
Chanuka
it is on TEST env. i want to delete site and the company then i will create new one because the one exists has created with incomplete information and cannot change it.
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 than you for reply, please follow red texts for my replies.
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
Chanu_Yaziwrote:
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?
Make sure you check purchase_req_line_tab to confirm any rogue data. I see you queried PURCHASE_REQUISITION_TAB.
Noriro2wrote:
@Chanu_Yazi than you for reply, please follow red texts for my replies.
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
Chanu_Yaziwrote:
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?
Hi @Noriro2
Hi Yes. That should work.
Have you tried to search this from the front-end as I advised?
Regards,
Chanuka
COVJAMIEBwrote:
Make sure you check purchase_req_line_tab to confirm any rogue data. I see you queried PURCHASE_REQUISITION_TAB.
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
Chanu_Yaziwrote:
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?
Have you tried to search this from the front-end as I advised?
Regards,
Chanuka
@Chanu_Yazi i did, as you suggested i checked on IEE but i couldn’t find it.
Noriro2wrote:
Chanu_Yaziwrote:
Noriro2wrote:
@Chanu_Yazi than you for reply, please follow red texts for my replies.
Chanu_Yaziwrote:
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
Chanu_Yaziwrote:
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?
Hi @Noriro2
Hi Yes. That should work.
Have you tried to search this from the front-end as I advised?
Regards,
Chanuka
@Chanu_Yazi i did, as you suggested i checked on IEE but i couldn’t find it.
it is on TEST env. i want to delete site and the company then i will create new one because the one exists has created with incomplete information and cannot change it.
i did delete the data from DB, but it still gives exactly the same errors, i cannot delete the site. what else i should check?
kinds.
Hi @Noriro2
Very strange.
Is this issue in a live environment or a test?
Regards,
Chanuka
it is on TEST env. i want to delete site and the company then i will create new one because the one exists has created with incomplete information and cannot change it.
i did delete the data from DB, but it still gives exactly the same errors, i cannot delete the site. what else i should check?
kinds.
Hi @Noriro2
Very strange.
Is this issue in a live environment or a test?
Regards,
Chanuka
it is on TEST env. i want to delete site and the company then i will create new one because the one exists has created with incomplete information and cannot change it.
Hi @Noriro2
Please restart the application and see.
Regards,
Chanuka
i found why it gives exact same errors because i didn’t commit, my fault.
After commit, i receive different error;
i checked Cost Template “P-110” it is for different Site, not for the one i want to delete.
Noriro2wrote:
Chanu_Yaziwrote:
Noriro2wrote:
Chanu_Yaziwrote:
Noriro2wrote:
@SaaAvinak
@Chanu_Yazi
@COVJAMIEB
I apologise for the notice if it bothers you.
i did delete the data from DB, but it still gives exactly the same errors, i cannot delete the site. what else i should check?
kinds.
Hi @Noriro2
Very strange.
Is this issue in a live environment or a test?
Regards,
Chanuka
it is on TEST env. i want to delete site and the company then i will create new one because the one exists has created with incomplete information and cannot change it.
Hi @Noriro2
Please restart the application and see.
Regards,
Chanuka
i found why it gives exact same errors because i didn’t commit, my fault.
After commit, i receive different error;
i checked Cost Template “P-110” it is for different Site, not for the one i want to delete.
found the table ```PART_COST_TAB``` and deleted all data which cause error, and inventories belongs to site, then i am able to delete the site.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.