Hi,
I´m working since a couple of weeks on webERP, and everything works perfectly fine. I started to post customer and supplier payments, but I got it a bit messy (my fault, nothing to do with webERP).
I was trying to revert the payments, and for some of them worked. However, one payment I can not revert, but I get this error message:
INFORMATION Message : The number of payments that will be deleted is :2
INFORMATION Message : Deleting payment number 4 to supplier code supp for an amount of -55.52
Database Error :
Cannot delete or update a parent row: a foreign key constraint fails (`justcore_weberp`.`suppallocs`, CONSTRAINT `suppallocs_ibfk_1` FOREIGN KEY (`transid_allocfrom`) REFERENCES `supptrans` (`id`))
Database SQL Failure : The SQL that failed was
DELETE FROM supptrans WHERE type=22 AND transno='4' AND trandate='2013-03-22'
Attached is also a screenshot:
Could somebody help me out? I could go to the database and delete any records directly there, but since I don´t know the entire mechanics of webERP when posting and deleting, I´d prefer not to that way (unless somebody could confidently tell me which records to delete in which tables).
Thanks a lot for any help!