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 than 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?

Make sure you check purchase_req_line_tab to confirm any rogue data. I see you queried PURCHASE_REQUISITION_TAB.

@Chanu_Yazi than 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?

 

 

Hi @Noriro2 

Hi Yes. That should work.

Have you tried to search this from the front-end as I advised?

Regards,

Chanuka

@COVJAMIEB thank you for reply,

i did, and i see only one record for site (contract) “SS” which REQUISITION_NO is 117.

i am not sure what do you mean by rogue data. 

@Chanu_Yazi than 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?

 

 

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.

@Chanu_Yazi than 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?

 

 

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.

Hi @Noriro2 

So then the only option is to delete it from the database level.

I tried it myself and It works for me from the front end

Use the below SQL.

DELETE from Purchase_Requisition_tab where Requisition_no =’117’

and the same for the line.

Regards,

Chanuka

@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.

 

@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.

Thanks All for helping.

For those who needs in the future.

delete data in 

PURCHASE_REQ_LINE_TAB 

PURCHASE_REQUISITION_TAB

PART_COST_TAB

INVENTORY_PART

tables and uncheck Site in USERs