Hi,
I have a client who's doing a few deletes of some debtors from Debtor Specific Pricing.
Using the Debtor/Debtor Class batch screen, it is taking ages - typically around 15 minutes but closer to 1 hour or more on several occasions. And it appears to lock up other users by putting on a SQL block.
During a SQL trace, I can see several SELECT statements which seem to be reading general ledger codes, and other SELECT statements which read and/or update IN_ProductAvailability.
1. Can you explain the relevance of doing all those selects? I would've though just the DELETE FROM IN_DebtorSpecificPrice WHERE RecID = <whatever> is sufficient? Or even better, DELETE FROM IN_DebtorSpecificPrice WHERE DebtorID = <whatever>.
2. Do you have any objection/reservation/comment if I just do a SQL query to get rid of those records from IN_DebtorSpecificPrice?
My SQL statement would be DELETE FROM IN_DebtorSpecificPrice WHERE DebtorID = '09876543210987654321'
Cheers
Danny