It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by apmuthu
Finally, for FA 2.4.7+, Customer / Supplier Attachments are now possible with the changed files attached and inclusion of one inc file.
No DB changes. No external dependencies.
No "#" number ID for Customers / Suppliers as no transactions are involved.
Thanks to @Rmendez for checking it out and persisting with it.
Please test and revert on any issues.
All reporting/repXXX.php files call the reporting/includes/pdf_reports.inc based on destination chosen in the report request form.
All reporting/repXXX.php files are called only from reporting/reports_main.php which in turn "includes" the includes/ui.inc and that in turn "includes" the includes/ui/ui_globals.inc file (among others) that defines the function count_array().
Hence no need for separate inclusion of includes/ui/ui_globals.inc except when the reports are used independent of the above file.
Wonder why Line 374 was left out from such a change in reporting/includes/pdf_report.inc.
$count = count($this->headers2);The fix is to replace line 61 in admin/attachments.php:
header('Content-Disposition: attachment; filename='.$row['filename']);with:
header('Content-Disposition: attachment; filename="'.$row['filename'].'"');This just wraps the $filename within double quotes.
@joe: can commit it.
File Attachments with and without spaces in their filenames get uploaded okay. When a download is attempted, then files with spaces in their names get truncated at the first space in file save dialog box.
When trying to attach a Word Document (docx) in a Windows XAMPP environment, the actual filetype realised is:
application/vnd.openxmlformats-officedocument.wordprocessingml.document which turns out to be 72.
The field size for the above in the attachments table is 60.
Also proper html decoding of the '"' character does not occur in the attachment insertion sql.
The function get_post($name, $dflt='') is defined in includes/ui/ui_controls.inc.
The function check_value($name) is defined in includes/ui/ui_input.inc.
In the former, a default non zero / non one value / null can be set whereas, in the latter the default value is hardcoded as 0 or 1.
In the former, isset() is used for blank check whilst in the latter an empty() check is used.
Each one uses themselves recursively for arrays.
Hence in FA, are these two equivalent across PHP versions:
get_post('tax_included', 0)
and
check_value('tax_included')
?
After line 158 in includes/db/connect_db_mysqli.inc (and it's equivalent in mysql), the following lines may be added:
if( strpos($value, '"') )
$value = str_replace(""", '"', $value);Please check the playout in non latin* / utf-8 encodings.
@joe: will this affect anything?
Search for "count(" in the reporting/includes/pdf_report.inc and we find 15 occurrences that need to be replaced with "count_array("
@joe: can commit this along with the inclusion of includes/ui/ui_globals.inc in it.
This post is quite old and the domain no longer exists.
This domain registration expired on 12/05/2018.
Which chart of accounts did you start from that failed to have the auto_increment flag on to begin with?
File: admin/db/transactions_db.inc
Line 34:
$sql .= ",t.$trans_date as trans_date";to be replaced with:
if ($trans_date)
$sql .= ",t.$trans_date as trans_date";@joe: can commit it.
There is no Field id in the above statement. Only the Field tax_type_id is there.
The said error occurs in the function add_trans_tax_details() defined in gl/includes/db/gl_db_trans.inc. Hence check the whole of the Sales Order cart for any missing / improper data. Also check the value of $tax_id and see if it is properly related record with some valid value for the field tax_type_id in the Tax Setup.
This might have something to do with missing exchange rates if other currencies are involved or a duplicate reference is used.
Lines 323 to 330 in reporting/rep303.php:
if ($barcodes && barcode_check($trans['stock_id']))
{
$adjust = true;
$bar_y = $rep->GetY();
$barcode = str_pad($trans['stock_id'], 7, '0', STR_PAD_LEFT);
$barcode = substr($barcode, 0, 8); // EAN 8 Check digit is auto computed and barcode printed
$rep->write1DBarcode($barcode, 'EAN8', $rep->cols[$firstcol++], $bar_y + 22, 22, $SysPrefs->pic_height, 1.2, $style, 'N');
} @joe: We need to put in BarCode type as a per company variable in the sysprefs table and have a table that looks up the size and checkdigit details preferably from the tcpdf file. Also, the stock_id field can be increased to be greater than the size of all known barcode types.
Yes - Separate Sub Ledger Account for each trackable Customer or use the customer reports.
The report shared is a common one for all GL Transactions - True Ledger. As this needs to accomodate all kinds of references, the Person/Item column may not exist for every line record.
Custom reports with minor changes can be made to a copy of the appropriate report in reporting/rep###.php file and then placed in the company/#/reporting/ folder where it will override the original in actual FA usage.
If the custom report is completely different, make it as an extension and install it - see samples under the rep_* folders here.
Read the wiki.
FA does not have a separate field for Cheque Number in the core - you will need an extension for it - besides it does not qualify as to which bank it pertains to even here. However, it can be part of the memo / detail field in FA.
Banking and General Ledger (tab) => Reports => GL Account Transactions => Choose Accounts Receivables in From and To Accounts - this will yield a report with all customers in it. If sub-ledgers for each trackable customer is created for the AR main head, then it can be filtered on a per customer basis.
@joe: The report attached in the previous post can be made atleast in FA 2.5.
Export out a few Journal Transactions and then try to import them back with some date and number changes into a dummy install. Also try to upgrade your FA install to the latest in a test environment and see what happens.
We still need to resolve the missing add_bank_transaction() function in the core.
Void the entry in Setup => Void a Transaction.
The said rep304.php was last altered in FA 2.4RC1 way back on 2016-02-23. It is possible that the functions it uses may have been "fixed" thereafter. Try a fresh install of FA 2.4.7+ and see if you can simulate the error.
The said error occurs in the function add_journal() defined and called in write_journal_entries() in gl/includes/db/gl_journal.inc where the full complement of 10 arguments are used. Other functions too call it through:
add_supp_invoice() <= purchasing/includes/db/invoice_db.inc
void_supp_invoice() <= purchasing/includes/db/invoice_db.inc
add_wo_costs_journal() <= manufacturing/includes/db/work_order_costing_db.inc
handle_negative_inventory() <= includes/db/inventory_db.inc
add_exchange_variation() <= gl/includes/db/gl_db_banking.inc
add_cust_supp_revaluation <= gl/includes/db/gl_db_banking.inc
delete_this_fiscalyear() <= admin/db/fiscalyears_db.incNone of the above functions are directly called in the extension file modules/import_multijournalentries/import_multijournalentries.php.
The file /gl/includes/db/gl_db_trans.inc is included in the above extension file which defines the function add_gl_trans() which has many more arguments but does not use the event_date parameter.
The functions called by the said extension file of importance are:
write_journal_entries() <= gl/includes/db/gl_journal.inc
add_bank_transaction() <= ** (Cannot find it defined anywhere - not even in FA 2.3.x) **However, these functions are defined:
add_bank_transfer() <=gl/includes/db/gl_db_banking.inc
add_bank_trans() <= gl/includes/db/gl_db_bank_trans.incand both do not match the number and type of arguments used in the call.
The missing function add_bank_transaction() can be compared to the function write_bank_transaction() defined in gl/includes/db/gl_db_banking.inc but even this does not match the arguments used in the call.
@joe: where and how do we define the function add_bank_transaction() now?
Wherever you have an event_date field as blank / null, it appears that your MySQL / PHP is not happy with it and the normal '0000-00-00' is not acceptable as well and it does not degrade gracefully as earlier versions of PHP/MySQL did. Set the strict date off in MySQL and restart MySQL and Apache:
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
https://www.liquidweb.com/kb/how-to-disable-mysql-strict-mode/
Otherwise, make the existing settings happy by populating the import file with some date like 1970-01-01 wherever event_date is blank and then import it.
Lines 25-26 in config.php:
if (!ini_get('date.timezone'))
ini_set('date.timezone', 'Asia/Kolkata');Comment out the first line above and edit the second as needed.
Compare any dashboard type theme (like canvas / dropdown) files with the AdminLTE and make the necessary images / css changes as needed.
https://gist.github.com/Dreyer/2958946
https://conetix.com.au/support/simple-php-mail-test/
State what language interface you use so that you can get the appropriate developer and what bounty you offer.
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.