Search options (Page 121 of 247)

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.

It is possible that the Company 0 is not the default company.
It is possible that the company prefix of '0_' may be in non default company as well.
Default company is based on $def_coy variable's value in config_db.php(attached example) file.

The example attached has the default company as 0 and the 0th element of the $db_connections array has it's tb_pref element as "0_" but this may not always be the case.

I assume you are using FA v2.3.25 as the Assets tab is missing.

You want to make a Bank Payment Entry and have the reference entered into a separate form field in the Journal Entry Page. How would you know which Bank payment entry's reference you want in the Journal Entry? If it is part of the same transaction, read it from the appropriate table's field directly without having it redundantly stored.

You can also have the additional reference as part of the appropriate Memo form field.

You can use the Tags feature to link various transactions as a group.