• From: Costa Rica
  • Registered: 09/25/2017
  • Posts: 10

Topic: Customer Allocation Main - Can’t allocate a transaction

Under customer allocation main, I have a specific un-allocated transaction on which when I try to allocate all I get is a blank page.

Has this happened to anyone here before?

For this specific customer a lot of transactions had to be voided, not sure if that is connected.

Thanks in advance for all the help.

2 Reply by poncho1234 (edited by poncho1234 03/04/2019 02:21:55 pm)

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

Re: Customer Allocation Main - Can’t allocate a transaction

Hi, have you activated debug in config.php? Then try the operation again and see what error appears.

Anything in the error log?

Also helpful would be version number, php & MySQL ver and op system. Try on default theme too to eliminate theme issues.

Also worthwhile  is to try on a separate clean installation to see if the issue can be replicated.

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • From: Costa Rica
  • Registered: 09/25/2017
  • Posts: 10

Re: Customer Allocation Main - Can’t allocate a transaction

After activating debugging, I get a database error: no debtor trans found for given params.

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

Re: Customer Allocation Main - Can’t allocate a transaction

So with what you stated, that part of the transaction may have been voided.

You can read about voiding a transaction here. After you have read it, try it out on your training company.

Backup your database

Its probably best to void the rest of that transaction and create a new sales order.

@apmuthu Any other suggestions?

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/

5 Reply by dLoPRod (edited by dLoPRod 04/03/2019 05:45:49 pm)

  • From: Costa Rica
  • Registered: 09/25/2017
  • Posts: 10

Re: Customer Allocation Main - Can’t allocate a transaction

The problem I have is that this specific transaction belongs to last year, the balance for last year was already closed. How can I delete the whole transaction now?

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

Re: Customer Allocation Main - Can’t allocate a transaction

Never close the year until you are absolutely sure it is correct.

So...
Roll back to backup before year close?

or

???? No other suggestions from me...

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • From: USA
  • Registered: 07/16/2017
  • Posts: 276

Re: Customer Allocation Main - Can’t allocate a transaction

Or you can unclose the year, void the transaction, (optional: delete the journal entry that was created from closing the year before) then close the year again (which creates another journal entry).

Of course this will change your P/L for the year, so this might not be want you want to do.  It may be preferable to leave the transaction alone, and use a journal entry in the current year to fix the issue.

  • From: Costa Rica
  • Registered: 09/25/2017
  • Posts: 10

Re: Customer Allocation Main - Can’t allocate a transaction

I think the best approach would be to enter journal entry on the current year to fix the customer's balance.

Thank you both very much. Cheers.