SQL bug in Item Maintenance re. stock category

[phil]

Did you post to the correct thread here?
It sounds as though you have incorrect set up of GL accounts - I'd say you really need some professional support and your issues are not specific enough to be able to diagnose on the forum.
Don't be frightened to ask for paid support if you need someone to login and spend an hour sorting out a problem for you there is a list of support people at - this is a good way to give back to the people who make this software possible for everyone.
http://www.weberp.org/Support.html

You can delete general ledger transactions from the gltrans table and rerun the posting from Z_RePostGLFromPeriod.php However, you will end up with inconsistent transactions elsewhere and stock movements orphaned etc - ongoing problems will recurr. Deleting gltrans really needs professional support or deep knowledge of the system