Yes I found the table that was showing the allocated amount. The supplier_trans has a column where the allocated amount is reflected. So i zeroed them in order to get the correct report.

rodw:
Following tables are affected when you perform allocation. However proceed on your own risk [Always take backup before you do any backend entries]:

1. supplier_trans column "alloc"
2. bank_trans
3. supp_allocations
4. gl_trans [accounts payable] with the total amount

You need to remove entries from these tables from your backend. Someone can correct me but as far as I know only these tables are affected.

Anyway, for me, there are a number of problems with allocations in my DB  so that some supplier accounts incorrectly show that they have a balance outstanding or they have some payments recorded that have nothing to allocate against. I would like to clean this up so they don't report or print statements.

I also have some customers with stuff I can't clear out in a similar manner too.

If the supplier part  could be answered, it would be appreciated. I am happy to clean up in the back end and leave the customer side for another post.

Rod

/Joe

Thanks for this wonderful s/w. Can someone help me cleaning supplier allocations from backend. Which tables are affected so that i can clean through queries.

Thanks.