We are using 2 databases for different branches.
When we login to Company A, the GL panel shows records from Company B!!
and it's logout for no reason. Very Strange!
1 10/04/2017 01:12:31 pm
Re: front accounting database corruption? (6 replies, posted in Jobs wanted/offered, non-free offers)
2 10/03/2017 09:40:06 pm
Topic: front accounting database corruption? (6 replies, posted in Jobs wanted/offered, non-free offers)
Hi Guys,
Recently our front accounting has been switching between different users under single login!
Restored the database to an earlier (30 days) backup but no use.
I don't know if it's being effected long time ago or it's a database problem at all...
Please help.
Thank you
Eric
3 12/30/2016 04:59:24 pm
Re: Page numbering on sales invoice PDF's (12 replies, posted in Accounts Receivable)
Hi Guys,
How do we display page number like "page 1 of 3"?
What's name of the function to be called? Is the following syntax correct?
$this->Text($mcol + 180, _("Page") . ' ' . $this->pageNumber . _(" of ") . $this->totalPageNumber);
Thank you for your time.
Eric
4 12/29/2016 09:29:33 pm
Topic: Add massive Terms and Conditions for quote and sales order (1 replies, posted in Jobs wanted/offered, non-free offers)
Hi,
We'd like to hire a programmer to add "Terms and Conditions" in the end of our quote and sales order, preferably read the content from a standalone formatted file instead of hard coded in to the "inc" or "php".
also needed:
** page number on each page in form of "Page 1 of 2"
** signature field under the "terms and conditions"
Please PM us a proposal.
Thank you.
Eric
5 12/02/2015 03:08:57 pm
Topic: user account (1 replies, posted in Reporting)
Hi All,
Is there any way to find out which user input a specific sales order?
Thank you
Eric
6 11/30/2015 01:41:45 pm
Re: tax credit (3 replies, posted in Accounts Receivable)
I checked old posts, erwindebruin provided a good solution.
https://frontaccounting.com/punbb/viewtopic.php?pid=18816#p18816
What a shame I didn't follow then.
7 11/13/2015 08:34:43 pm
Re: tax credit (3 replies, posted in Accounts Receivable)
When the current quarter ends, how do we find out the amount of tax credit for the last quarter or the one before that?
Do we make notes for each occurrence?
8 11/11/2015 08:04:03 pm
Topic: tax credit (3 replies, posted in Accounts Receivable)
Hi all,
We are paying sales tax base on invoice (not cash basis).
some late payment collected are not in full amount and we have to credit the sales tax for the difference.
What's the proper way to record this?
for example
sales invoice $10000 + $1000 tax
tax paid to government: $1000
payment collected: $8800
tax credit: $200 <---we'd like to properly record this
Thank you
Eric
9 04/30/2015 07:38:40 pm
Re: attached payment, return and other term page (4 replies, posted in Accounts Receivable)
apmuthu wrote:
The devs would need to code it into FA 2.4 before it becomes available.
Understand. I'll just attach it as separate file for now.
Thank you
Eric
10 04/29/2015 09:37:38 pm
Re: attached payment, return and other term page (4 replies, posted in Accounts Receivable)
Let's wait for 2.4 then.
Thank you
Eric
11 04/28/2015 10:09:26 pm
Topic: attached payment, return and other term page (4 replies, posted in Accounts Receivable)
Hi all,
Is there any way to attach a payment, return and other policy term page after our sales order in one pdf file and page marked.
Thank you.
Eric
12 12/27/2014 09:18:05 pm
Re: create a new company (9 replies, posted in Installation)
I installed FA again. This time works!
Have no idea what's the problem...
Thank you for your time and happy new year everyone.
Eric
13 12/27/2014 06:07:27 pm
Re: create a new company (9 replies, posted in Installation)
report PMed.
apmuthu wrote:
What is your webroot. That will determine the path of the tmp folder which should be just below it. You will need to run some tests on your hosting environment with a phpinfo() report as well.
14 12/27/2014 03:35:10 pm
Re: create a new company (9 replies, posted in Installation)
Hi apmuthu,
Please see comments below.
apmuthu wrote:
It appears that your webserver process does not have the right to create files/folders in the webroot. This will affect your ability to create PDFs as well.
I can generate pdf files without any problem.
Create a file faillog.php in your FA webroot's tmp folder and let the webserver user have write access to it (may not be applicable to some Microsoft pre Win7 and non server OSes).
I'm using a shared Linux hosting server from godaddy.
the faillog.php exists in ~/faccount/tmp/
should I move it to root ~/tmp/ ?Wonder why "../company//js_cache" is coming up instead of "../company/0/js_cache" or some such company number in it.
any way to correct this?
Please check your config_db.php file to see if the subscripts of the db credentials array match. It is possible that your new company 1 did not get it's credentials written inside it.
checked: config_db.php has correct db credentials.
@joe: please include
faillog.php
error.log
cookie.txt
files as placeholders with dummy content in the repo to avoid such missives.
Thank you
Eric
15 12/26/2014 10:07:36 pm
Re: create a new company (9 replies, posted in Installation)
Hi apmuthu,
same problem still exsits after I clean installed the FA and restored database.
here's the error.log
[26-Dec-2014 09:00:40 America/Phoenix] 0::session.inc:401: include_once(./tmp/faillog.php) [<a href='function.include-once'>function.include-once</a>]: failed to open stream: No such file or directory
[26-Dec-2014 09:00:40 America/Phoenix] 0::session.inc:401: include_once() [<a href='function.include'>function.include</a>]: Failed opening './tmp/faillog.php' for inclusion (include_path='.:/usr/local/php5_3/lib/php')
[26-Dec-2014 09:05:06 America/Phoenix] 0::session.inc:401: include_once(./tmp/faillog.php) [<a href='function.include-once'>function.include-once</a>]: failed to open stream: No such file or directory
[26-Dec-2014 09:05:06 America/Phoenix] 0::session.inc:401: include_once() [<a href='function.include'>function.include</a>]: Failed opening './tmp/faillog.php' for inclusion (include_path='.:/usr/local/php5_3/lib/php')
[26-Dec-2014 09:15:43 America/Phoenix] 0::session.inc:401: include_once(./tmp/faillog.php) [<a href='function.include-once'>function.include-once</a>]: failed to open stream: No such file or directory
[26-Dec-2014 09:15:43 America/Phoenix] 0::session.inc:401: include_once() [<a href='function.include'>function.include</a>]: Failed opening './tmp/faillog.php' for inclusion (include_path='.:/usr/local/php5_3/lib/php')
[26-Dec-2014 09:15:54 America/Phoenix] 0::session.inc:401: include_once(./tmp/faillog.php) [<a href='function.include-once'>function.include-once</a>]: failed to open stream: No such file or directory
[26-Dec-2014 09:15:54 America/Phoenix] 0::session.inc:401: include_once() [<a href='function.include'>function.include</a>]: Failed opening './tmp/faillog.php' for inclusion (include_path='.:/usr/local/php5_3/lib/php')
[26-Dec-2014 09:24:48 America/Phoenix] ::current_user.inc:651: opendir(../company//js_cache) [<a href='function.opendir'>function.opendir</a>]: failed to open dir: No such file or directory
Thank you
Eric
16 12/24/2014 03:56:19 pm
Topic: Virus detected (1 replies, posted in Reporting)
Hi,
avg detected 3 infected file in my frontaccounting backup, they are
"";"Virus identified PHP/Agent.4, faccount\purchasing\includes\infobeB4.php";"Infected"
"";"Virus identified PHP/Agent.4, faccount\modules\import_items\cookielJy3.php";"Infected"
"";"Virus identified PHP/Agent.4, faccount\inventory\includes\infokO04.php";"Infected"
Can I just delete/overwrite them?
Than you
Eric
17 12/24/2014 03:06:41 pm
Topic: create a new company (9 replies, posted in Installation)
Hi all,
I was trying creating a new company.
After I logged in company 0 as admin, went to setup->Create/Update Companies, clicked "Create a new company",
nothing shows up!
What did I miss? Please help.
Thank you.
Eric
18 12/23/2014 05:59:42 pm
Re: Backup and Restore Database (8 replies, posted in Setup)
Someone sent me this command script
mysqldump --host="hostingAddress" --user="databaseUserName" --password="databasePassword" "databaseName" | gzip > "~/frontaccounting_$(date +%Y%m%d).sql.gzip"
I used it in crontab, it works great.
Thank you for your help.
Eric
19 12/20/2014 08:10:59 pm
Re: Backup and Restore Database (8 replies, posted in Setup)
Hi apmuthu,
Thank you for your input, I think I'm better of hiring someone knows what he's doing.
Marry Christmas!
Eric
apmuthu wrote:
List what permissions your DB User has for the specific FA DB.
Provide versions of PHP, MySQL and Apache used and what platform / OS your server is on (Windows, Linux, etc)?
What is the file ownerships and permissions of the folders / files in the webroot and what is your webserver user:group?
Apache error logs will be based on your apache conf file used - check in /var/log/apache2/error*log or /var/log/httpd/error*log in Linux. PHP Errors in FA are generally found in tmp/ folder under the webroot.
20 11/22/2014 09:39:39 pm
Re: Backup and Restore Database (8 replies, posted in Setup)
apmuthu wrote:
check file and folder permissions and db user permissions.
The permissions are fine.
Is there a error log we can check?
21 11/18/2014 07:39:44 pm
Re: Backup and Restore Database (8 replies, posted in Setup)
Yup, No backup generated in the directory.
That's not good...
22 11/15/2014 09:25:50 pm
Re: Backup and Restore Database (8 replies, posted in Setup)
dz wrote:
What error it shows?
The progress bar runs for a while and stops with no new sql file appears in the right script window.
Where's the backup sql file save anyway?
23 07/22/2014 03:43:04 pm
Topic: need help (1 replies, posted in Jobs wanted/offered, non-free offers)
Hi,
We can't access bank statement, generate invoice this morning.
We'd like to hire someone has extensive knowledge of php, mysql and function of FA to fix this problem.
please PM us.
Thank you
Eric
24 04/19/2014 04:55:04 pm
Topic: Backup and Restore Database (8 replies, posted in Setup)
Hi all,
I can't create backup from"Backup and Restore Database" page recently. It worked fine last time!
Please help.
Thank you.
Eric
25 01/16/2014 04:27:07 pm
Re: void a transaction error (4 replies, posted in Installation)
I'll give a try.
Thank you very much.
Eric
apmuthu wrote:
Why don't you try the latest codebase from the mercurial repo or just use the difference file set to overwrite the v2.3.19 files?
Attached is the changed fileset after v2.3.19 was released.
Only one sql command needs to be executed on the existing db (change 0_ to whatever your company # is):
ALTER TABLE `0_debtor_trans` ADD INDEX `Order` (`order_`);