Directly Deleting from ACCPAC Tables

[Boris10]

Hi everyone, just wanted to consult on the issue of directly deleting from ACCPAC SQL Tables by passing SQL queries. Is there absolutely no way of making sure that data integrity is maintained once ACCPAC tables are directly deleted from. Or is there a posibillity that something can go wrong.

I want to delete a detail line from a Requisition for example. Is it sufficient to go through all the PW tables in SQL and see which tables this particular record(record detail) exists in and then deleting them.

Thank you for any advice

 

[ettienne]

There is a 100% possibility that something will go wrong, there is no way of maintaining data integrity since you are bypassing Accpac's business logic.
Requisitions are not critical, so deleting a detail line may not cause a problem but YMMV.

 

[DjangMan]

The PO module tends to be very tightly integrated between related documents. If you create a PO, receive everything so the PO is complete and then delete the PO - you can't post the invoice. For what ever reason the Invoice needs to get access to the Purchase Order.

Requisitions, like Ettienne said, are typically worksheet type documents that can be removed at any time.

Are you getting an error that is preventing you from deleting the requisition document itself?

 

[Boris10]

Ok I see, I am not trying to delete the Requisition Document but rather delete any requisition line as long as that Requisition Has not been used within a PO. So from what you are saying as long as PO is not tempered with, there is no problem in deleting PRs or PR lines.
Is there also a way of setting the status of a PR to complete without creating a PO in PW module (Programmatically).

Thank you for your help.