Skip to forum content
FrontAccounting forum
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 227 of 246)
Topics by apmuthu User defined search
Posts found: 5,651 to 5,675 of 6,149
Roles and Permissions issue?
Should the statement be to set inactive=0 instead of inactive=''?
Offending code is at lines 56-61 in includes/db/sql_functions.inc:
function update_record_status($id, $status, $table, $key) {
$sql = "UPDATE ".TB_PREF.$table." SET inactive = "
. db_escape($status)." WHERE $key=".db_escape($id);
db_query($sql, "Can't update record status");
}
Beware of legacy issues of if and when the column changed to be integer and whether all such tables have the same field type for field name inactive.
There are a total of 31 tables having inactive tinyint(1) and none having a field name of inactive with any other field type. Extensions are another matter though and whether they use this function here is also to be checked especially if they are not tinyint(1) or any int() for that matter.
Therefore it can be safely be changed to:
function update_record_status($id, $status, $table, $key) {
$sql = "UPDATE ".TB_PREF.$table." SET inactive = " . $status+0
. " WHERE $key=".db_escape($id);
db_query($sql, "Can't update record status");
}
Mockup of desired report would be useful along with name of report that nearly fits the bill.
Extensions cannot have their variables in the config.php.
It should be a flag in the extension itself that probably gets into the sysprefs table or extension's table.
Make sure that there is enough space in the reports (forced / default landscape?) and what fields can be dispensed with and list the mockup screenshot.
Lines 100 - 117 in sales/includes/db/sales_order_db.inc
if ($loc_notification == 1 && count($st_ids) > 0)
{
require_once($path_to_root . "/reporting/includes/class.mail.inc");
$company = get_company_prefs();
$mail = new email($company['coy_name'], $company['email']);
$from = $company['coy_name'] . " <" . $company['email'] . ">";
$to = $loc['location_name'] . " <" . $loc['email'] . ">";
$subject = _("Stocks below Re-Order Level at " . $loc['location_name']);
$msg = "\n";
for ($i = 0; $i < count($st_ids); $i++)
$msg .= $st_ids[$i] . " " . $st_names[$i] . ", " . _("Re-Order Level") . ": " . $st_reorder[$i] . ", " . _("Below") . ": " . $st_num[$i] . "\n";
$msg .= "\n" . _("Please reorder") . "\n\n";
$msg .= $company['coy_name'];
$mail->to($to);
$mail->subject($subject);
$mail->text($msg);
$ret = $mail->send();
}
The file class.mail.inc is included in only 2 files, one above and the other is reporting/includes/pdf_report.inc where mail sending code is present.
Implementation of the phpmailer class would require the patching of the said class.mail.inc file.
You can create the modules/_cache/extn-extver-extbuild/_init/config file along with a list of files in the extension and their sha1sums in modules/_cache/extn-extver-extbuild/_init/files and see if it shows up.
Alternatively create your own repo and place your packages in it and change the repo access details in version.php. It hasn't been made easy to get all the files from the repo as the scripts were not deemed ready for distribution yet.
Contact me offline if you want it.
Possibly a GitHub repo may be the answer for manual extension installs. The Linux ar command is used to create the pkg and possibly sign them and hence the ~data file is not extractable in Windows using 7-Zip.
Thanks Joe. HG Changeset 3195 does the job.
Updated the Wiki with a HOWTO for manual install and language extension creation. An offline PDF version is also available.
Attached the en_IN package for inclusion in the FA Repo.
Edit the lang/installed_languages.inc file and include the following array element into the $installed_languages array (take care of the array index assumed 1 here):
1 =>
array (
'code' => 'en_IN',
'name' => 'English (IN)',
'package' => 'en_IN',
'encoding' => 'iso-8859-1',
'version' => '2.3.15-1',
'path' => 'lang/en_IN',
),
Which version of FA are you using?
Lines 881 to 896 in ui_input.inc are:
function inactive_control_cell($id, $value, $table, $key)
{
global $Ajax;
$name = "Inactive". $id;
$value = $value ? 1:0;
if (check_value('show_inactive')) {
if (isset($_POST['LInact'][$id]) && (get_post('_Inactive'.$id.'_update') ||
get_post('Update')) && (check_value('Inactive'.$id) != $value)) {
update_record_status($id, !$value, $table, $key);
}
echo '<td align="center">'. checkbox(null, $name, $value, true, '', "align='center'")
. hidden("LInact[$id]", $value, false) . '</td>';
}
}
Your inverted ternery code - $value = $value ? 0:1; - will toggle the status.
Hi Joe,
Encapsulate the attached en_IN file for use with FA as a pkg.
Put in too much into the wiki over time - too much to copy over.....- too familiar with the wiki - please take care of it!
It would be nicer to view all prices in same units of qty and currency for comparison and listed sorted in ascending prices!
where is the reminder function?
Try it in a different browser - Firefox?
Also see that you have Java scripting enabled.
Java runtimes would also be nice.
Actually a signature switch can be set in all reports for
signature,
standard disclaimer or
no signature (default for backwards compatibility)
The signature can be set in the config file incurrent FA v2.3.x in a generic manner and in a per company instance as a new field in the company table in FA v2.4
@pierre whilst your change works, it is the non standard way and will get overwritten on updates. The preferred way is to make a copy of the lang/new_language_template/LC_MESSAGES/empty.po file and edit lines 10438-10439 to be:
msgid "INVOICE"
msgstr "TAX INVOICE"
and compile it with gettext as lang/en_SA/LC_MESSAGES/en_SA.mo and make an entry in the list of available languages and see that the locale is properly implemented. Refer Wiki.
GL Account Groups have a parent child relationship that can be used optionally.
Read the Wiki on Account Classes and Groups and Parent Ledgers.
Line 58 in purchasing/includes/po_class.inc :
if ($qty != 0 && isset($qty))
should be:
if ( isset($qty) && $qty != 0)
The file purchasing/includes/po_class.inc has the class definition for the class po_line_details which refers to the default Quantity / Price - check the defaults in the table schema as well.
There are no DB changes or config variables additions / changes in v2.3.15 vis-a-vis v2.3.14.
Just copy over the attached diff files into the FA folder.
Language strings will need to be translated from the empty.po as usual.
OpenVZ Template for FA v2.3.15 on Debian Squeeze is available at GNUAcademy.
FA core is okay as it is. Make extensions for peculiar (country specific / rare legal) needs. The programming paradigm - KISS - is well protected here and that is why most non-programmers have found it easy to fathom the code. Extending the COA is inadvisable - porting from other accounting systems / fa versions, inadvertant switch flag type fields, backward compatibility issues pervade.
[RANT]:
Non Accountants and Non Programmers must be able manage FA without having to bother with Government - businesses need simple acounting info / capability for day to day operations. Most countries have begun to question the need for Statutory Audit - Self Audit is being encouraged. In the aftermath of Enron / Arthur Anderson / and other major corporations / audit firms / banks fudging accounts, Governments too will soon have automatic billing systems in their countries from which their VATs will be auto-calculated instead of summary submissions each month/quarter/year! There seems to be little trusted data on countries printing / creating money and providing huge windfalls to select individuals of choice - insurance, subsidies, rights.
{NICE]
If you do not sell in currencies (debt denominator) issued by governments - you do not need to pay tax! Corollary - no one pays any taxes for using FA! No one's paying Joe/Janusz any monies for coding and preserving the FA source! Yet FA users will look after you (tax free) when you visit their countries.....People like them are the real assets worth preserving.
If you wish to replace the regular help URL with your site which has the relevant urls, you might be able to use the help hotkey popup functionality of FA.
Make one like Shipping at the bottom of the invoice or make a service item called, say, VAT Ajustments, with no tax and use it as a free form value.
Caveat: Must remember to do it each time one is needed.
Lines 64-69 in sales/view/view_invoice.php (although it is in the same lines of view_dispatch.php as well) can be commented out to remove the Charge Branch box.
start_table(TABLESTYLE, "width=100%");
$th = array(_("Charge Branch"));
table_header($th);
label_row(null, $branch["br_name"] . "<br>" . nl2br($branch["br_address"]), "nowrap");
end_table();
Other elements can be found there likewise.
Posts found: 5,651 to 5,675 of 6,149
