nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data Exception Error Trying to Delete Pay Categories

Tash2019

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 links to any card files but when we try to delete we get error message "DataException".

Is there a fix for this please?

Thanks

Tash

Find more posts tagged with

Accepted answers

gavin12345

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

All comments

Tash2019

Hi @Doreen_P

Thank you, have tried that but it continues to occur with the same payroll categories over and over.

The error message is attached.

Thank you

Tash

Error.PNG

Doreen_P

Hi @Tash2019

Thanks for your post.

Please log out then log back in to your AccountRight then try to delete those payroll categories again. If you will still receive the error message, kindly attach a screenshot of the error. Make sure to remove sensitive information from the screenshot before posting in the Forum.

Best regards,

Doreen