26

(13 replies, posted in Setup)

I am happy it helped. There is a very nice Wiki about taxes here

Rgds.

27

(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.

28

(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.

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.

30

(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.

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.

Committed.

32

(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.

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.

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.

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);

TM,

yeb, that did the trick. Issue fixed, thanks.
Working fine now.

Will also report it on Mantis.

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.

38

(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.

--------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 ;-)

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.

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.

42

(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>

43

(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.

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.

45

(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.

46

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

Thanks Dennis - It worked.

47

(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.

48

(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

same situation here - I have some third parties working for me, and I need to regularly enter these invoices on a monthly basis. I would also like to enter the rental and other fixed expenses and liabilities on a single click. Is that possible at the moment with FA? I am using latest version, v2.3RC.

Thanks for this application, it is just wonderful.

mmmh... haven't tried FA on Linux, would't be able to help. I thouht it was straight forward though.
I'll be following up on this post to see what the solution is.
Rgds.
Alberto.