Search options

Hi Braath:

Thanks for the reply.

************
select max(type_no) from gl_trans where type=0;
select max(trans_no) from journal where type=0;
SELECT counter, type, type_no, amount FROM gl_trans ORDER BY counter DESC LIMIT 1;
************

The first and second of these three queries return 2187.

The third query returns:
counter=28847, type=1, type_no=168 and amount=-75

*************
You could instrument the code (add the line display_notification(...)) to try to determine why it is not  2187.   Instrument this call and in last_transno()
*************

I am not entirely sure how to carry this out. I found the lines:

      add_journal(ST_JOURNAL, $curEntryId[ST_JOURNAL], ...
      ... last_transno() ...

but am not sure where to add:

      display_notification(...)

Also I am not sure what

      Instrument this call

means? I am an accountant and not a programmer.

Your help is much appreciated.

Thank you.

Bill Dika

Hi apmuthu:

I have run into a new problem.

After using the add on successfully last month I have a new problem cropping up.

When trying to import a general journal entry list of transactions, it says that the transactions are duplicates and that I cannot enter them.

When I turned on debugging I get the following message when doing a trial run  to import transactions:

**********************
trigger_error('DATABASE ERROR : cannot add journal entry
error code : 1062
error message : Duplicate entry '0-169' for key 'PRIMARY'
sql that failed was : INSERT INTO 0_journal( `type`,`trans_no`, `amount`, `currency`, `rate`, `reference`, `source_ref`, `tran_date`, `event_date`, `doc_date`) VALUES('0','169','1239.23','CAD','1','169','','2017-11-01','','')
**********************

I checked type=0 and trans_no=169 and if I understand the mysql database correctly, this was a transaction way back in 2009. My trans_no's are over 2000 now.

Any help from you or anyone else with a safe solution to my problem would be appreciated.

Thanks.

Bill Dika

I am getting the following error when trying to import transactions:

"There are no customers, or there are no customers with branches. Please define customers and customer branches."

I am trying to import a general journal transaction. I have checked my account codes and they are all correct and all except one are for expenses. The one that isn't an expense is a credit card entry.

I am using FrontAccounting 2.4.2.

I installed the import_transactions extension from the program interface and then copied over these files:

import_transactions_2017-07-24.zip

Any help would be much appreciated.

Bill Dika

Thank you for the reply apmuthu but I figured out the problem by going into phpmysqladmin.

It turns out that my account group was numbered 3300 and not 33000 and so was not showing up in my reports becauser the number was too low.

Thanks again.

bdika

My apologies. I just had to activate it in roles.

Thank you. It now works.

bdika