1,052 06/28/2019 04:16:31 pm
Re: When purchasing an item, how to choose the cheapest supplier? (9 replies, posted in Accounts Payable)
To start with, we can make a report that lists the supplier in descending order of price for a specific item. If the last purchased price is very long ago, it will distort the order's inference. Hence a last purchased date too will need to form part of the report.
1,053 06/28/2019 03:49:02 am
Re: Tax and Gst Not displayed (1 replies, posted in Wish List)
Make it part of the Tax name.
1,054 06/26/2019 05:07:47 am
Re: Bank reconciliation and Bank Account Inquiry and Bank reports (6 replies, posted in Banking and General Ledger)
Generally the default bank account with have more transactions.
Try making the target bank account (the one with few transactions) as the default bank account temporarily and see if it now generates more transactions, before reverting back.
If we now get more transactions, then the devs can re-evaluate the code for it or reason it accordingly.
1,055 06/26/2019 02:35:08 am
Topic: oanda.com forex rates (0 replies, posted in Wish List)
Here is a code snippet that redirects to a page with the necessary forex rate but we need to capture the redirection in curl.
<?php
$from_curr = 'USD';
$to_curr = 'SGD';
$on_date = date('Y-m-d');
$form = <<<EOT
<form method="post" action="https://www1.oanda.com/currency/converter/" id="ncc_detail_form">
<input type="hidden" name="quote_currency_0" id="form_quote_currency_hidden" value="$from_curr" />
<input type="hidden" name="quote_amount" id="form_quote_amount_input_hidden" value="1" />
<input type="hidden" name="base_currency" id="form_base_currency_hidden" value="$to_curr" />
<input type="hidden" name="base_amount" id="form_base_amount_input_hidden" value="" />
<input type="hidden" name="last_action" id="form_last_action_hidden" value="" />
<input type="hidden" name="interbank_rates" id="form_interbank_rates_hidden" value="0" />
<input type="hidden" name="end_date" id="form_end_date_hidden" value="$on_date" />
<input type="hidden" name="language" id="form_language_hidden" value="en" />
<input type="hidden" name="view" id="form_view_hidden" value="details" />
<input type="submit" id="submit" name="submit" value="Submit" />
</form>
EOT;
echo $form;
?>
<script type="text/javascript">
window.onload = function(){
document.getElementById('submit').click();
}
</script>Even the Submit button can be "hidden".
1,056 06/26/2019 01:24:33 am
Re: Bank reconciliation and Bank Account Inquiry and Bank reports (6 replies, posted in Banking and General Ledger)
This may be so as reconciliation is based on downloadable statement from the banks.
@joe: your take?
1,057 06/25/2019 02:34:55 pm
Re: Release 2.4.7 (3 replies, posted in Announcements)
Attached is the set of changed files between FA 2.4.6 and FA 2.4.7.
* First 2 day download stats at SF.
* Previous release change fileset post.
* SF Main download page
* FA 2.4.7 tar.gz download
** MD5 Hash: 4d206c582c153fa32387bfe6e34aa1e2
** Filesize: 1,577,143 bytes.
1,058 06/21/2019 03:55:12 pm
Topic: Remove column when there is no hint (0 replies, posted in Modules Add-on's)
Default company
Defaullt theme
Setup => Add new extension/theme/language/chart page
User profile has "show_hints" enabled
If there is no hint to be displayed in Linux (not in XAMPP for windows), there is a column displayed in the right top corner as in the attachment that needs to be removed.
1,059 06/21/2019 12:40:42 pm
Topic: Current versions of all official addons to FA (0 replies, posted in Modules Add-on's)
The attachment shows the current versions of all charts, languages, extensions and themes.
Some may be corrected / updated in my unofficial FA24extensions repo and it's forks.
1,060 06/21/2019 12:36:38 pm
Re: Marked Item are over due implemented in New invoice (3 replies, posted in Accounts Receivable)
Attach the outstanding balance report along with the Invoice or edit the rep107 to add another page to show the ledger summary of last few transactions. FA cannot assume that all payments will be in full to match Invoice value.
1,061 06/21/2019 12:08:28 pm
Topic: Time Zone error (1 replies, posted in Report Bugs here)
The default time_zone is defined in the sys_prefs table.
It is also conditionally set as a php.ini variable in the config.php file.
The order of Timezone precedence in the includes/prefs/sysprefs.inc is in lines 33 to 45:
foreach(get_defined_vars() as $name => $value)
$this->$name = $value;
if (!@$this->time_zone)
$this->time_zone = ini_get('date.timezone');
if (!$this->time_zone)
$this->time_zone = 'Europe/Berlin';
if (!isset($this->use_popup_search))
$this->use_popup_search = false;
ini_set('date.timezone', $this->time_zone);This does not respect the php.ini's value (or its' scripted set value from the config.php) and in actuality gets overwritten by the 'Europe/Berlin' fallback value and reflects in the footer timestamp displayed in the FA pages even after login whence a current_user is available in the session variable.
The solution is to make an unconditional setting in the config.(config.default.php) file by replacing lines 25-26:
if (!ini_get('date.timezone'))
ini_set('date.timezone', 'Europe/Berlin');with
ini_set('date.timezone', 'Europe/Berlin');1,062 06/21/2019 11:58:00 am
Re: Marked Item are over due implemented in New invoice (3 replies, posted in Accounts Receivable)
The Previous Balance / Arrears do not form part of the Invoice and if done as per your request, will be subject to change when printed again after some payments are received.
1,063 06/21/2019 06:48:01 am
Re: Item Search-Adding New Search Criteria (3 replies, posted in Modules Add-on's)
Use the setting in Setup => Company Setup => Search Item List => tick the checkbox. Now Ajax suggestions will come in when you start typing in the Item name / code.
1,064 06/19/2019 02:34:06 am
Re: how to hide some input values (2 replies, posted in Accounts Payable)
Hardcode the value attribute of the form's input field in the appropriate form and make it hidden - this will apply globally.
1,065 06/19/2019 02:31:06 am
Re: Release 2.5. (10 replies, posted in Development)
1. Flexible Barcoding (and label printing) and Bin Locations in Warehousing.
2. Single table for all lookup masters with a filter field for form field dictionary name.
3. Move all functions in reports that are common to more than one report to a separate reporting/includes/report_functions.php file.
4. Categories for Items (cascading dropdowns).
5. Attributes for Items where price does not change.
1,066 06/19/2019 02:18:54 am
Re: Anomaly created by Cost Update in Inventory Sales Report (rep304) (20 replies, posted in Items and Inventory)
It would be nice to preserve the whitespace in the commits so that effective changes can be discerned. The whitespace cleanup can be in a separate commit.
The recent changes on 2019-06-17 (1, 2) have been assimilated in my repo separating the actual changes and the whitespace synch.
1,067 06/17/2019 01:57:19 am
Re: Update in reporting code (7 replies, posted in Reporting)
Nice work @barbarian. How does the code size compare?
Can anyone explain what the reporting/forms folder is for? We need to update the wiki on this score.
1,068 06/15/2019 02:30:35 am
Re: Arabic and other RTL ( Right to Left) languages User Interface (42 replies, posted in Translations)
@joe: will this need to be implemented in the core with an appropriate flag / if statement?
1,069 06/14/2019 05:01:06 am
Re: Update in reporting code (7 replies, posted in Reporting)
To avoid code bloat the various libraries are not being used. Also "old" does not mean "bad" and "new" does not have to mean "good". Users are free to extend the existing classes to suit their needs and submit it for peer review. Native rendering of TCPDF / FPDI makes for smaller PDF files rather than HTML to PDF conversions. Make a separate extension of your library using DOMPDF and the community will be the richer. Make for a simple meta template for reports and have any plugin library render the reports.
1,070 06/13/2019 02:55:50 am
Re: Cant add inventory items (7 replies, posted in Items and Inventory)
Typo?
x-frame-options SAMEORIGINSend out the header using PHP:
<?php
header("X-Frame-Options: SAMEORIGIN");
?>In .htaccess:
Header append X-FRAME-OPTIONS "SAMEORIGIN"
(or)
Header append X-FRAME-OPTIONS "DENY"1,071 06/12/2019 03:18:55 pm
Re: Item Search-Adding New Search Criteria (3 replies, posted in Modules Add-on's)
Search by Ajax should be okay.
1,072 06/10/2019 05:42:39 pm
Re: Add stamp or watermark to reports on the fly – ad hoc. V2 (2 replies, posted in FA Modifications)
@joe: good for the core?
1,073 05/31/2019 04:02:17 am
Re: How to enter a payment for a credit note? (20 replies, posted in Accounts Payable)
The functions supplier_credit_rowand customer_credit_row() are defined in includes/ui/ui_input.inc in lines 982-1004.
The link for the supplier_credit_row() is like:
purchasing/inquiry/supplier_inquiry.php?supplier_id=###The actual value of $credit is being passed into the said functions from/by the calling script which in this case appears to be twice the value it should report..
The supplier_credit_row() is called in:
purchasing/includes/ui/po_ui.inc line 145 (function display_po_header(&$order)):
supplier_credit_row($order->supplier_id, $order->credit);
purchasing/includes/ui/invoice_ui.inc line 160 (function invoice_header(&$supp_trans)):
supplier_credit_row($supp_trans->supplier_id, $supp_trans->credit);1,074 05/30/2019 04:15:44 pm
Re: How to enter a payment for a credit note? (20 replies, posted in Accounts Payable)
@joe: ??
1,075 05/29/2019 04:06:18 am
Re: 403 error for modules folder (5 replies, posted in Setup)
The module must be accessed only through the index.php in the FA webroot. Provide a template of your module access URL.