@apmuthu his point is different. He says, is there a way to warn or stop adding those entries wrong.
501 04/29/2020 08:03:49 pm
Re: Debit Credit Error on Trial Balance (18 replies, posted in Report Bugs here)
502 04/29/2020 08:01:45 pm
Re: Additional Fields Extension (52 replies, posted in Modules Add-on's)
Yes. But for more customization get only one value from that minified string. We have to decode all the custom fields. May be a choice to do that.suppose if we have to bring hsn code for items. And we have to take tax reports based on hsn code. It might be complex to get and process the results.
503 04/29/2020 03:04:03 pm
Re: TAX BY ITEM LINE (15 replies, posted in Setup)
Looks like you didn't understand the tax concept of FA. FA has customer based tax as well as item based. So it supports what you want. Let's say when an item is taxable and non taxable (exempt). That's applied on the time of item selection in cart. So try it with different set of items with its item taxes and exempted. So it will opt you the need.
504 04/29/2020 02:53:45 pm
Re: ACCOUNT CODE ID (3 replies, posted in Misc. Charts of Accounts)
Great once you done it for one company you can use it for every other company. Simply reuse the customized chart of account for new companies.
505 04/29/2020 02:23:19 pm
Re: Additional Fields Extension (52 replies, posted in Modules Add-on's)
We have to add two tables for custom fields. One for the field definition and another one to store data of custom fields.
Actually I am thinking to extend this to sales invoice and purchase invoice.
@poncho1234 - we have to focus on next major release. I can understand. Let's try to contribute something to next release.
@Joe users are eagerly waiting for the next major update. So let's focus on it.
506 04/28/2020 05:59:28 pm
Re: Additional Fields Extension (52 replies, posted in Modules Add-on's)
This program we wrote it for 2.5 it's not for 2.4 those who wish to customize the core they can give it a try with this module. Other than that this code will be used inside 2.5 the next major update.
507 04/28/2020 12:40:19 pm
Re: Additional Fields Extension (52 replies, posted in Modules Add-on's)
@poncho1234, What i tried to explain you is to get the custom fields inside the respective pages. Usually its hard to remember and work in separate page for the custom fields. So we have to put the custom fields within the existing page itself. Here i have created a demo for understanding it.
Kvcodes Demo for Custom Fields
Username : custom
Password : 123456
This is my very initial version. We will enhance and develop it to bring more possible custom fields to custom pages. Looking for users and developers feedback to enhance it better.
508 04/27/2020 12:42:39 am
Re: ACCOUNT CODE ID (3 replies, posted in Misc. Charts of Accounts)
It's a bit typical for non technical person. Let me answer you, and you can try to make changes In it.
The GL account codes are initially stored in chart_master table. From there we used to make GL and journal entries. That will store in gl_trans table. And then it can be connected with bank accounts in bank_accounts table. If any GL settings connected to that GL account it must be in sys_prefs table. And if you made supplier invoices with GL accounts, you need to look in supp_trans table. The same way with customer deposits and supplier payments through journal entry. It will also hit the gl_trans table. So take it seriously and check it those tables to find and replace the gl account code manually with help of MySql client like phpmyadmin or workbench. May be If i miss any table add further comment. So someone will get benefited in future by accessing this post.
Good luck.
509 04/27/2020 12:32:28 am
Re: FA for Services Company (2 replies, posted in Setup)
Since you have stated you process the hospital medical bills. Is it like supplier bills.?
And are you working as medical intermediate who works in between hospitals and insurance company to apply for the claims with covering expenses and get insurance claims for the customers.
I guess you might be in Tamil nadu. If so explain me the process of hospital bills. Let me help you to understand it better.
510 04/24/2020 10:50:29 am
Re: install issue on my web server (7 replies, posted in Installation)
Perfect and thanks for writing it here. So in future people will get it sorted by themselves.
511 04/24/2020 09:52:40 am
Re: Wrong path on reports, Error 404 (2 replies, posted in Report Bugs here)
It's simply the pdf file path. So check in the end() function inside pdf_report.inc to give path for the file. And also company_path function you need to check it. We have not faced such an issue. Simply giving you the way to figureout a solution. The returned file url is wrong. So the path is the only problem not the permission of files or permission of user
512 04/24/2020 07:51:16 am
Re: install issue on my web server (7 replies, posted in Installation)
The issue he initiated is different than your issue. The session failure is php library missing issue from the hosting provider. Your issue is connected with MySql server port number. Sometimes the MySql server needs to connect it with its port number. Usually the default port no is 3306. But some servers the port no might be configure with another available port.
Here your problem is the port no, you have to get right port no to connect the MySql server. And also don't forget to check the MySql server credentials.
Update
Looks like your MySql server is down or port no changed.
513 04/18/2020 04:44:33 am
Re: Create or Update company (11 replies, posted in Setup)
I have updated my tutorial to understand better. How To Create A New Company In Frontaccounting. There you can see the way to create it.
514 04/18/2020 04:06:56 am
Re: Need Salesman wise report (25 replies, posted in Reporting)
Not hard as you think. Understand the concept. Every transactions entry, we have to record the salesman id in both sales order and debtor trans tables to retrieve them back while making report. By logical we need to alter the table and add column for salesman. And than while making sales invoices, record the salesman id in that column. With that you can make custom report to get the salesman wise reports.
515 04/18/2020 04:03:47 am
Re: Allow Petty Cash Account To Go Negative? (7 replies, posted in Banking and General Ledger)
If you make more payments from petty cash account. It would go negative. Or you make all expenses from petty cash account. It would go negative. I guess there is no limit to keep the petty cash only positive
516 04/14/2020 02:36:00 pm
Re: Be aware of scammer (7 replies, posted in Jobs wanted/offered, non-free offers)
For minior changes and a feature which is useful to the core and developer thinks to give it free. There is no problem. But this one he promised to pay and cheat developers. It's necessary to inform other developers to save from evil minded clients. We definitely encourage the other clients and their requests for free or paid. If developer and client agrees to make it work absolutely it's good. But For bad developers and bad clients should be reported to prevent abuse from the other good people in the community.
517 04/13/2020 04:23:43 pm
Re: Be aware of scammer (7 replies, posted in Jobs wanted/offered, non-free offers)
@apmuthu, he is not writing to dispute the losses that he incur with him. He is trying to create awareness to other developers that they shouldnt affect in future. And the forum is not only discuss about the existing features and bugs. It also talks about jobs. So it's good to make the other developers to know a wrong person. If an user mind to talk to the developer because of this post means he is also a scammer. Such an user is not necessary for developers like him.
An user post more than 50 posts or topics he can be senior member. That doesn't mean he is a loyal. He may be stealing the work of developers not the forum. A forum should help to protect the developers and users. This way the users and developers feel secure to start using FA as their software. We should encourage both developers and users. A community truely provides good platform for the developers, definitely it will grow well.
518 04/13/2020 06:10:13 am
Re: FA keeps login out (2 replies, posted in Installation)
I think you are trying to access it from your mobile or mobile internet based devices.
It occurs because these devices won't keep the ip address which keep getting changed and not match with previous session.
Try this
Open /includes/sessions.inc:
Find preventHijacking function with it. Comment the second if statement like this.
//if ($_SESSION['IPaddress'] != $_SERVER['REMOTE_ADDR'])
// return false;519 03/28/2020 03:16:26 am
Re: Create or Update company (11 replies, posted in Setup)
Just goto Setup->Create/Update Companies. There you can able to create new companies. Whether you can create new company in same database or in new database .
520 03/25/2020 03:35:52 pm
Re: The Header option from module itself (19 replies, posted in Modules Add-on's)
@Joe I tired in another way. From config.php we will save the default theme in a constant and then from sessions.inc we will check whether the theme login.php exist or not. If it exist, we can require that file. Otherwise it will require the access/login.php. it's good alternative i feel. And you can try yourself whether it works or not.
521 03/25/2020 02:45:00 pm
Re: The Header option from module itself (19 replies, posted in Modules Add-on's)
There is no need to create new functionality for handling functions from modules. The existing program already checks the modules directory like this
/modules/module_name/reporting/repXXX.php and if anything is there and it was linked in reports_custom.php. that will be replacing with existing core reports.
With that it's good to change the rep files. And regarding the headers also it's connecting from modules directory and works properly.
Hope nothing to research more about it.
Actually I was trying to make few things.
*login files from themes directory
*hooks for custom fields in different area
*smtp for emails
* nicedit for textareas with on and off option
* bring salesman column in sales orders and debtor trans tables and alter queries to work on
* my batch functionality which I have done already.
And I will make an unofficial version for users to get it.
522 03/25/2020 02:33:21 am
Re: The Header option from module itself (19 replies, posted in Modules Add-on's)
@apmuthu, we created separate header file for each templates and made some changes inside the rep107, rep111, rep109 as well. and also all of these files we put it inside our module to take up here. Nothing touched in the core.
523 03/25/2020 02:07:57 am
Re: FrontAccounting Users (3 replies, posted in Jobs wanted/offered, non-free offers)
That's right. but he wants to speak with the users.
524 03/25/2020 02:06:12 am
Re: manage sizes and colours (4 replies, posted in Items and Inventory)
You are right, without FA core support, this extension cant fullfil the client needs. The core has to be adjusted to take fields into the system to make it work from the existing function itself.
525 03/24/2020 07:42:06 am
Re: FrontAccounting Users (3 replies, posted in Jobs wanted/offered, non-free offers)
So far I have seen, very less clients are active in FA forum. Most of them here are developers and service providers who sell service to others.
And very less people are active here. May be your can contact the service providers of FA and speak with them.