This post and this post may have some clues.

Start with Bank Charges and then choose the bank Account when making the Journal Entry.

You can post your changes for others to benefit and possibly for the project to incorporate it into the standard build.

2,929

(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

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

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

PAYROLL EXPENSES is a total field that is the Wages & Salaries A/c balance here.

2,933

(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

(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

(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

(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

(16 replies, posted in Reporting)

My Post #9 here has the FA 2.3.x version attached.

2,938

(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

(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

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

The changed order of the parameters may have altered functioning of your report.

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

(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

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

Approvals based data entry not available in standard FrontAccounting as yet.

2,946

(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

(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

(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

(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

(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