Hi all,
I'm trying to delete a GL that was created in error. It has no funds associated with it yet. When I highlight the line and then click Delete, the line disappears, but when I try to save I'm blocked by an "Error #:547:Foreign Key Violation" and can't seem to get past it. The GL description did have a "-" hyphen in it, so I tried taking that out, but no dice. Does anyone know why this error is throwing?
Thanks for your advice,
Sara.
Hello Sara,
A foreign key prevents you from deleting items from the database if they have been referenced in other tables.Can you simply rename or inactivate this G/L account rather than deleting?
Ah, I see. Thank you. I'll inactivate.