I can see the preconfigured dashboards with test data for each module but cannot cannot get the dashboard maintenance and reminders options to appear under the setup / miscellaneous menu section.

I have checked for access rights as system administrator and have every option selected but there is no reference to dashboards or reminders in the list.  There is no option to install Dashboards under the Install/Activate Extensions menu (i read elsewhere that it is already part of V2.4).

I have the same issue on my live company installation (in a similar environment) - everything else is working and the standard general ledger dashboard is visible with correct data.

No errors appear when debug mode is enabled.

Any ideas as to what could be wrong?

Am just a layman user of front accounting and i do enjoy it a lot. Thank you for good work. Am facing a challenge as i try to add new user, I key in all details and submit but system does not show any error nor adding user. I logged in admin with all access.
Will appreciate alot to get your support.Thanks.

Go to https://www.chatgpt.com
Type in:
How do I configure GST for India in FrontAccounting application?

ChatGPT said:

Configuring GST for India in FrontAccounting involves a few steps to ensure that the application is set up correctly to handle GST (Goods and Services Tax) for transactions. Follow these steps:
1. Set Up GST Tax Categories

In India, there are different GST rates, such as 5%, 12%, 18%, and 28%. These need to be set up in FrontAccounting.

    Navigate to the "Taxes" section in the application:
        Go to "System" → "Taxes" → "Tax Categories".
        Add the different tax categories that correspond to the Indian GST rates. You will typically need categories like:
            GST 5%
            GST 12%
            GST 18%
            GST 28%
            IGST (for interstate transactions)

    In each tax category, specify the percentage rate and whether it’s CGST, SGST, or IGST.

2. Set Up GST Accounts

You'll need specific accounts for GST purposes to track the collection and payment of GST, as well as Input and Output GST.

    Navigate to the "Chart of Accounts":
        Go to "Accounts" → "Chart of Accounts".
        Create separate accounts for:
            GST Output (Sales GST) – For the GST collected on sales.
            GST Input (Purchase GST) – For the GST paid on purchases.
            CGST, SGST, and IGST – If you need separate accounts for each type of GST (this is necessary for compliance).

3. Configure Tax Calculation Method

Next, you need to configure the tax calculation method for your items and services.

    Navigate to "Items" → "Item Master".
    Add your inventory items or services with the appropriate tax category for GST.
        Select the tax category for each item (5%, 12%, 18%, etc.), depending on the GST rate applicable to the product/service.
        FrontAccounting will use these settings to calculate GST during invoicing.

4. Configure GST on Sales and Purchases

Make sure that GST is applied correctly when creating sales and purchase invoices.

    Sales Invoice:
        When creating a sales invoice, select the correct GST tax category for the items sold.
        The system will automatically calculate and display the GST based on the rate configured for each item.

    Purchase Invoice:
        Similarly, for purchase invoices, ensure you select the correct GST tax category to record the GST paid.

5. Configure GST Reporting

To file GST returns, you’ll need to generate GST reports.

    GST Return Report:
        FrontAccounting can generate reports to show sales and purchases with GST details.
        Go to "Reports" → "Tax Reports" → "GST Report". This will give you a breakdown of the tax amounts for your records.
        You can generate GST Summary or GST Detail reports that help you with tax filings.

6. GST Filing Period

Ensure that the fiscal year in FrontAccounting is set up to match India's GST filing cycle (monthly or quarterly). You can specify the dates for each period as required.
Additional Tips:

    GST Invoices: Ensure the GST numbers (GSTIN) are added to invoices, especially for inter-state transactions.
    Tax Adjustment: If you need to adjust tax amounts, FrontAccounting provides options to modify tax rates for specific transactions.

If you're unsure about specific GST requirements, consult with a local tax professional who understands the nuances of India’s GST system.

The clients have two distinct groups of clients, Steel works and Loans.

Is it possible to add the Sales Group to the New Customer Creation form?

Will Front accounting still function?

I have upgraded on site's PHP and will check if I get any issue in FA and report here.

I am experiencing that the list of report show all the modules and their associated reports on the Reports and Analysis Screen. When I any module (which is not included for the user) and try to run the report then a warning message pops up that "...no permission...". My point here is that those modules and their associated reports should not be be shown. Because, this is causing confusion in the users.

I marked off the module by setting $hide_inaccessible_menu_items = 1; in config.php. It means that the reports list defined in reports_main.php is not synchronized with the main configuration in config.php.

For trying, I went into the reports_main.php and manually marked the options off then those modules and their associated reports got  dissappeared.

I think this configuration should be automatically synchronized with config.php.

