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.
951 10/06/2019 07:14:44 am
Topic: Solved: File name truncation at space in Attachments (1 replies, posted in Report Bugs here)
952 10/06/2019 06:54:22 am
Topic: FileType data truncation (0 replies, posted in Report Bugs here)
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.
953 10/06/2019 06:03:17 am
Topic: get_post() vs check_value() (0 replies, posted in Report Bugs here)
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')
?
954 10/06/2019 04:55:54 am
Topic: HTMLentities for quote reversion (3 replies, posted in Report Bugs here)
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?
955 10/05/2019 06:15:02 pm
Re: reports_classes.inc:40: count() (26 replies, posted in Reporting)
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.
956 10/05/2019 10:37:15 am
Re: New Modern login page (2 replies, posted in Modules Add-on's)
This post is quite old and the domain no longer exists.
This domain registration expired on 12/05/2018.
957 10/04/2019 03:06:51 pm
Re: Check entered data and save document (12 replies, posted in Accounts Receivable)
Which chart of accounts did you start from that failed to have the auto_increment flag on to begin with?
958 10/04/2019 04:31:02 am
Topic: Additional Transaction Date presence check (1 replies, posted in Report Bugs here)
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.
959 10/04/2019 03:21:56 am
Re: Check entered data and save document (12 replies, posted in Accounts Receivable)
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.
960 10/03/2019 03:58:53 pm
Re: Check entered data and save document (12 replies, posted in Accounts Receivable)
This might have something to do with missing exchange rates if other currencies are involved or a duplicate reference is used.
961 10/03/2019 03:31:50 am
Re: erorr report (15 replies, posted in Reporting)
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.
962 10/02/2019 03:58:39 pm
Re: General Ledger of Customer with Debit, Credit and Description (3 replies, posted in Banking and General Ledger)
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.
963 10/02/2019 03:19:34 pm
Re: General Ledger of Customer with Debit, Credit and Description (3 replies, posted in Banking and General Ledger)
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.
964 10/02/2019 03:06:07 pm
Re: Import of a year of GL Transactions (7 replies, posted in Modules Add-on's)
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.
965 10/02/2019 09:26:08 am
Re: Journal Entry (1 replies, posted in Banking and General Ledger)
Void the entry in Setup => Void a Transaction.
966 10/02/2019 09:24:32 am
Re: Standard Cost Changes and as such result to Negative Profit in Report (28 replies, posted in Items and Inventory)
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.
967 10/02/2019 09:03:32 am
Re: Import of a year of GL Transactions (7 replies, posted in Modules Add-on's)
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.inc
None 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.inc
and 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?
968 10/01/2019 04:19:58 pm
Re: Import of a year of GL Transactions (7 replies, posted in Modules Add-on's)
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.
969 10/01/2019 04:13:56 pm
Re: Date and time Issue (3 replies, posted in Setup)
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.
970 10/01/2019 04:10:27 pm
Re: THEME ADDITION (8 replies, posted in FA Modifications)
Compare any dashboard type theme (like canvas / dropdown) files with the AdminLTE and make the necessary images / css changes as needed.
971 10/01/2019 04:05:47 pm
Re: Email not working in FA (8 replies, posted in Report Bugs here)
https://gist.github.com/Dreyer/2958946
https://conetix.com.au/support/simple-php-mail-test/
972 10/01/2019 04:04:04 pm
Re: Looking for FA Developer (2 replies, posted in Jobs wanted/offered, non-free offers)
State what language interface you use so that you can get the appropriate developer and what bounty you offer.
973 09/30/2019 03:37:31 pm
Re: Problem with Inventory Valuation Report Sub-store (9 replies, posted in Reporting)
We need to pinpoint the version / build date when it last worked as desired and not as in the policy stated now. Only then can a diff show what needs to be reverted if desired even if it violates espoused design policy.
974 09/30/2019 03:35:45 pm
Re: Standard Cost Changes and as such result to Negative Profit in Report (28 replies, posted in Items and Inventory)
Inventory Sales Report is rep304.php and it works fine at my end in both Windows and Linux on PHP 5.3.1 and 5.3.3 respectively. State your PHP version and other versions and which FA version you are on.