26

(2 replies, posted in Setup)

FA has some fixes for PHP 8 and deployment notes from users on PHP 8.3 would be welcome.

27

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

SCOTT WHEELER, President, NOVERHEAD SOFTWARE, LLC, 132 Woodcrest Dr Loveland, OH, 45140-7756 United States/
In 2011: 6971 TICONDEROGA TRAIL EDEN PRAIRIE OH 55346

https://www.cartspan.com/
513-708-1317

https://frontaccounting.com/punbb/viewtopic.php?pid=43386#p43386

CartSpan itself is a Microsoft Windows based application that resides on your local desktop.  CartSpan will communicate with its own standard PHP script (ionCube encoded) to accomplish the integration work.

28

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

Zip and attach herein and send to @joe.
Fork and send pull request to the unofficial Extensions repo as well.
Also it should state the version of WP it was tested on and whether PHP8 constructs undermine legacy PHP versions of FA in usage.

29

(7 replies, posted in Items and Inventory)

There are 2 tables - stock_category and stock_master -  that have the field mb_flag in FA default installation. The former has it as dflt_mb_flag.

There are a total of 53 files with the field mb_flag in them in the core FA.

mb_flag values:
F => Fixed Asset
B =>Purchased -  Default in the tables, used only in reports rep3*.php as item.mb_flag='B' OR item.mb_flag='M'
M => Manufactured
D =>Service (S old flag)

Which file has mb_flag='A' ?

@joe: Should this be included?

Try to create another item of inventory type for the old one without inventory and proceed thereafter and see if you can back enter the old ones in the latter and then edit the invoices, salesorders and others that affect inventory thereafter

Those in EU will have time for this only when the Ukraine war is over and everyone feels safe there.

When re-ordering the arguments to functions, the appropriate function definitions should also be aligned accordingly.

34

(6 replies, posted in Items and Inventory)

Make the choice in the form for the said report. See attachment.

Deprecated is just a warning and can be suppressed in the php,ini.

Solution : Rename your function name emailcomm() to __construct()

Explanation: In previous versions of PHP, if PHP cannot find a __construct() function for a given class, it will search for the old-style constructor function, by the name of the class, but now old style constructors are DEPRECATED in PHP 7.0, and will be removed in a future version. You should always use __construct() in new code. Read php manual

   function __construct() {
      // copy your old constructor function code

https://stackoverflow.com/questions/47549783/php-deprecated-methods-with-the-same-name-as-their-class-will-not-be-constructo

36

(6 replies, posted in Items and Inventory)

https://frontaccounting.com/fawiki/uploads/Help/Rep304_Inventory_Sales_Report.png

Item Categories and Items

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

39

(6 replies, posted in Items and Inventory)

Inventory => Inventory Sales Report => rep304

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.

Try with PHP 5.5 / 5.6 and see if it persists.

42

(3 replies, posted in Reporting)

Use an older version like v6 for best performance if using PHP 5.6 or earlier.

43

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

Script Installers for FA 2.4.18 are available for:
Azure
Softaculous

Hence for obscurity, change the Title of the login page.

44

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

Quick Entries or Recurring JVs

Alternatively, direct computed SQL statements extracted from existing entries.

46

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

47

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

48

(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

49

(1 replies, posted in Installation)

Create a new company with the en_US-demo.sql Chart of Accounts.

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.