1 Reply by jornrikkers

(154 replies, posted in Modules Add-on's)

Hi Ross,

In modules/import_transactions/includes/import_transactions.inc replace line 634:

        $sql = "SELECT id, type, trans_no, amount FROM ".TB_PREF."bank_trans ORDER BY id DESC LIMIT 1";

with

        $sql = "SELECT id, type, trans_no, amount FROM ".TB_PREF."bank_trans WHERE `type` =".$type." ORDER BY id DESC LIMIT 1";

Although ST_BANKDEPOSIT and ST_BANKPAYMENT are stored in the same table they use separate transaction numbers. I tried to import bank deposits, unfortunately the transaction id's that were assigned were already in use.

Probably line 651 must be changed accordingly to separate the sales orders and invoices, but I haven't checked that!

Go to forum: Modules Add-on's

2 Reply by jornrikkers

(154 replies, posted in Modules Add-on's)

Hi all,

I'm having some difficulties importing journals. The file contains multiple journals. Each journal contains multiple lines.

reference,date,memo,amount,accountcode,taxtype,dim1_ref,dim2_ref,person_type_id (supplier=1 customer=2),person_id
JNL1,03-07-2014,test,23.30,8000,0,,,,
JNL1,03-07-2014,test,173.90,8001,0,,,,
JNL1,03-07-2014,test,-16.00,1700,0,,,,
JNL1,03-07-2014,test,10.00,1701,0,,,,
JNL1,03-07-2014,test,-191.20,1310,0,,,,
JNL2,04-07-2014,test,49.00,8000,0,,,,
JNL2,04-07-2014,test,122.05,8001,0,,,,
JNL2,04-07-2014,test,-171.05,1310,0,,,,

After processing all lines are packed into a single journal (#822). What am I missing?

The processing output is:

Skipped header. (line 1 in import file 'kassabonnen.csv') 
--------------------------------------------------------------------------------------------Line 2 ------------------------------------------------------------------------------------------
Added to table 'gl_trans' Debit: 822, 03-07-2014, 8000, 0, 0, 23.3, test Date: 03-07-2014 Reference: JNL1 (line 2 in import file 'kassabonnen.csv') 
--------------------------------------------------------------------------------------------Line 3 ------------------------------------------------------------------------------------------
Added to table 'gl_trans' Debit: 822, 03-07-2014, 8001, 0, 0, 173.9, test Date: 03-07-2014 Reference: JNL1 (line 3 in import file 'kassabonnen.csv') 
--------------------------------------------------------------------------------------------Line 4 ------------------------------------------------------------------------------------------
Added to table 'gl_trans' Credit: 822, 03-07-2014, 1700, 0, 0, -16, test Date: 03-07-2014 Reference: JNL1 (line 4 in import file 'kassabonnen.csv') 
--------------------------------------------------------------------------------------------Line 5 ------------------------------------------------------------------------------------------
Added to table 'gl_trans' Debit: 822, 03-07-2014, 1701, 0, 0, 10, test Date: 03-07-2014 Reference: JNL1 (line 5 in import file 'kassabonnen.csv') 
--------------------------------------------------------------------------------------------Line 6 ------------------------------------------------------------------------------------------
Added to table 'gl_trans' Credit: 822, 03-07-2014, 1310, 0, 0, -191.2, test Date: 03-07-2014 Reference: JNL1 (line 6 in import file 'kassabonnen.csv') 
--------------------------------------------------------------------------------------------Line 7 ------------------------------------------------------------------------------------------
Added to table 'gl_trans' Debit: 822, 04-07-2014, 8000, 0, 0, 49, test Date: 04-07-2014 Reference: JNL2 (line 7 in import file 'kassabonnen.csv') 
--------------------------------------------------------------------------------------------Line 8 ------------------------------------------------------------------------------------------
Added to table 'gl_trans' Debit: 822, 04-07-2014, 8001, 0, 0, 122.05, test Date: 04-07-2014 Reference: JNL2 (line 8 in import file 'kassabonnen.csv') 
--------------------------------------------------------------------------------------------Line 9 ------------------------------------------------------------------------------------------
Added to table 'gl_trans' Credit: 822, 04-07-2014, 1310, 0, 0, -171.05, test Date: 04-07-2014 Reference: JNL2 (line 9 in import file 'kassabonnen.csv')
8 General Journals would have been successful if imported. Uncheck Trial check before importing.

Hopefully someone will be able to help me out. Thanks in advance!

Go to forum: Modules Add-on's