https://frontaccounting.com/fawiki/uploads/Help/Rep304_Inventory_Sales_Report.png
2 11/27/2024 04:55:27 pm
Re: Items variations by sizes and color (2 replies, posted in Items and Inventory)
Item Categories and Items
3 11/12/2024 01:14:44 pm
Re: Translation using googletranslate (3 replies, posted in Translations)
The removal of & in &Items can be automated as well as long as & is not used anywhere else.
It can also be a php script as part of FA just like:
https://github.com/apmuthu/frontac24/blob/master/FA24Mods/make_coa.php
4 11/05/2024 04:05:02 pm
Re: Report on item sales (4 replies, posted in Items and Inventory)
Inventory => Inventory Sales Report => rep304
5 10/31/2024 10:55:02 pm
Re: Module and page access breaking .. (4 replies, posted in Modules/Add-on's)
Try to make the settings to http instead of https and make appropriate changes in includes/session.inc
Which platform are you on - linux/mac or windows?
Troubleshoot by putting in the extensions one by one and checking if the anomaly still exists.
Which extensions have you loaded and activated for each company?
Check the error logs.
6 10/29/2024 04:09:15 pm
Re: Module and page access breaking .. (4 replies, posted in Modules/Add-on's)
Try with PHP 5.5 / 5.6 and see if it persists.
7 10/14/2024 04:12:42 pm
Re: Alternative to RepGen (3 replies, posted in Reporting)
Use an older version like v6 for best performance if using PHP 5.6 or earlier.
8 10/04/2024 07:17:26 pm
Topic: Locating FA 2.4.18 sites (0 replies, posted in Installation)
Searching for "FrontAccounting 2.4.18 Login" yields quite a few FA 2.4.18 deployment sites like:
https://fhri.smarttools.systems
https://byzantia.capital
https://fncacctg.com/pasig2
http://34.101.78.123/--testing
https://www.royalqamis.co.ke
https://invoice.btiw.in
https://akankshaonline.com
https://varakiyu.com
https://mahs66.com/fa
https://tuckeroptimistclub.org/fa
https://www.ms.ly
https://townlinkhardware.comScript Installers for FA 2.4.18 are available for:
Azure
Softaculous
Hence for obscurity, change the Title of the login page.
9 10/04/2024 04:00:12 am
Re: Date Range for Search (2 replies, posted in Accounts Receivable)
Identify the inquiry page to display and then cull out the necessary fields and the computations needed and make a generic SQL SELECT query and execute it in any MySQL client and then make a php script for it.
10 10/04/2024 03:56:40 am
Re: Compounding Interest for Overdue Customers (1 replies, posted in Accounts Receivable)
Quick Entries or Recurring JVs
Alternatively, direct computed SQL statements extracted from existing entries.
11 09/27/2024 09:44:57 am
Topic: eInvoicing - Malaysia (0 replies, posted in Reporting)
By 2025, e-Invoicing is to come into effect fully in Malaysia.
https://www.complyance.io/malaysia-blog/e-invoicing-malaysia-guide
There are some guides for eCommerce in general at:
https://www.frontaccounting.com/fawiki/index.php?n=Help.SquareConnector
https://github.com/braathwaate/FA24extensions/tree/master/Extensions/square
https://frontaccounting.com/punbb/viewtopic.php?pid=43386#p43386
https://www.frontaccounting.com/punbb/viewtopic.php?id=2096
If there any solutions for FA do contact LC Chen of the Sita Group - +60-3-375-8888.
Is @TCLim still around - if so, what is the new website for his FA connectors?
12 09/27/2024 07:37:52 am
Re: 504 Gateway Timeout (2 replies, posted in Installation)
https://stackoverflow.com/questions/168736/how-do-you-set-a-default-value-for-a-mysql-datetime-column
https://stackoverflow.com/questions/54007824/how-to-set-sql-mode-in-my-cnf-in-mysql-8
Also check the parameter for legacy dates in my.cnf
[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION13 09/16/2024 06:42:38 pm
Re: report headers language (1 replies, posted in Reporting)
Have a look at reporting/includes/header2.inc
Also refer the wiki and look for "Header2.php file in Watermarking and background of reports"
"Arabic in FA" in https://frontaccounting.com/fawiki/index.php?n=Help.InstallUpdateLanugages
14 09/14/2024 05:53:27 pm
Re: Demo data (1 replies, posted in Installation)
Create a new company with the en_US-demo.sql Chart of Accounts.
15 09/14/2024 05:49:28 pm
Re: Access setup screen - Where is the list stored? (3 replies, posted in Setup)
Setup => Access Setup
lists the possible permissions for the modules when activated.
These are all "enum" equivalent type text fields (sections and areas) stored as semicolon delimited bcd values in the table #_security_roles.
16 09/11/2024 02:09:19 pm
Re: Access setup screen - Where is the list stored? (3 replies, posted in Setup)
Configuration on a per company basis are stored in the database - sys_prefs table. Configuration of a site-wide nature are stored in config.php file.
Read the wiki and search the forums at the outset.
17 09/09/2024 03:40:58 am
Re: Change of Ownership - Delete past years (14 replies, posted in Banking and General Ledger)
The zip file is the way the master branch is distributed for cutting edge code.
18 09/05/2024 04:30:07 pm
Topic: Update zh_CN Language in repo (1 replies, posted in Translations)
Kindly update zh_CN Language in repo.
zh_TW is more complete though.
19 09/05/2024 03:55:42 pm
Re: Change of Ownership - Delete past years (14 replies, posted in Banking and General Ledger)
The release tags if any are outdated as several updates in the 2 months since it's release will be available from the bleeding edge download at:
https://github.com/FrontAccountingERP/FA/archive/refs/heads/master.zip
20 08/31/2024 05:27:03 pm
Re: Frontacounting on sharepoint (1 replies, posted in Setup)
https://www.computerworld.com/article/2121520/microsoft-onedrive-cheat-sheet-using-onedrive-for-web.html
https://www.mrsharepoint.guru/sharepoint-vs-onedrive-pros-and-cons/
FA cannot be run directly off Sharepoint / OneDrive though content can be managed on them as file shares.
21 08/31/2024 05:23:53 pm
Re: Change of Ownership - Delete past years (14 replies, posted in Banking and General Ledger)
sf.net is the primary repo.
github is only a mirror.
@joe and @itronics are the main code repo integrators.
22 08/29/2024 06:21:58 am
Re: Change of Ownership - Delete past years (14 replies, posted in Banking and General Ledger)
The README.md file has a GitHub Mirror Link:
https://github.com/FrontAccountingERP/FA
23 08/28/2024 10:15:10 am
Re: Change of Ownership - Delete past years (14 replies, posted in Banking and General Ledger)
You can fork the project on GitHub and make changes as needed.
24 08/26/2024 08:01:25 am
Re: Change of Ownership - Delete past years (14 replies, posted in Banking and General Ledger)
@joe: is this okay?
25 08/22/2024 05:31:52 pm
Topic: Alternate FA forum on Spoken Tutorials (0 replies, posted in Setup)
https://forums.spoken-tutorial.org/filter/FrontAccounting-2.4.7/