Topic: import Payments/Deposits/Journal Entry from excel
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.
Re: import Payments/Deposits/Journal Entry from excel
You will have to write a module / extension for doing that.
/Joe
3 12/03/2011 09:21:38 am (edited by padma 12/03/2011 09:26:37 am)
Re: import Payments/Deposits/Journal Entry from excel
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
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
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