4,151 Reply by apmuthu

(4 replies, posted in Report Bugs here)

The recommended FA server versions for FA v2.3 are PHP 5.3+, MySQL 5 to 5.1 and Apache 2.2.x
The latest version of FA is v2.3.24 with many bugs squashed since your version which was released on 2013-.02-14. The date shown in your install is based on the file creation date of the CHANGELOG.php file.

MS Internet Explorer <= v8.0 is now not supported by FA. Use some of the later versions of FireFox. Chrome has it's quirks and politico-commercial slants.

Does your install have much data?
What CoA (chart) are you using?
Which extensions are you using?
Any customisations?

Go to forum: Report Bugs here

4,152 Reply by apmuthu

(7 replies, posted in Reporting)

Choose the Inventory Sales Report and choose your customer and the date range.
The Wiki page on FA Reports has the specific report 304 you want.

Navigate to:
Items and Inventory => Inventory Reports => Inventory Sales Report

Go to forum: Reporting

4,153 Reply by apmuthu

(14 replies, posted in Banking and General Ledger)

Actually, the Zoho looks simple enough but what happens to the figures if they are not balanced? Multiple submissions and JS error popups I guess.

The Journal Voucher mode makes sure the credits and debits are balanced and also allows you to have more than one opening balance for one account which is useful if you want to reconcile entries of the previous period.

If the trial balance is really big, it can span multiple Journal Vouchers by consolidating unallocated balances to a temporary Suspense Account from which the contras are made in subsequent JVs.

After all FA is designed and used primarily by Accountants (CPAs) and professional bookkeepers and not for simple income and expense tallying.

The Zoho screenshot is attached for reference towards any UI tweaking. Thanks for your valuable input.

Go to forum: Banking and General Ledger

4,154 Reply by apmuthu

(1 replies, posted in Report Bugs here)

See how the information is stored in the backend database table - you might want to escape it with a backslash or use the encoded version of it. If your db charset is UTF-8 it might have choices.

Go to forum: Report Bugs here

4,155 Reply by apmuthu

(4 replies, posted in Report Bugs here)

What platform are you using FA on - Linux or Windows?
What browser and version are your trying it out on?
MSIE versions <= 8 are not suitable for FA.

Go to forum: Report Bugs here

4,156 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,157 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,158 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,159 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,160 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,161 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,162 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,163 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,164 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,165 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,166 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,167 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,168 Reply by apmuthu

(7 replies, posted in Reporting)

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

Go to forum: Reporting

4,169 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,170 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,171 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,172 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,173 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,174 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,175 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