2,926 06/10/2017 04:53:27 am
Re: Allow Dashboard for user without Preferences enabling in FA 2.4.1 (2 replies, posted in Setup)
2,927 06/10/2017 04:48:15 am
Re: Journal Entry Extra Field Appearing (14 replies, posted in Banking and General Ledger)
Start with Bank Charges and then choose the bank Account when making the Journal Entry.
2,928 06/10/2017 04:46:29 am
Re: Show total value of credit column and debit column at GL inquiry (3 replies, posted in Reporting)
You can post your changes for others to benefit and possibly for the project to incorporate it into the standard build.
2,929 06/04/2017 06:55:18 pm
Re: Import CSV Items and FA 2.4 (7 replies, posted in Items and Inventory)
You will have to enable it from the default company for the target company and in the latter you will have to enable the role permissions.
2,930 06/03/2017 03:32:45 pm
Re: Import CSV Items and FA 2.4 (7 replies, posted in Items and Inventory)
@Dynamic is referring to an upgrade of FA 2.3 which has the Dashboard theme and extension to the new FA 2.4.1.
2,931 06/03/2017 07:53:10 am
Re: Maybe Error? in Profit and Loss Statement (7 replies, posted in Banking and General Ledger)
All Total Rows are auto generated.
...
Total SALES REVENUE 38,167 5,170 946.2
Total Income 38,167 5,170 946.2
...
Total PAYROLL EXPENSES 20,497 0 999.0
Total Costs 20,497 0 999.0
Calculated Return 7,670 5,170 70.2
2,932 06/02/2017 07:28:16 am
Re: Maybe Error? in Profit and Loss Statement (7 replies, posted in Banking and General Ledger)
PAYROLL EXPENSES is a total field that is the Wages & Salaries A/c balance here.
2,933 06/02/2017 07:25:55 am
Re: Import CSV Items and FA 2.4 (7 replies, posted in Items and Inventory)
Try to uninstall the old 2.3 Dynamic theme and install afresh from the 2.4 repo.
2,934 06/02/2017 07:23:57 am
Re: Dashboard Formatting Issues (9 replies, posted in Modules Add-on's)
A screenshot of how it now appears would be useful.
The pre tag should have the same effect. What browser and version are you using?
If the description has malicious code, it could compromise the output.
The pre tag also exists in the core code (from lines in FA 2.3):
Line 1379: includes/ui/ui_view.php
Line 57: includes/db/connect_db.inc
2,935 05/31/2017 10:39:22 am
Re: More php 7 fixes (14 replies, posted in Report Bugs here)
Set the immutable bit for the .htaccess file or move it's contents to the webserver config file itself possibly on a per folder tree basis.
Running separate subdomains for each application (wordpress, frontaccounting) with their own PHP version setting may be another option.
2,936 05/29/2017 09:54:24 am
Topic: Money class for PHP (0 replies, posted in Setup)
http://moneyphp.org/en/latest/
https://github.com/moneyphp/money
A large proportion of the computers in this world manipulate money, so it’s always puzzled me that money isn’t actually a first class data type in any mainstream programming language. The lack of a type causes problems, the most obvious surrounding currencies. If all your calculations are done in a single currency, this isn’t a huge problem, but once you involve multiple currencies you want to avoid adding your dollars to your yen without taking the currency differences into account. The more subtle problem is with rounding. Monetary calculations are often rounded to the smallest currency unit. When you do this it’s easy to lose pennies (or your local equivalent) because of rounding errors.
Anyone used it? Maybe FA might use it someday.
2,937 05/29/2017 09:52:07 am
Re: Excel rows does not show overs 65536 (16 replies, posted in Reporting)
My Post #9 here has the FA 2.3.x version attached.
2,938 05/28/2017 03:55:05 pm
Re: Release 2.3.26 (1 replies, posted in Announcements)
The set of Modified files to upgrade from FA 2.3.25 to v2.3.26 are attached herewith.
There are no newly added files.
The doc/CHANGELOG.old.txt file has been removed.
2,939 05/28/2017 03:48:50 pm
Re: Excel rows does not show overs 65536 (16 replies, posted in Reporting)
Many large users are still on FA 2.3.x and they would have the data to test this specific change for both the max lines and the time to generate the report and to see if there is any way to optimise the New Line check routine. An array of arrays that holds the segmented sets of records based on the max rows may be implemented to avoid checking on each new line that wastes time.
2,940 05/28/2017 03:43:12 pm
Re: Release 2.4.1 (9 replies, posted in Announcements)
2017-05-22 : FA 2.4.1
2016-02-23 : FA 2.4RC1
The aqua and cool themes have been removed.
The canvas and dropdown themes have been added.
Quite a few other files have been removed.
The New/Modified files are attached.
2,941 05/28/2017 03:33:15 pm
Re: How to add a new parameter to custom report (3 replies, posted in Reporting)
The changed order of the parameters may have altered functioning of your report.
2,942 05/28/2017 03:29:30 pm
Re: Entries done by one user and approved by another user (3 replies, posted in FA Modifications)
There is no Premium FA.
Standard FA means "unmodified" source as available in the official repo.
Each user can have customised FA to suit their needs and some of which may have such features.
2,943 05/28/2017 03:22:57 pm
Re: Dashboard Formatting Issues (9 replies, posted in Modules Add-on's)
Looks like the css should have wrap enabled (nowrap disabled).
Since you are using a customised dashboard, you will need to first see what differences there are between the original and your customised one when the customisation was done. The original one itself may have had the bugs and then got rectified in the mainstream itself. It is possible that the customisation may have been done in the core files as well.
The original Dashboard theme and extension are available in my repo.
2,944 05/28/2017 04:01:58 am
Re: Excel rows does not show overs 65536 (16 replies, posted in Reporting)
Is there something wrong with the function ymd2Date($year, $mon, $day) in excel_report.inc?
Try to echo ymd2Date(1985, 2, 24); and we get 31102.
Now check it out at Wolfram Alpha and we get 26th Feb 1985.
Excellent work @joe porting the PEAR/Perl code.
Further notes.
The files in @joe's post are for the FA 2.4.1 version and can be ported to v2.3.x as well.
Those who wish to test on FA 2.3.x can do so with the files in the attachment here.
2,945 05/28/2017 03:19:14 am
Re: Entries done by one user and approved by another user (3 replies, posted in FA Modifications)
Approvals based data entry not available in standard FrontAccounting as yet.
2,946 05/24/2017 06:35:26 pm
Re: orphaned company databases (6 replies, posted in Setup)
If there were some extensions installed earlier, their tables need to be considered as well. Assets was an extension in FA v2.3.x but is now it is an integral part of FA in v2.4.x.
2,947 05/23/2017 06:04:06 pm
Re: Solved: Supplier ID in Rep 201 and 205 (5 replies, posted in Reporting)
Report 201: Suppliers Balance
Report 205: Supplier Detail Listing
You can concatenate the supp_account_no and supp_name fields (from the suppliers table) in the said reports in the place of supp_name alone.
2,948 05/23/2017 04:34:07 pm
Re: Solved: Supplier ID in Rep 201 and 205 (5 replies, posted in Reporting)
The "Our Customer No:" maps onto suppliers.supp_account_no field. This is the CustomerID allotted to us in the Suppliers' books of account.
2,949 05/23/2017 04:23:56 pm
Re: Excel rows does not show overs 65536 (16 replies, posted in Reporting)
Since the existing Workbook.php is small and provides for small sized old formal xls files, let us implement the xlsx type format using any later excel library only for those reports that are over say 60K lines. Worksheets in the current instance need not be provided for each page. A new worksheet for every 60K lines may be the way forward without changing the library. This way both branches can benefit.
2,950 05/21/2017 06:21:42 pm
Re: Excel rows does not show overs 65536 (16 replies, posted in Reporting)
For now let is put a check for > 65535 lines and a appendage to the file name that it is truncated.
We use the reporting/includes/Workbook.php's BIFF Writer format that is probably the oldest and most compatible across spreadsheet applications.
$maxsize = 7087104;
The above limits filesize in Workbook.php.
Is there a way to flow the balance to new worksheets?
Or better still output a set of excel sheets sequentially numbered and zip them up....
The original PEAR package that has this file with all inclusions expanded out is at:
https://github.com/pear/Spreadsheet_Excel_Writer
http://hotexamples.com/examples/-/Spreadsheet_Excel_Writer_BIFFwriter/-/php-spreadsheet_excel_writer_biffwriter-class-examples.html
https://fossies.org/dox/SimpleGroupware_0.745/classSpreadsheet__Excel__Writer__BIFFwriter.html
Other Excel Libraries:
C++ - https://www.codeproject.com/Articles/42504/ExcelFormat-Library
PHP - https://github.com/PHPOffice/PHPExcel