FrontAccounting forum — import Payments/Deposits/Journal Entry from excel

Re: import Payments/Deposits/Journal Entry from excel

2011-12-03T09:33:58Z

The best way is to change the call to add_bank_transaction() in the import module to:

add_bank_trans($type, $trans_no, $bank_act, $ref, $date_,
$amount, $person_type_id, $person_id, $currency="", $err_msg="", $rate=0)

Re: import Payments/Deposits/Journal Entry from excel

2011-12-03T09:33:58Z

The best way is to change the call to add_bank_transaction() in the import module to:

add_bank_trans($type, $trans_no, $bank_act, $ref, $date_,
$amount, $person_type_id, $person_id, $currency="", $err_msg="", $rate=0)

You can see the function in /gl/includes/db/gl_db_bank_trans.inc.

Hope this will work.

/Joe

Re: import Payments/Deposits/Journal Entry from excel

2011-12-03T09:21:38Z

I am using FA 2.3.7. My challenge is importing multiple journal entries.

There exists an extension for multiple journal entry import.

When I click on the link to the module name in Install/Activate Extension for this module, it shows a version of - "Available version 2.3.0-1". And, the code has a top line comment of "Import Multiple Journal Entries/Deposits/Payments v2.3"

The module has a function call to add_bank_transaction() which does not exist. How do I get to the new version of code which has since been fixed (what I learned from the Forum)? Or, how do I import Multiple Journal Entries using the most up to date module? Thanks.

Re: import Payments/Deposits/Journal Entry from excel

2011-11-29T07:21:37Z

You will have to write a module / extension for doing that.

/Joe

import Payments/Deposits/Journal Entry from excel

2011-11-29T06:24:55Z

I am try to import data from excel. But there are no option for importing journal entries/deposits/payments from excel. Then how can i import data from excel.