Forum Discussion

Tash2019's avatar
Tash2019
Experienced Cover User
2 years ago

Data Exception Error Trying to Delete Pay Categories

Hi there,   We are trying to clean up our file and removing unusued payroll categories which have NO linked transactions. We have removed these pay categories from standard pays so they have no lin...
  • gavin12345's avatar
    gavin12345
    2 years ago

    Hi Tash2019 

     

    The error:

     

    The primary key value cannot be deleted because references to this key still exist. [ Foreign key constraint name = FK_ReportablePaymentSummaryFieldPayrollCategoryMap_PayrollCategory ]

     

    indicates that these payroll categories have been mapped for payment summary purposes.  So they are 'in use' and MYOB will not allow you to delete - As I mentioned - the developers didn't consider this possibility, and so did not provide a useful message to guide you to a solution. 

     

    Try going to Command Centres > Payroll > Prepare Payment Summaries (from menu bar) and go to the mapping screen and untick or de-select these pay categories, they will be linked to Gross and or Allowances - perhaps untick all.

     

    Then try to delete.

     

    Regards

    Gavin

Tash2019's avatar
Tash2019
Experienced Cover User

This might help - I got an error log this time (attached)

gavin12345's avatar
gavin12345
Ultimate User
2 years ago

Hi Tash2019 

 

The error:

 

The primary key value cannot be deleted because references to this key still exist. [ Foreign key constraint name = FK_ReportablePaymentSummaryFieldPayrollCategoryMap_PayrollCategory ]

 

indicates that these payroll categories have been mapped for payment summary purposes.  So they are 'in use' and MYOB will not allow you to delete - As I mentioned - the developers didn't consider this possibility, and so did not provide a useful message to guide you to a solution. 

 

Try going to Command Centres > Payroll > Prepare Payment Summaries (from menu bar) and go to the mapping screen and untick or de-select these pay categories, they will be linked to Gross and or Allowances - perhaps untick all.

 

Then try to delete.

 

Regards

Gavin

  • Tash2019's avatar
    Tash2019
    Experienced Cover User
    2 years ago

    That seems to have done the trick - thank you so much! You've saved us a huge amount of hassle!

     

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.