Import Transactions (Page 6 of 7)

In a prepayment, we may not know the freight cost then. Whatever way you import, it is best to edit them later to reflect actuals.

Hello  when will this extension support multicurrency as in 2.4? ex : account in AED, expenses in USD?
Today, there is no currency translation depending on source account...

The said string "You must enter reference" does not exist in both the core files of FA 2.3.x and FA 2.4.x and in their respective extension files.

Please check to see if you have done any customisation of the core files where the said alert emanates.

Btw I only have 1 line in the .csv for trying the Direct Sales Invoice Processing

And this is that line
-----
Processing line 2 (10, 10, , 01/12/2020, 4, Retail, , , EKM.B02HTM48, EKONOMIS HITAM AVAL 40/28 x 02 x48, 1, Kg, 20000, 0, 0, DEF, 01/12/2020, Mr A, 1 Abe Street Glasgow G32 FHT, 134134, jj@adfa.uk, , , , ) in import file 'test_import2.csv')
------

Maybe someone with enough experience can highlight if there are simple formatting error that otherwise the program won't indicate which one is

Also my Transaction Reference pattern defined for Sales Invoice is as follows :
Sales Invoice    SI    -{YYYY}/{MM}-{001}

I thought when you leave blank at the reference colum , the module would create new reference based on the pattern ... but apparently the errors stopping it from doing so

Hi @apmuthu,

Does this mean that extension that you can install via "Install/Activate extensions" won't work with FA 2.4.3 that was released on 2017-10-11 ?

On the "Install/Activate extensions" it says it's available / suited for version 2.4.0-5

So with that mind, I thought it should be working out of the box

I'm reluctant to do upgrade at the moment, since it involves some work too to make sure data integrity isn't compromised during upgrading and such

Which 'import_transactions' version should work /w FA 2.4.3 then ? maybe i'll start with that for now

I am working on a 2.4.8 version of FA. I have downloaded and copied the directory in Post 131 into modules/import_transactions. When I try to import a set of journal entries, I get the all green messages:
( Person: 2, Reference: 5 )
2:10200
Added to table 'bank_trans': 8, 1, 5 , 11/23/19, 1500, 0, 2 (line 2 in import file 'FrontAccounting - 2020_05_11 - Rental Income test journal import.csv')
Added to table 'gl_trans' Debit bank account: 8, 11/23/19, 10200, 12, 0, 1500, ( Person: 2, Reference: 5 ) , 0, 2 (line 2 in import file 'FrontAccounting - 2020_05_11 - Rental Income test journal import.csv')
Yet I see no entries in the relevant accounts with or without the trial run indicator set.
Looking for somewhere to start looking for the problem.

My bank transactions include transfers between bank accounts.  Is there any way to make this work with Import Transactions?

Will Quick Entries do the job?

Use General Journal Processing, e.g.

000001/99,03/28/1998,"Bank Account 1:Funds Transfer",-500.00,3300,,,,,,
000001/99,03/28/1998,"Bank Account 2:Funds Transfer",500.00,1060,,,,,,

Quick Entries are to avoid importing transactions for rarely occurring transactions with a standard set of entries. They can be analysed as an anatomy of the transaction in the backup sql differences before and after a transaction and mimicked as calculated and suitably formed SQL constructs for direct application on the database.

Quick Entries is an integral part of FA and not an external module.

Hi @lawmaina78, You managed to fix the import problem?

Hmm, if you tried journal entries for bank transfers as I suggested (which works for me), and that resulted in the data corruption that you experienced, then that would be a bug.

Can you post the the input file, or at least the relevant part, that caused the missing g/l entries?  If you do, and I can confirm the bug, I may be able to fix it.

I also recommend commenting out:
// error_reporting(E_ALL);

Oddly enough, errors and notices are not shown otherwise.