1

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

I need some help with importing bank transactions (Deposit Processing and Payment Processing).  I was able to get it to work successfully in 2.4.11, and I'm trying again with the same CSV format in 2.4.18.

The import goes through and shows me the journal entries, but when I check the GJ reports none of the transactions are there.  Debug mode shows no errors.

Any idea why the transactions are not getting written?

I have a related issue with importing direct invoice.  After setting up the CSV file and selecting it for Direct Sales Import, nothing happens and there is "no file chosen" against the Choose File button.

Errors.log sometimes shows this error:
3:<user>:session.inc:196: Zend OPcache API is restricted by "restrict_api" configuration directive

Any ideas how to fix? File name has no spaces or special characters, and I'm not comfortable messing with the session.inc file.

I've been able to import bank transactions successfully, so I know the import should work.  Thanks.

Same problem here.  It seems the existing Cashflow Statement extension is mainly a bank balance movement report.  I don't think a proper cashflow as you describe it exists (yet).

4

(3 replies, posted in Setup)

After much wringing of hands I think I found the solution.

In ...gl/manage/gl_accounts.php

Changed line 24:
include($path_to_root . "/admin/db/tags_db.inc");

to:
include_once($path_to_root . "/admin/db/tags_db.inc");

I hope that's the end of my woes.

I noticed that my Chart of Accounts page is missing the action buttons at the bottom of the page (Add New, Update, Cancel, etc). The page is cut short at the Account Tags row.

With debugging on, I get this error:

Cannot redeclare add_tag() (previously declared in ../../admin/db/tags_db.inc:13) in /<my_url>/public/admin/db/tags_db.inc on line 13

I may have messed something up somewhere because it worked fine before.  I also tried a re-install, but no luck.

I would appreciate any pointers.

6

(1 replies, posted in Setup)

I need help reviewing my FA setup.  Some of my company databases are behaving strangely, and I don't have the expertise to dig deep into the problems.

None of the links on this page seem to work:
https://frontaccounting.com/fawiki/index.php?n=Main.Support

If you offer services please post your contacts in case others are interested.

7

(13 replies, posted in Setup)

Slightly unrelated, but I hope I can get an answer on this thread. 

I run multiple companies on FA but recently when I log out and log back in I get sent back to the same company.  I don't get the login window where I can select a different company.

I have tried clearing cookies and also tried different browsers. Eventually I can sign in after some hours.  Any ideas?

8

(5 replies, posted in Setup)

I was missing two tables, and found them based on this thread:
https://frontaccounting.com/punbb/viewtopic.php?id=7241

Below are the steps for anyone with basic knowledge like me.

1. Using phpMyAdmin or similar tool, identify the company prefixes. In this example I want to transfer the data from Company 0 to Company 1.

2. Using the RENAME feature under Operations, move the following tables to different names (delete might work but something could go wrong)
    1_crm_contacts     --> x1_crm_contacts
    1_crm_persons      --> x1_crm_persons
    1_cust_branch       --> x1_cust_branch
    1_debtors_master  --> x1_debtors_master
    1_suppliers            --> x1_suppliers   

3. Use the COPY feature under Operations to bring the data from the original company to the new company:
    0_crm_contacts     --> 1_crm_contacts
    0_crm_persons      --> 1_crm_persons 
    0_cust_branch       --> 1_cust_branch
    0_debtors_master  --> 1_debtors_master
    0_suppliers            --> 1_suppliers

That's it. Company 1 should now have all the contacts from Company 0.

9

(5 replies, posted in Setup)

notrinos wrote:

All contacts for both suppliers and customers are recorded in two tables: crm_contacts and crm_person
If customers, suppliers data are the same in both company then copy the said two tables and modify table prefix will achieve your goal.

@Phuong, thanks for the tips.  I copied the three CRM tables from the old company to the new, but the contacts don't show up when I open the new company in FA.  However, when I run a backup of the new company and select "view backup" I see the tables with the copied details.

What am I missing?  Is there another file or table that needs to be updated?

10

