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
After the $xr_providers array declaration in config.php see that the line below is appropriately assigned like:
$dflt_xr_provider = 0;You can also upload the post release FA files in the announcement post. Some folders will need write permissions for the webserver user in case you get permission denied errors.
The slow response, inordinate delay and timeout is perhaps your indexes have not been set as needed and redundant indexes need to be removed. Define "Large" database - backup size for 1 year and how many years data remain open? php.ini file can be tweaked to increase the timeout.
Commercial support is available from many forum users and you can also approach those on the Support list.
The missing sys_prefs table records can be put in in any order and their sane default values can be found in the sql/en_US-new.sql file.
The config.php file can be compared with the new config.default.php file and the missing entries put into the former.
The first two parts are only re-phrased.
Ordinarily there should be no duplicates.
Besides, the tables referred to in each select are different.
But... it is possible that more than one record across the selects may refer to the same transaction causing duplicates.
There may be duplicate lines - maybe a DISTINCT is needed somewhere. Try to make the INNER JOIN using an ON statement rather than in WHERE like:
case ST_BANKPAYMENT :
case ST_BANKDEPOSIT :
$sql = "SELECT trans.debtor_no as person_id,
CONVERT(debtor.name using utf8) as name
FROM ".TB_PREF."debtor_trans trans INNER JOIN ".TB_PREF."debtors_master debtor USING (debtor_no)
WHERE trans_no=".db_escape($trans_no)." AND type=".db_escape($trans_type)
."
UNION
SELECT trans.supplier_id as person_id,
CONVERT(supp.supp_name using utf8) as name
FROM ".TB_PREF."supp_trans trans INNER JOIN ".TB_PREF."suppliers supp USING (supplier_id)
WHERE trans_no=".db_escape($trans_no)." AND type=".db_escape($trans_type)
."
UNION
SELECT IF (person_type_id=0, 0 ,NULL) as person_id,
IF (person_type_id=0, CONVERT(person_id using utf8),NULL) as name
FROM ".TB_PREF."bank_trans
WHERE trans_no=".db_escape($trans_no)." AND type=".db_escape($trans_type)
;
break;Keeping a sys_prefs variable for the specific company's default theme choice too will be available only after login to the specific company.
Using the matched last logged in IP may suffice if fixed IPs (or net block) at the client side are there.
From FA 2.4.4 to 2.4.7:
* FTP the new files
* Put in the missing sys_prefs table records
print_dialog_direct
ref_no_auto_increase
* Update the config.php file
- there are no db changes.
Don't forget to update to the latest changes after the release of FA 2.4.7 too.
The install.html and update.html files have been removed.
The files in the "install" folder will need to be deleted.
Make a separate sandbox of FA 2.3.26 first. Check if your customized connector works with it or see if it can be tweaked to achieve it.
Are there any FA files that were changed as part of the tweaking?
Are those changes now accommodated in the current FA versions?
Upgrading from FA 2.3.6 to FA 2.4.7+ should be okay if you wish to retain the old document numbering system.
Create a new sandbox for FA 2.4.7+ and see if your connector now works with and make waht tweaks are necessary to make it work.
Manually inducting in all the FA 2.3.2 data into FA 2.4.7 will be tedious but is best preferred if you have the technical skillset (DB/PHP) or have someone to assist you with it - post your bounty in the Jobs board and see who bites.
Don't fix it if it ain't broke.
Then, FA would need some automatic means of assimilating the current purchasing price whenever it changes from the vendor end. Something like the daily Exchange rates!
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.
Make it part of the Tax name.
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.
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".
This may be so as reconciliation is based on downloadable statement from the banks.
@joe: your take?
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.
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.
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.
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.
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');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.
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.
Hardcode the value attribute of the form's input field in the appropriate form and make it hidden - this will apply globally.
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.
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.
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.