It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by ion
Pages 1
What's the easiest way to enter an invoice?
I used a system before where you enter the customer name, the description, the price and tax type and save.
Is there something similar in FA?
From what I can see, I need to have a customer in the system, and Item in the inventory before I can create an invoice.
Looking forward for your feedback.
Thanks,
Ion
There is a option in the import paypal setup to create customers and invoices, I have that checked.
And when I run it it actually created some of the customers that were not in the system.
The problem is that at some point it fails and I can't figure out why.
If you don't have that option checked, it will only write a bank transaction even if you have the customer and the invoice.
Ion
I am not 100% sure what the code tries to do.
Here is my understanding of what the intent is:
- Create customer if it does not exist.
- Create invoice for the customer.
- Add customer payment.
Let me know if this is not right.
Will try based on these assumptions and report back.
Ion
I did not use a table prefix.
Running the sql returns 0 rows.
Ion
I am still getting the database error:
[25-Apr-2015 01:34:17 America/Toronto] <b>DATABASE ERROR :</b> no debtor trans found for given params<br>sql that failed was : SELECT trans.*,ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total,cust.name AS DebtorName, cust.address, cust.curr_code, cust.tax_id, com.memo_, shippers.shipper_name, sales_types.sales_type, sales_types.tax_included, branch.*, cust.discount, tax_groups.name AS tax_group_name, tax_groups.id AS tax_group_id FROM debtor_trans trans
LEFT JOIN comments com ON trans.type=com.type AND trans.trans_no=com.id
LEFT JOIN shippers ON shippers.shipper_id=trans.ship_via,
debtors_master cust, sales_types, cust_branch branch, tax_groups WHERE trans.trans_no=''
AND trans.type='10'
AND trans.debtor_no=cust.debtor_no AND sales_types.id = trans.tpe
AND branch.branch_code = trans.branch_code
AND branch.tax_group_id = tax_groups.id <br><br><br>
Any suggestions?
Ion
I have checked the files, they seem to be the same.
Ion
I do not understand the function write_bank_receipt in modules/import_paypal/import_paypal_update.php.
Line 132 reads:
function write_bank_receipt($date, $ref, $name, $shipping, $insurance, $tax, $gross, $fee, $net) {
In my case the function is called with:
tax = 0
gross = 134
fee = -7.54
net = 126.46
By the end of the function call, the only entry that get's created is for the fee.
The gross and net are not handled.
I think it's missing the handling for the net amount.
Any thoughts?
Ion
Hi Ap.Muthu,
I am running Import Paypal transactions version 2.3.10-3. FA is version 2.3.24.
I made the change you suggested but it did not make a difference. I think the code in sales/includes/db/payment_db.inc is correct.
I found one of the issues: in modules/import_paypal/import_paypal_update.php at line 117, the call to write_customer_payment does not match with the definition in sales/includes/db/payment_db.inc. There are 13 arguments in the call, the function definition has only 12:
$payment_no = write_customer_payment(0, $customer_id, $branch_id,
$paypal_bank_id, $recpt_date, $ref,
$gross, 0, $company, 1, 0 - $fee, $gross, $paypal_fee_act);
I replaced the line with the following:
$payment_no = write_customer_payment(0, $customer_id, $branch_id,
$paypal_bank_id, $recpt_date, $ref,
$gross, 0, $company, 1, 0 - $fee, $paypal_fee_act);
Seems to be working, I don't get the Both parameters should have an equal number of elements error any more but I still get the database error.
Similarly, the calls to write_bank_transaction in modules/import_paypal/import_paypal_update.php have fewer arguments than defined in the definition.
I will investigate further and report back.
Ion
I also noticed some errors in the error.log:
[22-Apr-2015 23:59:50 America/Toronto] 0:admin:payment_db.inc:31: array_combine(): Both parameters should have an equal number of elements
[22-Apr-2015 23:59:50 America/Toronto] 0:admin:payment_db.inc:31: array_combine(): Both parameters should have an equal number of elements
[22-Apr-2015 23:59:50 America/Toronto] <b>DATABASE ERROR :</b> no debtor trans found for given params<br>sql that failed was : SELECT trans.*,ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total,cust.name AS DebtorName, cust.address, cust.curr_code, cust.tax_id, com.memo_, shippers.shipper_name, sales_types.sales_type, sales_types.tax_included, branch.*, cust.discount, tax_groups.name AS tax_group_name, tax_groups.id AS tax_group_id FROM debtor_trans trans
LEFT JOIN comments com ON trans.type=com.type AND trans.trans_no=com.id
LEFT JOIN shippers ON shippers.shipper_id=trans.ship_via,
debtors_master cust, sales_types, cust_branch branch, tax_groups WHERE trans.trans_no=''
AND trans.type='10'
AND trans.debtor_no=cust.debtor_no AND sales_types.id = trans.tpe
AND branch.branch_code = trans.branch_code
AND branch.tax_group_id = tax_groups.id <br><br><br>
I am trying to use the PayPal import module using a csv file from a US account and I am having some issues.
I looked at the columns and they seem to match with the wiki documentation.
First of all when I have the 'Create Customers/Invoices:' checked in the PayPal import setup, the import creates the customer (at least some of them) but fails to create anything else.
The paypal.log shows an error creating the invoice:
[20-Apr-2015 22:39:32] WEB ACCEPT PAYMENT RECEIVED, gross:134, fee:-7.54, net:126.46, shipping:0, tax: 0
[20-Apr-2015 22:39:32] Memory, write_customer_invoices start:8101704
[20-Apr-2015 22:39:32] eCheque missing invoice, customer:4, net:126.46
[20-Apr-2015 22:39:32] Deposit, ref:, net:126.46
This is where the log stops.
Without the 'Create Customers/Invoices:' checked, the import creates entries only for the fees.
It seems to be parsing the entries properly as the paypal.log shows but fails to create the appropriate entries:
[20-Apr-2015 23:02:59] WEB ACCEPT PAYMENT RECEIVED, gross:134, fee:-7.54, net:126.46, shipping:0, tax: 0
[20-Apr-2015 23:02:59] Memory, write_bank_receipt start:8100720
[20-Apr-2015 23:02:59] Deposit, ref:9N743957MK081961F, net:126.46
[20-Apr-2015 23:02:59] Memory, write_bank_receipt end:9706312
Only the entry for 7.54 is created.
Anything that I can do to fix this?
What's the best way to debug this?
TIA
Ion
Hi apmuthu,
I've applied the patch you suggested, still no luck.
My config.php has $go_debug = 0 however the error still shows up.
You're right, the import failed to create entries in the debtor_trans table so that's why when I click the edit button it fails to bring the edit screen up.
In the mean time I have upgraded to FA 2.3.24 and now the window that pops up instead of showing the error shows a blank page! I can only get the error from the error.log file.
What I ended up doing is update the entries in the bank_trans table and changed the person_type_id from 2 to 0 for these transactions.
Ion
Under 'Banking and General Ledger/Journal Inquiry' I have a list of journal entries. For most of the entries, when I select the edit icon a new window opens that allows me to edit the entry.
However, I have a couple of entries for which the windows that comes up shows the following error:
DATABASE ERROR : no debtor trans found for given params
sql that failed was : SELECT trans.*,ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total,cust.name AS DebtorName, cust.address, cust.curr_code, cust.tax_id, com.memo_,bank_act,bank_accounts.bank_name, bank_accounts.bank_account_name, bank_accounts.account_type AS BankTransType, bank_accounts.bank_curr_code, bank_trans.amount as bank_amount FROM debtor_trans trans LEFT JOIN comments com ON trans.type=com.type AND trans.trans_no=com.id LEFT JOIN shippers ON shippers.shipper_id=trans.ship_via, debtors_master cust, bank_trans, bank_accounts WHERE trans.trans_no='360' AND trans.type='2' AND trans.debtor_no=cust.debtor_no AND bank_trans.trans_no ='360' AND bank_trans.type=2 AND bank_trans.amount != 0 AND bank_accounts.id=bank_trans.bank_act
I checked the debtor_trans table and it's empty.
Any suggestion on how to fix this?
At least one of the transactions was entered with the import transaction module (I don't know if this makes a difference).
I am using FA 2.3.22.
Any input would be appreciated.
Thanks,
Ion
CR/LF did it for me. I am using a Mac and the lines in the file were terminated by CR.
Import works after I changed the line terminations.
Both Windows termination, CR/LF or Unix termination, LF worked for me.
Thanks for your help.
Ion
I am trying to import journal entries in FA with no luck.
I have installed the module, activated successfully, however whenever I run the import I always receive this error:
Skipped header. (line 1 in import file 'import-test-3.csv')
Error: Debits do not equal credits.
1
I have tried on my installation as well as the UK demo site with the sample file.
Here is the file I have used:
"reference","date","memo","amount","accountcode","taxtype","dim1_ref","dim2_ref","person_type_id (supplier=1 customer=2)","person_id"
"JNL2",02/12/2014,"Rent outstanding",122.25,7100,1,"D1","D2",,
"JNL2",02/12/2014,"Accruals",-122.25,2109,0,"D1","D2",,
Can you share a sample that is working?
Any help would be appreciated.
TIA
Ion
The only php.ini that I have on my machine is in /etc/php.ini and it reads:
session.gc_maxlifetime = 1440
Ion
I am running everything on localhost so there should be no issues with the client address change. My URL is always (http://localhost/frontaccounting).
How can I determine if the server is purging the sessions to aggressively? What parameters are determining the purging of the session? I am aware of 2 right now, login timeout and the client's ip address but those don't explain the current behaviour. How can I debug this? BTW, I am using Apache/2.2.22.
One change I made that seems to help, in the frontaccounting/includes/session.inc, in the regenerateSession() function, I changed:
$_SESSION['EXPIRES'] = time() + 10;
to
$_SESSION['EXPIRES'] = time() + 100;
However, I am not sure if this is a good idea. Obviously it will be overwritten with an upgrade.
Ion
P.S.: If I have the login timeout at 1200 will the session expire after 1200s from login regardless of activity or only after 1200s of inactivity (no HTTP requests to the server)?
I am constantly being redirected to the login screen when I use the application (in less than one minute).
Sometimes the login screen covers the whole page, sometimes the menu and the footer shows up and the login screen is in the middle (seems that each section has it's own session and expiry time).
The login timeout in the setup/company setup menu is set to 1200.
The system is unusable, I can't enter a journal entry: it times out before I manage to save.
Any suggestions?
My environment consists of:
FrontAccounting Version 2.3.16 Build 08.05.2013
PHP Version 5.3.15
Safari Version 6.0.5 (7536.30.1)
Mac OS X Lion 10.7.5 (11G63)
MySQL 5.5.28
I would appreciate any input.
TIA
Ion
Pages 1
FrontAccounting forum → Posts by ion
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.