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
Multiple Search boxes to be strung together with "and/or" would be useful too.
The Amazon Account Number could be in another table related to the customer table (more than one Amazon Account Number per client) and the module made into an extension so that it may be installed at will without disturbing the existing schema.
Easiest is to setup an account in GitHub and fork my repo - it has the extensions as well but not the unstable version nor does it have a commit by commit differential though it sports a release to release commit differential.
Use TortoiseGit on your Windows PC and synch with your read/write Github (or official Git readonly) repo.
To synch with the pristine Mercurial repo, use TortoiseHg on your Windows PC and synch with it albeit in readonly mode.
Updated my personal GitHub Repo.
Patch attached here.
Check if the modules/_cache is writeable by the webserver process.
To do it manually, follow instructions in the Wiki.
Yes it is fixed in the HG Repo and the consolidated list of files have been uploaded in the Release Posting.
https://frontaccounting.com/punbb/viewtopic.php?pid=18494#p18494
Function Lines 14 to 26 in purchasing/includes/db/suppalloc_db.inc are called in files includes/ui/allocation_cart.inc (lines 203-205) and purchasing/includes/db/invoice_db.inc (lines 357-358) and are:
function add_supp_allocation($amount, $trans_type_from, $trans_no_from,
$trans_type_to, $trans_no_to, $date_)
{
$date = date2sql($date_);
$sql = "INSERT INTO ".TB_PREF."supp_allocations (
amt, date_alloc,
trans_type_from, trans_no_from, trans_no_to, trans_type_to)
VALUES (".db_escape($amount).", '$date', "
.db_escape($trans_type_from).", ".db_escape($trans_no_from).", "
.db_escape($trans_no_to).", ".db_escape($trans_type_to).")";
db_query($sql, "A supplier allocation could not be added to the database");
}Somewhere the date2sql() function seems to fail or the $date_ variable does not have any value and no default is available.
It is possible you overwrote your config.php file
If you make one in MediaWiki, then export all pages as XML and submit it to project. Of course the files and images will have to be external links for this to be portable. Been wanting to do this in a long time.....
Must we now add the following in:
ALTER TABLE `0_debtor_trans` ADD INDEX `Order` (`order_`);We also need to optimise the query in the function at line 364 in sales/includes/db/cust_trans_db.inc to be:
function get_sql_for_sales_deliveries_view($selected_customer, $selected_stock_item=null)
{
$sql = "SELECT trans.trans_no,
debtor.name,
branch.branch_code,
branch.br_name,
sorder.deliver_to,
trans.reference,
sorder.customer_ref,
trans.tran_date,
trans.due_date,
(ov_amount+ov_gst+ov_freight+ov_freight_tax) AS DeliveryValue,
debtor.curr_code,
Sum(line.quantity-line.qty_done) AS Outstanding,
Sum(line.qty_done) AS Done
FROM "
.TB_PREF."sales_orders as sorder LEFT JOIN "
.TB_PREF."debtor_trans as trans
ON (sorder.order_no = trans.order_) LEFT JOIN "
.TB_PREF."debtor_trans_details as line
ON (line.debtor_trans_no = trans.trans_no
AND line.debtor_trans_type = trans.type) LEFT JOIN "
.TB_PREF."debtors_master as debtor
ON (trans.debtor_no = debtor.debtor_no) LEFT JOIN "
.TB_PREF."cust_branch as branch
ON (trans.branch_code = branch.branch_code
AND trans.debtor_no = branch.debtor_no)
WHERE
trans.type = ".ST_CUSTDELIVERY;Changing the FontSize in the report might make the 20 character space fit the 40 characters within it.
SWIFT MT940 Customer Statement Message (1.5 MB PDF)
Wiki-ed it.
All current HG fixes since release are available as a zip file in this post that can safely overwrite on a v2.3.19 install.
Wiki-ed it.
Thankyou for the thumbs up! It makes it worthwhile doing it when we know we can all benefit from it.
If your custom module has it's own tables updated from within it without touching the core FA tables, you have nothing to worry. Your module should be comprehensive enough to make any changes to it's tables when core FA dependent tables change.
Barcode is only a keyboard interface and once the cursor is in a barcode value box and the barcode scan button is pressed, the barcode's value enters the field. Depending on the terminating character code set in the barcode scanner (TAB or ENTER key), the effect will either be a passon to the next field or a submit action for the form.
Unless you submit your module for peer review no one will be able to help you any further here.
@erwindebruin: Congrats. You have just snared a rare bug and provided both the fix and the reference to the issue that will help many projects.
In fact it is pertinent to quote the solution link for FA dev records:
Monday, December 7, 2009
MySQL: Error 1305 - Function xxx does not exist
I ran into an odd issue on a project I updated awhile ago. I updated an existing sql statement to include IFNULL for an exclusion check. It worked fine on my dev machine, but caused an issue on the production machine.
The version of MySQL on my dev machine was a little bit newer than production so the issue never came up. Here is the error the sql server returned:
#1305 - FUNCTION [DATABASE_NAME].ifnull does not exist
Here is a little bit of the sql that caused the error:
AND IFNULL ( `tbl_category_admin`.`admin_key_id` =5, true )
The problem was caused by the space between IFNULL and (. Changing it to IFNULL( solved the problem. If you run into an issue where MySQL returns an error saying a given function does not exist look for spaces between the function and the "(".
The affected file in the Repo can be browsed here (see second IFNULL in lines 69-71).
Unfortunately, only Joe Hunt and Janusz (@itronics) have commit (write) rights to the core Hg Repo. Their reason being that the project would only then have tight control of the code and these seem to have been gleaned from the experiences in the upstream WebERP and some other projects. It seems to have worked well so far.
Since the Official Git Mirror has not been updated in a while, I have now synched the Hg with my personal GitHub repo and included your fix as well.
After several months of it's existence, only now has one active fork (of the 11 present) begun to provide code pulls to enhance FA.
Patch attached for Joe / Janusz to update the HG repo.
There have been very few changes from v2.3.18 to v2.3.19 and I have placed a list of changed files in an earlier post in this thread. There appears to be one more bugfix in the Hg repo that can be downloaded from here and made to overwrite the file at gl/gl_bank.php. It is also attached in this post.
All you have to do is step from one commit to the other in the HG Repo (red dot stable version commits only) and see where it fails.
Install v2.3.18 and make sure your error does not arise.
Start with fixes from the HG Repo at:
0002430: Order Status Listing Report shows invoiced in heading rather than delivered. Fixed.
and go on till the last one at:
Payments, Deposits: fixed false error when payment is made in customer/supplier currency.
If you can provide the sequence of menu clicks that got you the error, it will be easy to zero in to the issue.
You can now issue a merge of the pull request I have sent you:
https://github.com/msquared-id-au/frontaccounting/pull/1
Gist of what I have done:
1. Logged into my GitHub repo
2. Browsed into your repo
3. Issued a pull request from your GitHub repo to mine
4. Reached my repo and merged the incoming pull
5. Edited one file in the merged set that came from your repo and committed it in my repo
6. Issued a pull request from my GitHub repo to yours
7. Reached your repo and found the pull in order awaiting your logging in and merge to make both our repos in sync.
At anytime, you can view the state of all repos from your repo's perspective graphically at:
https://github.com/msquared-id-au/frontaccounting/network
My textcart commit is at:
https://github.com/apmuthu/frontaccounting/commit/31549aeaf0df9cac6e90cfcfe9a5ee108a614e73
My ldap changed file commit is at:
https://github.com/apmuthu/frontaccounting/commit/0c3d58e50e840248b937ac641ddf2203879df721
set_marker() is a method of class db_pager defined in includes/db_pager.inc. This function marks the rows in a specific way. You may need to extend this class and have one more method say set_marker2() to achieve what you want or modify the functionality of the existing method with an additional argument to flag it differently.
The sample code you are after are in files like:
Line 318 in sales/inquiry/sales_orders_view.php
and
Line 244 in sales/inquiry/customer_inquiry.php
The colors are provided as arguments to the set_marker() function as seen in lines 390-398 of includes/db_pager.inc:
// Set check function to mark some rows.
//
function set_marker($func, $notice='', $markercl='overduebg', $msgclass='overduefg' )
{
$this->marker = $func;
$this->marker_txt = $notice;
$this->marker_class = $markercl;
$this->notice_class = $msgclass;
}The color values of overduebg (background color) and overduefg (text color) for marking purposes are available in the various theme css like in lines 320-326 of themes/default/default.css :
.overduebg {
background-color: #dd7777;
}
.overduefg {
color: #dd7777;
}Have updated the textcart extension, you may want to pull it in.
If it is your own page, how can the community help you?
What page in FA are you using as the basis for your page?
Unless we know the context and what includes are available at the point of usage, how can we help you?
Create your own repo by extracting the repo archive from my github repo.
Put in whatever htaccess password you want and edit your version.php in your webroot to point to your repo.
A recent change in the install/isession.inc file where a new function html_cleanup() was introduced may need to be revisited. html_entity is no longer decoded.
State sequence of menu choices that lead to the target page where you want your feature. Screenshots would be useful too.
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.