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 12/11/2018 01:54:09 pm
Re: Account Code 2 (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 12/11/2018 01:48:07 pm
Re: Config Setup Options (10 replies, posted in Setup)
State your server platform, PHP/MySQL/Apache/Mail program and versions.
Refer the Wiki.
1,404 12/10/2018 03:36:37 am
Re: Local Server Requirements (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 12/10/2018 12:30:55 am
Re: Local Server Requirements (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 12/09/2018 04:31:08 pm
Re: Integration LInk (7 replies, posted in Setup)
Place a bounty with specs on the Job Offers Board here and see what gives.
1,407 12/09/2018 04:30:02 pm
Re: Some Approving Text in footer (All Pages) (17 replies, posted in Reporting)
Generally the doctext.inc change is sufficient for all reports.
1,408 12/09/2018 04:29:02 pm
Re: Local Server Requirements (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 12/08/2018 03:11:45 pm
Re: Release 2.4.5 (4 replies, posted in Announcements)
FA 2.4.5 Screenshots of available Charts, Extensions, Languages and Themes attached.
1,410 12/08/2018 03:09:49 pm
Re: solve report (1 replies, posted in Reporting)
This is a non standard report - take assistance from the author.
1,411 12/08/2018 03:03:18 pm
Re: Customer Detail Listing (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.
1,412 12/08/2018 03:02:27 pm
Re: 2 items in an invoice from two separate warehouses (1 replies, posted in Items and Inventory)
Try creating 2 separate sales orders - one from each warehouse. Then combine the sales orders to make 1 invoice.
1,413 12/08/2018 03:01:20 pm
Re: Reference numbers and invoice numbers get out of sync (3 replies, posted in Accounts Payable)
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 12/08/2018 11:01:45 am
Re: Error modules Report Generator (5 replies, posted in Modules Add-on's)
The documentation is at:
https://github.com/apmuthu/FA24extensions/tree/master/Extensions/repgen/doc
1,415 12/08/2018 10:56:14 am
Re: Some Approving Text in footer (All Pages) (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 12/08/2018 10:32:48 am
Re: Problems running some reports (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 12/08/2018 09:59:01 am
Re: Error modules Report Generator (5 replies, posted in Modules Add-on's)
Yes, that's right.
How did it go?
1,418 12/08/2018 06:11:29 am
Re: Removing Print / Close and bottom URL from Journal Voucher (4 replies, posted in Reporting)
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 12/08/2018 06:04:59 am
Re: Some Approving Text in footer (All Pages) (17 replies, posted in Reporting)
I trust the attachment will speak for itself.
1,420 12/08/2018 05:12:35 am
Re: Removing Print / Close and bottom URL from Journal Voucher (4 replies, posted in Reporting)
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> </td>\n";
}
echo "<td align=center><a href='javascript:goBack(".($final ? '-2' : '').");'>".($no_menu ? "" : _("Back"))."</a></td>\n";
1,421 12/08/2018 03:49:37 am
Re: Some Approving Text in footer (All Pages) (17 replies, posted in Reporting)
See the release post for changed files.
1,422 12/08/2018 03:44:22 am
Re: Release 2.4.5 (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 12/07/2018 04:04:36 pm
Re: Some Approving Text in footer (All Pages) (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 12/07/2018 03:59:13 pm
Re: Problems running some reports (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 12/07/2018 03:49:49 pm
Re: Error modules Report Generator (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.