Search options (Page 120 of 246)

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.

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.

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.

The "Our Customer No:" maps onto suppliers.supp_account_no field. This is the CustomerID allotted to us in the Suppliers' books of account.

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

It may be your PHP version.
Replace the line 211:

        foreach ($waapp->modules as $module)

with

        $wapp_modules = $waapp->modules;
        foreach ($waapp_modules as $module)

Which version of FA are you using? Try - payment within 1 day.

Please see the versions in my online repo:

1. 8 Digits Arabic CoA

2. 4 digits Arabic CoA

3. en_US-new.sql - English US Standard 4 digit CoA.

The differences between 1 and 3 above are that VARCHAR(60) in the English CoA is VARCHAR(120) in the Arabic CoA for the following fields to accommodate multibyte characters:

bank_accounts.bank_account_name
chart_class.class_name
chart_master.account_name
chart_types.name

Since the TB_PREF is already alaised in the FROM part, it is not necessary anywhere else.

Try to make a fresh installation and create the closing balance and create a new fiscal year and set it to be the active one and then close the earlier fiscal and then delete the earlier fiscal and then see if the trial balance for the current one tallies. It is imperative for the IDs of the fiscal years to be in chronological order.

Alternatively start with the current fiscal year and insert a journal voucher for the opening balance and then check if the trial balance tallies before beginning to enter the transactions for the current fiscal year.

Thanks @joe, @boxygen.

Committed to my repo after synching the whitespaces first so that the actual changes alone can be visible clearly.

Each time you have a popup of a PDF, just save it as a file and then open each in your PDF Viewing Application in separate windows and compare them.