This project or task has been assigned transactions. It may not be deleted.

This article replaces TK00131.

Issue:

When attempting to delete a project or task, you receive the following error.

Cause:

Transactions have been created and deleting the project or task creates orphan records.

Resolution:

Check SQL tables for data.

  1. Make a full backup.
  2. Run the following script in SQL.
     select * from pc00300 where zProjectID = '[project name]' 
     select * from pc10000 where zProjectID = '[project name]' and zTaskID = '[task name]'
     select * from pc10005 where zProjectID = '[project name]' and zTaskID = '[task name]' 
     select * from pc00210 where zProjectID = '[project name]' and zTaskID = '[task name]'
     select * from pc00295 where zProjectID = '[project name]' and zTaskID = '[task name]'
     select * from pc25000 where zProjectID = '[project name]' and zTaskID = '[task name]'
     select * from pc30000 where zProjectID = '[project name]' and zTaskID = '[task name]'
     select * from pc35000 where zProjectID = '[project name]' and zTaskID = '[task name]'

Note: The key tables to check are pc10000 (transactions table) and pc10005 (Import temp table).

  1. If you find any orphan records, note the record from the pc10000 table.
  2. Log in to Dynamics GP
  3. Navigate to Transactions | Project Cost| Transaction Maintenance.
  4. In the Transaction field, enter the Transaction you wish to remove.
  5. Click Delete.

More Information:

If the above SQL scripts return results in only some tables and you are not able to delete the transaction from within Dynamics GP, contact support@rocktonsoftware.com for further assistance on removing the orphaned records.