Hi. It should show under Banking Reports.
26 10/07/2016 09:04:50 pm
Re: Cash Flow Report Extension (2 replies, posted in Banking and General Ledger)
27 10/07/2016 12:16:33 am
Re: prices (7 replies, posted in Items and Inventory)
Locking the price textbox is implemented here, but not in a clean FA way.
/includes/ui/ui_input.inc
Modified functions in order to account for an additional variable to lock the price textbox.
function amount_cells
function amount_cells_ex
/includes/ui/ui_lists.inc
Modified to disallow users to change the payment terms
function sale_payment_list
/sales/includes/ui/sales_credit_ui.inc
added line 287 to lock price textbox on credit notes
/sales/includes/ui/sales_order_ui.inc
added line 539 to lock price textbox on sales invoices and quotations
This is not at all a standard FA modification, but it does the job for me at the moment, while I/we find time to implement it cleanly. A good clean modification should disallow the salesman from the FA access menu, in a standard manner.
The files on the attached zip FA-LockCells.zip contain the modifications.
You may try on a test environment unzipping on the FA root folder and see if it fits your need.
These files attached here are for a v2.3.25 setup. I have done the same for v2.4rc.
This is a snapshot of the sales quotation form once implemented.
28 09/30/2016 11:52:44 pm
Re: Taxes not appearing on invoices (13 replies, posted in Setup)
I am happy it helped. There is a very nice Wiki about taxes here
Rgds.
29 09/30/2016 07:05:49 am
Re: Taxes not appearing on invoices (13 replies, posted in Setup)
@alanmc,
The selected customer branch must also be GST.
Then you attempt to test by creating a sales quotation
Add the item to the quotation
Here you would see that changing the price list from Retail to Wholesale shows different taxes on the invoice, included and excluded.
It works for me on all my many setups, unless there is a bug in some of the versions that I do not know about.
Maybe you would share a zip of your FA files, and exported .sql database, might help to understand.
I am using v2.4rc
Rgds.
30 09/29/2016 11:16:45 am
Re: Taxes not appearing on invoices (13 replies, posted in Setup)
@alanmc:
Your issue could be coming from the tax_group, if you have not included the item tax into the taxable group(s).
See if my steps below might help:
Define your taxes first>>> Tab SETUP--> TAX_TYPES
Each tax_type with one ledger account
Define your tax groups>>> SETUP --> TAX_GROUPS
In my case I have Tax and Tax_Exempt.
Make sure of the tax_type that will be included in each tax_group where it says "Select the taxes that are included in this group".
Define your Item tax types>>> SETUP --> ITEM_TAX_TYPES
In My case I have Regular(15%), Services(6.25%) and Exempt.
Make sure each Item_tax_type is related to its corresponding Tax_Type.
Go to your item, tab ITEMS_AND_INVENTORIES --> ITEMS
Select your item and make sure you have included the correct Item_tax_type for the item.
Then go to tab SALES and down in Maintenance, select SALES_TYPES
Make sure you tick tax_included on the Sale_Type you want tax included, and untick it if you want it excluded.
You would see that when you attempt to create a quotation or invoice, changing from Retail to Wholesale (or however you have named your sales_types) the taxes would be included or excluded immediately on the invoice.
You may give a look to the SETUP Wiki to read extensively on the taxes at the SETUP tab.
31 09/23/2016 02:53:28 am
Re: Release 2.3 - Creating Extensions and Modules. How to? (16 replies, posted in Modules Add-on's)
Hi @GoodNewShar:
Go to setup tab, Access Roles, select the role you want, and enable the desired extension features for that role (i.e. System Administrator). Then logout, login again and you should see the menu item(s) that you have enabled for that role.
32 09/18/2016 10:00:10 pm
Re: Cannot add new journal entry (19 replies, posted in Report Bugs here)
Check on the config.php file (frontaccounting root folder) and enable debug options to understand where your error could be coming from.
33 09/14/2016 05:09:28 pm
Topic: Providing fix for Import Multiple Journal Entries module in v2.4rc1 (6 replies, posted in Modules Add-on's)
Hi BB'ers,
I tried running the Import Multiple Journal Entries module on v2.4rc1.
It just wouldn't show anything after importing.
By enabling debug mode on the module file, I could see a php error on line 163, the module was using the function exists in /include/references.inc, which is now deprecated in v2.4rc1.
Error: Call to undefined method references::exists() in /var/www/html/fa24/modules/import_multijournalentries/import_multijournalentries.php on line 163
I have changed the code line to use the new function is_new_reference, in the new /include/references.inc file.
So this is the change to apply in order to get it running:
On line 163, file /modules/import_multijournalentries/import_multijournalentries.php, remove line:
if $Refs->exists($type, $reference)) {
And insert this line:
if (!($Refs->is_new_reference($reference,$type))) {
After that, you may import using multiple journal entries module.
I'll report this on Mantis to be updated on future versions of FA.
Rgds.
AL.
34 04/28/2016 03:49:57 pm
Re: Confused Newbie on FrontAccounting Usability (1 replies, posted in Setup)
From the points you mention, I confirm I have done all of them, except #2,
2. Utilize 1099 Employees to complete work on an hourly scale (Time Tracking and P/L)
I do not quite understand what you mean.
Who does the time tracking? What do the employees do? Who enters data on FA?
If you clarify it, I might be able to help.
35 04/27/2016 02:06:34 pm
Re: Supplier Name creation in Purchases Section (2 replies, posted in Items and Inventory)
For the supplier search to list all suppliers (dropdown list), you have to untick the option search supplier list from the Company setup at Setup-->Company Setup
This is like this for cases where you have too many suppliers and you'd prefer to search for them manually, by selecting the supplier dropdown list, then pressing on space bar and entering the supplier name.
**About how to make the supplier name unique, probably you have to access your database and make the field unique. Not sure if we have included an option to do it from within the application, someone else might be able to confirm.
36 10/31/2015 11:55:43 am
Re: Errors in new install of FrontAccounting - wrong Webroot Path (10 replies, posted in Installation)
I posted earlier and deleted thinking I was off topic. I am posting again, see if it helps.
Before the installation wizard
After decompressing the files to the frontaccounting installation folder, run the following commands:
(change /var/www/html/frontaccounting to your FrontAccounting installation path)
sudo chown -R www-data:www-data /var/www/html/frontaccounting
Then run the installation wizard and get yourself setup
After the installation wizard, run the following, to revoke user www-data write access to the config files
sudo chown root:root /var/www/html/frontaccounting/config.php
sudo chown root:root /var/www/html/frontaccounting/config_db.php
Typical config.php modifications after installation:
-timezone
-show users online
-login max 3 times (brute force prevention)
Check security on the diagnostics link in FrontAccounting to confirm it is good to go.
37 10/22/2015 04:18:02 pm
Re: Annual Balance Breakdown Report -- Net Asset calculation (9 replies, posted in Report Bugs here)
Original line:
$rep->AmountCol2($i, $i + 1, $sales[$i] * -1, $dec, 0, 4, 0, $fill, NULL, 1, true);
To fix, we changed to:
$rep->AmountCol2($i, $i + 1, $sales[$i], $dec, 0, 4, 0, $fill, NULL, 1, true);
38 10/20/2015 09:53:35 pm
Re: Annual Balance Breakdown Report -- Net Asset calculation (9 replies, posted in Report Bugs here)
TM,
yeb, that did the trick. Issue fixed, thanks.
Working fine now.
Will also report it on Mantis.
39 10/19/2015 09:38:50 pm
Topic: Annual Balance Breakdown Report -- Net Asset calculation (9 replies, posted in Report Bugs here)
I reported a bug on Mantis here http://mantis.frontaccounting.com/view.php?id=3347
I could see that the annual balance report extension is miscalculating my Net_Assets as Liabilities - Assets, instead of Assets - Liabilities.
Notice that the errors do not exist when I use the native FrontAccounting Balance report, which does it the right way. But I would like to present the annual breakdown balance report (to show the monthly breakdown).
I've been looking into the code to see if i can invert the calculation and have it right, but it is taking some time. Workaround for now is exporting in Excel and doing the change in there, before printing to PDF.
If anyone has a quick_fix or want to discuss this, I would appreciate.
40 08/10/2015 11:06:04 am
Re: Server lost, can't recover (12 replies, posted in Installation)
I am very sorry to hear this. I use a combination of mysqlautobackup and Owncloud to backup my data.
I hope someone can help you with this.
41 08/08/2015 09:01:19 pm
Re: Dashboard setup not working in FA 2.4 (3 replies, posted in Modules Add-on's)
--------ok, this is not the same case. Something weird with my server, 'cause another parallel installation of v2.3.24 still does the same thing. Sorry for misleading ;-)
42 08/06/2015 08:48:33 pm
Re: Dashboard setup not working in FA 2.4 (3 replies, posted in Modules Add-on's)
Removed, reinstalled again. Now it installed correctly and I get to see the module link, but same as apmuthu, some widgets are blank even though they are properly setup, they are are blank and show no information.
43 08/06/2015 08:37:57 pm
Re: Dashboard setup not working in FA 2.4 (3 replies, posted in Modules Add-on's)
Same thing here. I upgraded my Unbuntu to 14.04 and thus installed FA2.4 and migrated all my data via dump file.
Dashboard theme and extension both install properly, but I lost the dashboard setup link under Setup>>Miscellaneous.
Trying to manually access the module via a straight link (https://myserver/fa/modules/dashboard/dashboard_setup.php), it seems it is not there, I get a 404 error.
Went to check and it is actually not there+++++++++
phadmin@phsvr01:/var/www/html/fa/modules$ ls
asset_register rep_annual_balance_breakdown
_cache rep_annual_expense_breakdown
import_multijournalentries rep_cash_flow_statement
import_transactions rep_inventory_history
index.php rep_statement_reconcile
++++++++++++++++++++++++++++++++++
It's weird though, as the extension installation happens without errors.
44 07/19/2013 01:08:01 am
Re: import (1 replies, posted in Installation)
You may change footer on interface by modifying config.php lines:
// Powered by
$power_by = "FrontAccounting";
$power_url = "https://frontaccounting.com";
But I believe you should check license terms before doing such changes <http://www.gnu.org/licenses/gpl-3.0.html>
45 03/29/2013 10:02:24 am
Re: unable to utilize the' forms setup' module (3 replies, posted in Setup)
I found the immediate cause for this: data in table sys_types does not exist, it is totally empty.
Quick_Solution: I installed FA in another folder and another database, exported its default data from sys_types and reimported that table data to my production installation. Now it works like a charm.
Root cause: ?? I remember that I did play with chart of accounts when I installed it, but I have no idea how it goes to delete the sys_types data.
46 01/11/2013 02:28:45 pm
Topic: how to lock editing item price in quotation/sales_order? (2 replies, posted in Accounts Receivable)
Hi there,
sorry if this has been posted before, but I have been searching for the topic for the past two days, and did not find anything similar.
I do not want the salesman to be able to edit item price when creating any of these:
Sales Quotation Entry
Sales Order Entry
Direct Delivery
Direct Invoice
I really need to disable the textbox containing the item price.
I would leave this to another user through ---> items and inventory | pricing and costs | sales pricing
I would appreciate if anyone could guide me on how to disable this textbox on the sales_order_entry form.
If not an option currently in FA, I would appreciate guidelines on how to do this by code (I'm good in VB, and beginner in PHP).
Thanks in advance.
47 07/22/2011 05:35:42 pm
Topic: unable to utilize the' forms setup' module (3 replies, posted in Setup)
Does anyone know why I cannot work on Form_Setup?
It does not display the textboxes to setup form numbers, it just shows the title [Forms Setup], the table headers [Form][Next Reference], the button [Update] and the link [Back].
A while ago, I migrated from v2.3.3 to version 2.3.4 and it remained the same.
I believe there is something wrong with my tables, as everything works fine with a clean installation without importing my data.
**Anyone would know why? At the moment, it is a feature I am unable to use.
Thanks.
48 04/27/2011 01:06:55 pm
Re: Asset Register (29 replies, posted in Modules Add-on's)
Thanks Dennis - It worked.
49 04/26/2011 07:53:20 pm
Re: Asset Register (29 replies, posted in Modules Add-on's)
I downloaded the latest FA 2.3.3 in a test environment.
I saw this asset register module, but could not get it to work, it says I am missing some tables.
Can I know what tables are these so I may even add them manually if needed?
I'd really like this module to be operative.
Thanks.
50 11/19/2010 08:55:13 pm
Re: How to input opening balance (4 replies, posted in Setup)
I started using it this year
So I entered my balance as of 31-Dec-2009
Then I created new fiscal year 2010
And I started using it this year
The exact wiki link is here, but you should read it all as recommended by Joe
https://frontaccounting.com/fawiki/index.php?n=Main.OpeningBalances