126 (edited by dopee15 06/28/2018 02:20:13 am)

Re: Import Transactions

I was able to display the freight cost by changing the parameter $freightcost = 0 to $freightcost...
BUT for import_add_to_order() I retain $freight_cost = 0... reason for this is error when payment term is "prepayment"

is this a safe way to do it?

Re: Import Transactions

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.

Re: Import Transactions

Hello thanks for the reply... I usually import data from my website(wordpress/woocommerce) which determines the shipping cost... once I upload it... It has shipping cost already.. Payment method is prepayment as customers have options to give partial payment..

Re: Import Transactions

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...

Re: Import Transactions

Have always gotten the response "You must enter reference"

I thought if it's set blank it can generate new reference ?

Mine is 2.4.3 and was using official extensions repo then replacing it with batwhete or apmuthu's one

innovation-driven technology

Re: Import Transactions

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.

Post's attachments

import_transactions.zip 50.5 kb, 2 downloads since 2020-02-07 

You don't have the permssions to download the attachments of this post.

132 (edited by aleifuuwork 02/07/2020 12:36:03 am)

Re: Import Transactions

Hi @apmuthu,

When i'm using the official repo, the error message where similar to what I saw earlier in the post. And to my knowledge and as far I've remembered I did not touch/edit any of the core files

The followings are what I've got :

Undefined index: pattern in file: /var/www/html/frontaccounting/includes/references.inc at line 80
Undefined property: import_sales_cart::$prep_amount in file: /var/www/html/frontaccounting/sales/includes/db/sales_order_db.inc at line 42
Undefined property: import_sales_cart::$fixed_asset in file: /var/www/html/frontaccounting/sales/includes/db/sales_order_db.inc at line 75
Undefined variable: ret in file: /var/www/html/frontaccounting/modules/import_transactions/includes/import_sales_cart_class.inc at line 315


Hence I thought there must be something not right /w the official extension files of import_transactions/


When I try your FA24Extensions/import_transactions ... the error message became around 'missing reference'

So far have had not success with this extension




And I'm testing this from a recently restored system that basically consist of fresh FA2.4.3 installation and an .sql from working system

Not sure if that helps because it appears that the system is missing 'pattern' definition

innovation-driven technology

Re: Import Transactions

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

innovation-driven technology

Re: Import Transactions

You have used the template at templates/single_line_salesinvoices.csv in the import_transactions extension.

There are 24 commas (,) which means that there are 25 fields in all in the said template.

FA 2.4.3 was released on 2017-10-11
FA 2.4.8 was released on 2020-02-04

Import Transactions extension was last updated in my unofficial repo on 2019-05-12.

Attached is the changed files necessary to upgrade FA v2.4.3 to 2.4.8. Check for any extra sys_prefs table entries and config.default.php variables to put into your DB and config.php file as needed.

Make sure that the address or other field does not have any commas (,).

State your PHP/MySQL/Server version and locale settings.

Post's attachments

FrontAc_v2.4.3_to_2.4.8_changed_files.zip 1.1 mb, 2 downloads since 2020-02-07 

You don't have the permssions to download the attachments of this post.

Re: Import Transactions

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

innovation-driven technology

Re: Import Transactions

Try it first in a sandbox by upgrading to 2.4.8 and with the official import transactions bundle and then replace the files with the one in Post 131 here.