4,176 Reply by apmuthu

(3 replies, posted in Reporting)

If the report size is too big, ie., PHP uses more than say 1000 POST variables or has run out of memory and error_reporting has been turned off, such a situation will arise. Try increasing the max php variables allowed and script processing time and memory used in the php.ini (max_input_vars, 1000)

The following links are explanatory:
http://stackoverflow.com/questions/9505192/php-post-limited-to-1000-variables
http://stackoverflow.com/questions/5064485/php-limit-in-post-variables
https://www.a2hosting.com/kb/developer-corner/php/using-php.ini-directives/php-max-input-vars-directive

Go to forum: Reporting

4,177 Reply by apmuthu

(14 replies, posted in Banking and General Ledger)

After you are done, please provide feedback as to how we can improve the information in the wiki (maybe a new page is needed) to help others in future.

Go to forum: Banking and General Ledger

4,178 Reply by apmuthu

(1 replies, posted in Manufactoring)

Assembly: Make a BOM from Inventory and Assemble it to make another Inventory Product.
Disassembly: Disassemble such an assembled Inventory and explode the components back into their original inventory items.
Manufacture: Use a BOM along with other services and costs to manufacture an Item and you can keep adding items and costs as you manufacture.

Go to forum: Manufactoring

4,179 Reply by apmuthu

(1 replies, posted in Accounts Payable)

The Supplier Reference is from the Supplier's actual invoice document received from them bearing their reference number for interfacing with them. In case you are sequentially providing it on their behalf to suit your internal references then it can be what you will - it hopefully allows blank as well.

Go to forum: Accounts Payable

4,180 Reply by apmuthu

(10 replies, posted in Report Bugs here)

The file reporting/includes/Workbook.php has the functions to write the Excel file and the said function is part of it that helps store the End of File characters (Eof) for the header in a hexadecimal byte packed manner. It is possible that some PHP versions on some platforms may be putting out blank headers and only these separators get to the top.

BIFF means BInary File Format. There are many types of BIFF records.  Each has a 4 byte header.  The first two bytes are an opcode that specifies the record type.  The second two bytes specify record length.  Header values are stored in byte-reversed form (less significant byte first).  The rest of the record is the data itself

Other places where this is used so is at:
Line 195: http://voltampmedia.com/PHPExcel/html/_b_i_f_fwriter_8php_source.html
Line 195: http://phpcrossref.com/xref/moodle/lib/phpexcel/PHPExcel/Writer/Excel5/BIFFwriter.php.html#_storeeof

The Microsoft Excel Format is documented at:
https://www.openoffice.org/sc/excelfileformat.pdf
Excel97-2007 Binary File Format *.xls Specification.pdf
http://www.opennet.ru/docs/formats/xls.txt

Go to forum: Report Bugs here

4,181 Reply by apmuthu

(20 replies, posted in Report Bugs here)

The issue has been fixed in the core itself and the changes have been bundled and attached to the release announcement post. Just overwrite your FA v2.3.24 files with them.

Go to forum: Report Bugs here

4,182 Reply by apmuthu

(7 replies, posted in Reporting)

Try to list what fields you want - it may be possible to use the standard reports with appropriate filters for it.

Go to forum: Reporting

4,183 Reply by apmuthu

(15 replies, posted in Installation)

644 is a subset of 666 - check if the ownerships changed.

@joe: should we introduce the leading "\0" stripping out in the core? Will it affect any End of Field character for VARCHARS for buffer overflow exploits?

Go to forum: Installation

4,184 Reply by apmuthu

(9 replies, posted in Reporting)

Please see the Inventory Sales Report request form - there are filters for Inventory Category, Customer, location and service item flag.

Go to forum: Reporting

4,185 Reply by apmuthu

(18 replies, posted in Wish List)

Wow! So cheques in your country's accounting are treated as multiple time transferable negotiable instruments much like cash!

Sorry, FA does not cater to this, though you may put in whatever you want in the memo field and hope the cheques you issue of take in are their final resting place - you will not be informed by your vendors that they have passed on your cheque to their vendors.... and you in your turn will not inform your customers that their cheques have been passed on to your vendors!

Furthermore, your bank statement may not have much written in it's description field for you to reconcile multiple cheques with same value and date....

Endorsing someone's cheques to another is generally infrequent and is accomodated using Journal transfer entries but in your case it seems to be the order of the day!

Good Luck.

Go to forum: Wish List

4,186 Reply by apmuthu

(14 replies, posted in FA Modifications)

@joe: Thanks for a quick one.
Wiki-ed the updated screenshot for Rep304 and attached herein.

Go to forum: FA Modifications

4,187 Reply by apmuthu

(18 replies, posted in Wish List)

Post the cheque payment entries as on the date of the cheque / date of proposed submission to bank but make the entry now itself on getting the physical cheque. If any reference to the current date is needed, it may be put into the memo field for the transaction.

The actual date of encashment taken from the banker's statement can be entered into the bank reconciliation page at Banking and General Ledger => Reconcile Bank Account.

Go to forum: Wish List

4,188 Reply by apmuthu

(7 replies, posted in Reporting)

http://www.tutorialspoint.com/mysql/mysql_pdf_version.htm

Go to forum: Reporting

4,189 Reply by apmuthu

(9 replies, posted in Reporting)

See if the new report version posted in this post suits you.

Go to forum: Reporting

