1,401

(1 replies, posted in Setup)

When you close a fiscal year, the profit/loss gets into the Balance Sheet from where the next year's opening balance comes in and a new trial balance comes up.

1,402

(1 replies, posted in Banking and General Ledger)

Account Code 2 is generally used for linking (lookup) with third party programs / vendors / suppliers / CRMs, etc. The ERD should self-explanatory. Refer the Wiki for other relationship notes.

Other Posts:
https://frontaccounting.com/punbb/viewtopic.php?pid=31109#p31109
https://frontaccounting.com/punbb/viewtopic.php?id=333

1,403

(10 replies, posted in Setup)

State your server platform, PHP/MySQL/Apache/Mail program and versions.
Refer the Wiki.

1,404

(8 replies, posted in Installation)

Yes, It sports the following in WAMP 3.0.6:

Apache 2.4.27
PHP 5.6.31, 7.0.23, 7.1.9
MySQL 5.7.19
MariaDB 10.2.8
PhpMyAdmin 4.7.4 
Adminer 4.3.1
PhpSysInfo 3.2.7

Wampserver 2.5 onwards are not compatible with

Windows XP, not even with SP3
Windows Server 2003

and they also require a disk formatted as an NTFS partition, and does not support FAT32 or exFAT.

Caveats:
If you install Wampserver over an existing version, not only it will not work, but you risk losing your existing databases. Also install it in a root folder like C:\wamp or d:\wamp . Close Skype or force not to use port 80 before installation and while WAMP is in use.

WAMP 3.1.4 was released on 2018-09-25.

1,405

(8 replies, posted in Installation)

PHP and Apache don't have official supported 64 bit Windows builds.
Only MySQL out of the three does, hence no 64 bit bundle for XAMPP on Windows.

However, the current versions of PHP seem to have some 64 bit builds at https://windows.php.net/.

Processors, manufactured after 2011, most likely support AVX and it's PHP builds. The exact information about the hardware can be retrieved by using the Coreinfo tool.

Current Apache for Windows 64 bit are available at Apache Lounge.

In spite of all the above, give the 32 bit version of XAMPP a try on Win 10 with the specs in my previous post and provide benchmarks on actual concurrent usage and load factors in your network.

1,406

(7 replies, posted in Setup)

Place a bounty with specs on the Job Offers Board here and see what gives.

1,407

(17 replies, posted in Reporting)

Generally the doctext.inc change is sufficient for all reports.

1,408

(8 replies, posted in Installation)

If you are using XAMPP, then only a 32 bit version is available so more than 3.2 GB RAM is meaningless.
You can however, use VMWare Player to run 64 bit Debian/Ubuntu/CentOS, etc., inside Windows, whilst all your end users can be on Windows browsers.

100 Users or 100 concurrently using clients?

They can be normal hardware with 16 GB Win2012R2 running IIS if you need to run FA on the host itself.

1,409

(4 replies, posted in Announcements)

FA 2.4.5 Screenshots of available Charts, Extensions, Languages and Themes attached.

1,410

(1 replies, posted in Reporting)

This is a non standard report - take assistance from the author.

1,411

(3 replies, posted in Reporting)

The fields were made available for the report. You need to write the code in the place where you want it to go.

Try creating 2 separate sales orders - one from each warehouse. Then combine the sales orders to make 1 invoice.

Instead of modifying the invoice, you may have deleted it and re-created it. If not, what happened to the invoice #541 - what PI_* does it bear? Trace back and see which invoice number began to to go out of synch with your PI_* numbers. See if some were voided.

1,414

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

The documentation is at:
https://github.com/apmuthu/FA24extensions/tree/master/Extensions/repgen/doc

1,415

(17 replies, posted in Reporting)

Study the use of the $Footer array in reporting/includes/doctext.inc.

At the end of the reporting/includes/doctext.inc file, the following was added to get the output attached:

    $Footer[] = "THIS IS A SYSTEM GENERATED REPORT AND NO SIGNATURE IS REQUIRED";

1,416

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

This parameter 4 is available only when the company preferences is set to use 2 dimensions and the report request form has the second dimension chosen. If you still get this error, then you should get a similar error when using report rep706.php too - Balance Sheet - with similar form request parameters chosen. The same applies to the Cash Flow Statement as well.

Customer Ledger Report: The constants ST_BULKDEPOSIT and ST_CASHDEPOSIT are not part of standard FrontAccounting and is what @braathwaate has in his fork. You may remove those entries in the said line and it should work.

1,417

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

Yes, that's right.
How did it go?

CTRL-P is a browser attached command and has nothing to do with FA.
Assign CTRL-P to something in the browser shortcuts customisation if you want it browser wide for all sites.

The popup page comes from gl/view/gl_trans_view.php.

Comment out the last php line in the above file (line 160).
Output Attached.

1,419

(17 replies, posted in Reporting)

I trust the attachment will speak for itself.

Checkout the function hyperlink_back() in includes/ui/ui_controls.inc, specifically the echo lines 213 and 215:

    if ($no_menu)
    {
        echo "<td align=center><a href='javascript:window.print();'>"._("Print")."</a></td>\n";
    }    
    echo "<td align=center><a href='javascript:goBack(".($final ? '-2' : '').");'>".($no_menu ? _("Close") : _("Back"))."</a></td>\n";

If you want to remove the Print/Close in all pages, then make the above to be:

    if ($no_menu)
    {
        echo "<td align=center>&nbsp;</td>\n";
    }    
    echo "<td align=center><a href='javascript:goBack(".($final ? '-2' : '').");'>".($no_menu ? "" : _("Back"))."</a></td>\n";

1,421

(17 replies, posted in Reporting)

See the release post for changed files.

1,422

(4 replies, posted in Announcements)

Attached is the set of changed files between FA 2.4.4 and FA 2.4.5.

All upgrade caveats apply and among others they are:
1. backup files and sql first
2. sys_prefs table entries - ref_no_auto_increase, print_dialog_direct
3. config.php variables and their settings
4. db changes if any
5. sequential updates from each version
6. extensions compatibility
7. language strings

The Sourceforge mirrors may not yet have been updated (Excellmedia, Kent). The following links work now:

https://liquidtelecom.dl.sourceforge.net/project/frontaccounting/FrontAccounting%202.4/2.4.5/frontaccounting-2.4.5.tar.gz
Size: 1,574,771 bytes
MD5: C0AA7D697E8DCB5F3A44E709165DE3485E396911
md5: c0aa7d697e8dcb5f3a44e709165de3485e396911

https://sourceforge.net/code-snapshots/git/f/fr/frontaccounting/git.git/frontaccounting-git-080086d679db208567059b420ebfb5fcd7aae5b5.zip

The first 2 day download stats for FA 2.4.5 since it's release shows the UK (57) just leading India (41) with the others way behind. Weekend may be a reason as well.

1,423

(17 replies, posted in Reporting)

This has been fixed a few weeks ago for PHP 7.x users. Upgrade to FA 2.4.5 or use the appropriate commits for fixing it.

1,424

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

These are strict variable scoping issues with PHP 7.2+. Just declare the said variables as 0 just before the structure ("if", "while", etc.,) in which it is used for the first time. In the case of your first issue, you will need to insert the following just before the "if" statement at line 110 in rep_statement_reconcile.php:

$total_debit = $total_credit = 0;

1,425

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

What version of PHP are you using?
It could be a scope issue in some later versions of PHP.
Just place the following statement above the "if" statement at line 50 in repgen/includes/repgen_def.inc:

$protocol='';

or hardcode as desired.