• From: Canada, Kitchener, Ontario
  • Registered: 02/03/2009
  • Posts: 24

Topic: How to clean supplier allocations from backend

Hello admins,

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.

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: How to clean supplier allocations from backend

I am not sure if I understand your topic. If you want to restore the payment (unallocate) you can choose 'Show settled items'. In here you zero out the allocations and can use the payment for another allocation.

/Joe

  • rodw
  • Senior Member
  • Offline
  • From: Australia
  • Registered: 03/01/2010
  • Posts: 115

Re: How to clean supplier allocations from backend

I will add to this post. Having used FA for a while now, I think there was some buggy stuff in earlier versions (Or did I stuff it up while I was learning how to do things?).

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

[b]RodW[/b]
Brisbane, QLD, Australia
  • From: Canada, Kitchener, Ontario
  • Registered: 02/03/2009
  • Posts: 24

Re: How to clean supplier allocations from backend

Thanks Joe,

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.