4,190 Reply by apmuthu

(1 replies, posted in Jobs wanted/offered, non-free offers)

Fix a price for each feature and see who calls....

BarCoding for FA is instructed in the Wiki.

Go to forum: Jobs wanted/offered, non-free offers

4,191 Reply by apmuthu

(14 replies, posted in Banking and General Ledger)

First, your theme is most welcome as there are many users for the RTL languages in FA. I have attached your screenshot here as well.

Yes, you are right about choosing 2014 as the active accounting year and entering the Journal entries as a single Journal Voucher - but in your case, you would then have to input all data from 2015-01-01 onwards and not from May 1st onwards.

Alternatively, just take a trial balance as of 2015-04-30 in your old system and keep all the account codes for them in your new CoA in FA handy (make new accounts and assign the appropriate account as a bank account) and make all entries as of 2015-04-30 in FA in the Banking and General Ledger => Journal Entry screen.

As for Bank Account, please note that a GL Account first needs to be made and then assigned as a bank account in the Banking and General Ledger => Bank Accounts screen.

To create a new GL Account, use the Banking and General Ledger => GL Accounts screen.

Go to forum: Banking and General Ledger

4,192 Reply by apmuthu

(1 replies, posted in Report Bugs here)

This issue has now been fixed in the db_pager.inc file itself using a subquery and hence above fix is not needed. It has been committed in the Official GitHub Mirror.

Go to forum: Report Bugs here

4,193 Reply by apmuthu

(14 replies, posted in Banking and General Ledger)

When does your accounting year start?
Are you getting into FA in the middle of a financial year?
If May 1st is your financial year beginning, then do you have your Balance Sheet as of April 30th (not yet there)?
Which CoA are you using for your FA?
What platform are you on - Linux?

Banking and General Ledger => Journal Entry
Fill in all your Balance Sheet entries as on the last date of your previous financial year and then close that year and all balances will have been brought forward into the new financial year.

FA is just a set of menu links - no big learning curve is necessary to warrant videos.

Go to forum: Banking and General Ledger

4,194 Topic by apmuthu

(1 replies, posted in Report Bugs here)

In the Journal Inquiry page, the db_pager.inc seems to grey out (disable) the First Prev Next Last page links since it is unable to get the total number of records using COUNT(DISTINCT(CONCAT group_by_clause)). This is because, the a.gl_seq field is NULL in many records by design (thanks to an archaic MySQL 3 workaround for lack of subqueries - see includes/db/audit_trail_db.inc first function).

The following patch will fix it:

--- gl/includes/db/gl_db_trans.inc    Sat Apr 04 01:10:00 2015
+++ gl/includes/db/gl_db_trans.inc    Fri Apr 10 21:58:56 2015
@@ -637,7 +637,7 @@
     if (!$alsoclosed) {
         $sql .= " AND gl_seq=0";
     }
-    $sql .= " GROUP BY gl.tran_date, a.gl_seq, gl.type, gl.type_no";
+    $sql .= " GROUP BY gl.tran_date, IF(ISNULL(a.gl_seq),0,a.gl_seq), gl.type, gl.type_no";
     return $sql;
 }
 ?>
\ No newline at end of file

The IF(ISNULL(... construct can be replaced in all places in the file with COALESCE(a.gl_seq,0)

Go to forum: Report Bugs here

4,195 Reply by apmuthu

(14 replies, posted in Banking and General Ledger)

Are you using FA for a new company for it's first year or do you have an opening balance Balance Sheet to start FA with for a new year?

Go to forum: Banking and General Ledger

4,196 Topic by apmuthu

(0 replies, posted in Misc. Charts of Accounts)

The Audit Trail tables ERD has been placed in the wiki.

Go to forum: Misc. Charts of Accounts

4,197 Reply by apmuthu

(9 replies, posted in Reporting)

Which is the nearest equivalent report you wish to customise or use as a basis for yours. All report screenshots are in the Wiki.

Go to forum: Reporting

4,198 Reply by apmuthu

(10 replies, posted in Report Bugs here)

Please verify that the same result occurs when a different browser is used. Thanks for your patience in providing valuable feedback.

Go to forum: Report Bugs here

4,199 Reply by apmuthu

(10 replies, posted in Report Bugs here)

Try to save the file from the URL in centos using wget and see if the blank line appears.

Also examine the file in a hex editor to see if it is a CRLF or just LF - (0D 0A or just 0A).

Then we can programattically remove it if it exists as the first character(s).

Attaching your screenshot for the forum.

Go to forum: Report Bugs here

4,200 Reply by apmuthu

(3 replies, posted in Report Bugs here)

A new install of FA 2.3.24+ was done in WinXP SP3 and XAMPP 1.7.3.
A Bank Payment was done to Insurance.
DB Backup Taken.
The said Bank Payment Journal Entry was edited and the expense Account changed to Licences.
DB Backup Taken.
The 2 DB Backups were compared.

Attached is the screenshots and backup files and comparisons done.

The next_reference field in sys_types table gets decremented - is this intended?
The existing entries have their amounts zeroed out.
New entries are created.
The voided entry (#9 here) is recorded in voided table.
A new entry number (#10 here) is given to the edited version of the entry.

All entries balance out perfectly. Where is the bug?

Is it only in the "reporting?

Attempting to use the url with trans_no=9 yields no data now and is as it should be.

Go to forum: Report Bugs here