Skip to forum content
FrontAccounting forum
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 2 of 4)
apmuthu, for most countries as far as I know check issue is very important. Beside that FA is very fantastic web based app for accounting but lack of this section disallow most people to use this.
We worked a lot with our teams, hence we found another solution to simplify it. Here is the solution we found:
1. Adding another "date" input in "Payment Entry(ies)", also as you mentioned we can add, other check information in "Memo" section.
2. Now, for checks look up solution, if we add 2 "Date input text" in "Journal Inquiry" with start and end date this will solve everything because there is a nice "Memo" search option that helps a lot to find check number or anything else.
Please give us a applicable solution 
can you just tell me which tables are affected these sub systems "Customers , Suppliers and all defined Items and Inventories"
Well, the only extension is Dashboard theme and Dashboard add-on's.
In here suppose we are immigrating between same versions (2.3.22).
We have 2 reason for that:
Some of my FA users after working with FA for 1 year (less or more), they learn how to interact with FA. Then they ask me to make the FA null, means that to erase what ever purchase, sales and GL documents are in. They want to start from beginning. Add or do changes on GL accounts, classes and groups.
I afraid to do that 
Hi
I am planning to move from full data FA to the new raw FA, and I don't want to rewrite basic information again like "Customers , Suppliers and all defined Items and Inventories".
here are:
1. Which tables should replace with existence raw tables in new FA?
2. What problems may arise if I do that?
Well 1 most important things missing here:
I can't get a report from date to date: for example getting a report of those checks will going to be cash from date X to date Y.
regardless of US, handling checks in our country is very important subject. In fact every software in accounting field must have this option. Regrettably we suffer a lot due to lack of these feature in FA.
For handling "Checks" in FA we made 2 accounts, "Received Checks" & "Paid Checked". Consider if we receive a check today but the date of cash is for 2 month later we enter it in a "Received Checks" account and hold the cash date in Excel and the time this check converted to cash we transfer that amount from "Received Checks" to "Cash Accounts" or what ever accounts belongs to.
In my opinion if legend FA developers add a filed in payment terms then the time we choose the payment terms in Direct Invoice our form add some extra fields to mentioned page and this will solve most of check problems.
Sorry about the screen shots if I made it badly, this is the only things I can do it for FA.
I, exactly aware of the mentioned reports and thanks for explaining in detail.
As I said before for the sake of simplifying reports (since users have problem with reading mentioned reports) I need to do this. Since working with DB would be very easy task for you, I'd appreciate if you could write us some script to do that.
According my experience as a FA advanced user, this type of reports make ease of reading. In many intermediate and advance accounting apps there are powerful report generators which FA surfer from that.
some of my FA users are not familiar with accounting terms to go in details and read reports.
I need to create 4 types of reports via report generator but regrettably I am not experienced with FA DB.
According users feedback they need very simple report consist of:
1. Sales
1.1 A report that shows customers debts to company: fields: Customer Name, total amounts of each customer dept(total debts at bottom of list)
1.2 A report that shows company debts to customers: fields: Customer Name, total amounts of each customer owes (total owes at bottom of list)
2. Purchase
2.1 A report that shows company debts to suppliers: fields: suppliers name, total amounts of each suppliers dept(total debts at bottom of list)
2.2 A report that shows suppliers debts to company: fields: suppliers Name, total amounts of each suppliers owes (total owes at bottom of list)
with these 4 MySQL script I can fulfill their needs.
apmuthu, thanks for your patience and precise answers
Thanks again, I think our ISP - IP's band via FA repository server.
If I pick up whole repository source and put it in my own server, which part of source code must be changed in FA source? since I am not good in programming please let me know in detail. I found repository address in "Version.php" file.
BTW, suppose our server is not connected to Internet at all, if anyone wanted to install a module or language manually wont be able to do that. ;|
dear apmuthu with your kind helps I learned a lot, thanks a ton. Most questions handled via accessing main source of FA in GitHub.
since I can't access "Install/Update Languages" sub system, I can't compile those "po & mo" files to get php file. if I find a way to compile those files to get a php file most problems will solved currently.
even i disconnect from internet to work offline in XAMP server but didn't get any feedback
Here is what my tmp directory is look like:
errors.log
[15-Jan-2015 19:49:01 UTC] 0:admin:remote_url.inc:48: fsockopen(): unable to connect to repo.frontaccounting.eu:80 (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
)
[15-Jan-2015 19:49:39 UTC] 0:admin:remote_url.inc:48: fsockopen(): unable to connect to repo.frontaccounting.eu:80 (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
)
[15-Jan-2015 19:50:16 UTC] 0:admin:remote_url.inc:48: fsockopen(): unable to connect to repo.frontaccounting.eu:80 (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
)
[15-Jan-2015 19:51:19 UTC] 0:admin:remote_url.inc:48: fsockopen(): unable to connect to repo.frontaccounting.eu:80 (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
)
[15-Jan-2015 19:52:51 UTC] 0:admin:remote_url.inc:48: fsockopen(): unable to connect to repo.frontaccounting.eu:80 (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
)
[15-Jan-2015 19:55:31 UTC] 0:admin:remote_url.inc:48: fsockopen(): unable to connect to repo.frontaccounting.eu:80 (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
)
faillog.php
<?php
/*
Login attempts info.
*/
$login_faillog = array (
0 =>
array (
'127.0.0.1' => 0,
'last' => '',
),
1 =>
array (
'::1' => 0,
'last' => '',
),
);
index.php
<?php
header("Location: ../index.php");
?>
still not working
reminding that all "sub systems" except those mentioned above working well. Even for the sake of assurance I checked out with raw FA 22 and dedicated PC installed new windows with XAMP.
so wired, isn't it!
Maybe it is silly question but as far as I can’t access on theme, language and modules, where can I download manually the latest available directly!
it didn't work!
Let me make my issue simpler
I have installed FA in a brand new windows 7 with XAMP Server. Whenever I go through one of bellow sub systems in FA, I come across with blank page.
Install/Update Languages
Install/Activate Extensions
Install/Activate Themes
Install/Activate Chart of Accounts
So, consider any of PO files in repository, I pick up one to install in FA manually. As far as I encounter with a blank page how can I go for installation?
For you information I installed another windows in new PC with WAMP Server (instead of XAMP) and again this problem happened. This issue occurred recently, because previously never saw such an issues.
Dear apmuthu
Thanks for your prompt reply and introducing FA rep at GitHub
When log into FA within XAMP virtual server can't access mentioned sub systems. For the sake of assurance I installed brand new windows and also put raw FA in WAMP and EasyPHP too but didn't work.
Maybe my question is a dump one but can you let me know how could I download source from GitHub? I Googled and find there is a ZIP bottom below right window but didn't find it.
Dearest Administrators and developers
Hello
As for localization and customization we use XAMP / WAMP to have test before putting in live environment.
Recently we got a problem, we can’t have access below “sub systems” in “setup” section. The only way we have to put under domain & host to have access on it.
Install/Update Languages
Install/Activate Extensions
Install/Activate Themes
Install/Activate Chart of Accounts
For 2 years we couldn’t upload “PO” & “MO” files to our Linux servers and the only remaining way for us to install XAMP or WAMP on windows OS and install localized language there and then pick up the compiled “php” translation file from XAMP to our Linux servers.
Now, by blocking our access to mentioned setup options our operation limited.
Please give us your best direction to solve this issue or suggest a solution to at least compile “PO” & “MO” files for generating a “php” file.
Thank you dear joe
It is understood, sometimes tracing accountant usage is very hard for technical person who has less accounting knowledge.
Every thing was fine there!
I am looking for a way to email you my database.
Could you plz give me your email address, I can't attach it via forum!
Dear joe
Thank you so much for your kind helps, ALWAYS
In our chart of accounts, we had an account with the code of [14001] which it is inside the class of “Receivables”. We used to use it via “Deposits” to balance customer and receivables accounts.
Nowadays we cannot see anymore, but whenever we go through “Journal Inquiry” we can see there and even we can enter data within it without any problem.
Our problem is, what happened? Why we can’t access to the account via “Deposits” section? Also I double checked that account is Active!
I have been working with FA for more than 2 years. It cost us a lot to customize and work on it. Almost for about two years we are putting all the accounting needs with FA. Nowadays we come across with a much wired phenomena.
Here is what happened to us:
Consider you can see [4010 - Sales] account in “Trial Balance” page but this account hidden when you are willing to use it in “Deposits” section. Since our language and numbers in other than English format I couldn’t post pictures to demonstrate very clearly.
Please help us!
Posts found: 26 to 50 of 91