Please advise - thanks!

Side Note: I have implemented ERPs with configuration data stored in a database, which makes them easier to manage and use. Why is this approach not used for FA (out of curiosity)?

Thanks!

Can frontaccounting be setup on sharepoint / onedrive?

Is there any tutorial to do the same?

Regards

Is there any way to fix this

The latest is 2.4.18

Assuming I have not modified the database will a 2.4.6 backup restore ok in 2.4.18

I am going to wipe the old Fiscal Years, but want to keep inventory, manufacturing and COA, etc

Tom
(yes I been gone for a very long time)

# Script to create a new company with all random credentials in Debian

COA=en_IN_24-new

# To be shown in the login form
COMPANYNICKNAME="My New Company"

FADBCONFIG=/var/www/frontac/config_db.php

UPASSWD=`dd if=/dev/urandom count=200 bs=1 2>/dev/null|tr "\n" " "|sed 's/[^a-zA-Z0-9]//g'|cut -c-12`
RANUSER=`dd if=/dev/urandom count=200 bs=1 2>/dev/null|tr "\n" " "|sed 's/[^a-zA-Z0-9]//g'|cut -c-12`
FADBNAME=`dd if=/dev/urandom count=200 bs=1 2>/dev/null|tr "\n" " "|sed 's/[^a-zA-Z0-9]//g'|cut -c-12`
DEFCOPWD=`dd if=/dev/urandom count=200 bs=1 2>/dev/null|tr "\n" " "|sed 's/[^a-zA-Z0-9]//g'|cut -c-8`

mysql <<EOF

CREATE USER ${RANUSER} IDENTIFIED BY '${UPASSWD}';
DROP USER '${UPASSWD}'@'%';
CREATE DATABASE ${FADBNAME} DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, SHOW VIEW, ALTER ROUTINE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, EVENT, EXECUTE, LOCK TABLES, REFERENCES, TRIGGER ON ${FADBNAME}.* TO '${RANUSER}'@'localhost' IDENTIFIED BY '${UPASSWD}';
FLUSH PRIVILEGES;
USE ${FADBNAME};
source /var/www/frontac/sql/${COA}.sql
INSERT INTO `0_users` (`id`,`user_id`,`password`,`real_name`,`role_id`,`phone`,`email`,`language`,`date_format`,`date_sep`,`tho_sep`,`dec_sep`,`theme`,`page_size`,`prices_dec`,`qty_dec`,`rates_dec`,`percent_dec`,`show_gl`,`show_codes`,`show_hints`,`last_visit_date`,`query_size`,`graphic_links`,`pos`,`print_profile`,`rep_popup`,`sticky_doc_date`,`startup_tab`,`transaction_days`,`save_report_selections`,`use_date_picker`,`def_print_destination`,`def_print_orientation`,`inactive`) VALUES
 ('1', 'admin', MD5('${DEFCOPWD}'), 'Administrator', '2', '', 'admin@example.com', 'C', '1', '2', '0', '0', 'default', 'A4', '2', '2', '4', '1', '1', '1', '1', NOW(), '10', '1', '1', '', '1', '0', 'orders', '30', '0', '1', '0', '0', '0');

QUIT
EOF

# If the ${FADBCONFIG} script ends with "?>"
# Then remove it first with
sed '${/?>/d;}' -i ${FADBCONFIG}

echo "" >> ${FADBCONFIG};
echo "\$db_connections[] = array(" >> ${FADBCONFIG};
echo "    'name' => '${COMPANYNICKNAME}'," >> ${FADBCONFIG};
echo "    'host' => 'localhost'," >> ${FADBCONFIG};
echo "    'port' => ''," >> ${FADBCONFIG};
echo "    'dbuser' => '${RANUSER}'," >> ${FADBCONFIG};
echo "    'dbpassword' => '${UPASSWD}'," >> ${FADBCONFIG};
echo "    'dbname' => '${FADBNAME}'," >> ${FADBCONFIG};
echo "    'collation' => 'utf8_xx'," >> ${FADBCONFIG};
echo "    'tbpref' => '\$tb_pref_counter'.'_'," >> ${FADBCONFIG};
echo "  );" >> ${FADBCONFIG};
echo "\$tb_pref_counter++;" >> ${FADBCONFIG};
echo "" >> ${FADBCONFIG};
echo "# Company $tb_pref_counter admin password: " .  ${DEFCOPWD}  >> ${FADBCONFIG};
echo "" >> ${FADBCONFIG};

Users can extend this script or make one for using with an existing php script.

This can be used with the form in this post to auto create a company from a signup form.