(5 replies, posted in Setup)

I had to create a new company database from an old one due to some inconsistencies in the old database.  Everything stays the same - customers, suppliers, CoA, company info.

I need a simple way to transfer the customer and supplier contacts from the old company to the new one.  I have seen the "Manual Import of Customers" entry in the wiki page, but there seems to be no export option in FA, and I'm not too conversant with SQL.

Can I copy the relevant DB tables and rename the company ID?  Any pointers would be appreciated.

11

(13 replies, posted in Setup)

Understood - thanks!

12

(13 replies, posted in Setup)

Thanks for tracking down the problem.  I could have sworn I didn't select those exemptions in the Tax Type.  I unchecked them and the taxes now appear on the invoices as expected.  However, I'm not sure what I'm supposed to do with the .txt and .sql files.  Please clarify.

13

(13 replies, posted in Setup)

I had a tax group with two tax rates that was working fine (call them Tax1 and Tax2.  I decided to add two other taxes in a new group for another set of customers (tax 3 and tax4).  For some invoices I want tax1 and tax2 together, and for other invoices I want tax3 and tax4 together.

After creating the new tax group I notice that the taxes in the first tax group do not appear at all on invoices.  When I switch to a customer defined with the new group, tax3 and tax4 show up as expected.  I can't get invoices to show tax1 and tax2 which were originally okay.

Please help explain/troubleshoot.  Thanks.

14

(14 replies, posted in Setup)

Thanks for looking into this issue.  I tried the suggestion above but FA still rounds to 2dp. 

I changed the dec+2 to dec+4 in the ui_input.inc file, and changed the database x_prices table "price" column to DECIMAL(6,4). The database shows the 4dp but the values are still rounded to 2dp.

Please let me know where I'm going wrong.

15

(14 replies, posted in Setup)

I have this problem too, and would appreciate some help. 

It's odd that we can purchase items with prices to several decimal places but can sell only to two decimals.  I have items that are bought and sold in large volumes for fractions of pennies.

16

(12 replies, posted in Installation)

Thanks, apmuthu.  I was able to access again after renaming the installed_extensions.php for the starter company, and then used the access to deactivate all extensions for the other companies.  I'll go through each extension in turn to find out which one caused the problem.

17

(12 replies, posted in Installation)

tm, thanks for the helpful response.  I checked the *_users theme entries and they were all unchanged from "default" so the problem must be elsewhere.  Is there a way to remove all added themes from the back end, or should I just do a re-install?

18

(12 replies, posted in Installation)

I have a similar problem with blank screen after logging in.  The problem started when I activated some extensions including zen_import and dashboard.  After logging out I get the login window but just a blank screen after entering my login info. I get the normal error page if I enter the wrong credentials.

I am running FA ver. 2.3.20 with php 5.3.28.  I also tried setting the $go_debug=1 in the config file, but I still get the blank page.

Any help or pointers? Thanks.

Thanks, kvv.  I got the same problem from different computers, even browsers that were accessing the database for the first time.  Now just as suddenly the system can be accessed again.  I don't know why I lost access, and I don't know why it came back.

I've been using FA for some months now with no problems.  I have several companies set up.

Now I cannot get past the login window when I try to enter FA.  The login fields appear correctly, but regardless of what I enter I get the following error message:

     The requested URL was rejected. Please consult with your administrator.
     Your support ID is: 11584518327585520200 (or some other random number)

Is this a database issue?  How can I resolve it?  Any pointers would be appreciated.

Thanks for your feedback.  I created a new company and renamed the directory and everything is working fine now.

I have FA set up with four companies installed.  When trying to install new extensions I get the following error message:

Cannot open the extension setup file '../company/2/installed_extensions.php' for writing.

I checked in the FA directory and indeed there is no directory "2" in the Company folder.  I have directories 0, 1, 3, and 4.  Directory 2 was probably created and deleted when I removed a trial company.

Is there a way to resolve this error?  It won't let me make changes to one of the companies either, so FA may be looking for its reference in a non-existent directory.

Thanks