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.....
5,277 11/21/2013 04:37:49 pm
Re: Slow query in Invoice Against Sales Delivery menu (3 replies, posted in Report Bugs here)
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;5,279 11/21/2013 04:19:19 pm
Re: Item Code character limit (3 replies, posted in FA Modifications)
Changing the FontSize in the report might make the 20 character space fit the 40 characters within it.
5,280 11/21/2013 04:13:04 pm
Re: Compare automatical incomming /outgoing payments with invoices (6 replies, posted in Banking and General Ledger)
SWIFT MT940 Customer Statement Message (1.5 MB PDF)
5,281 11/21/2013 04:07:43 pm
Re: Graduaded discount (2 replies, posted in Items and Inventory)
Wiki-ed it.
5,282 11/21/2013 04:01:32 pm
Re: Release 2.3.19 (21 replies, posted in Announcements)
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.
5,283 11/21/2013 03:59:04 pm
Re: Add a page to sales order (rep109.php) (5 replies, posted in Reporting)
Wiki-ed it.
5,284 11/21/2013 03:51:22 pm
Re: LDAP Auth (6 replies, posted in Installation)
Thankyou for the thumbs up! It makes it worthwhile doing it when we know we can all benefit from it.
5,285 11/21/2013 03:48:06 pm
Re: barcode integration possible in FrontAccounting (10 replies, posted in Wish List)
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.
5,286 11/10/2013 10:13:17 am
Re: Release 2.3.19 (21 replies, posted in Announcements)
@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.
5,287 11/10/2013 03:54:18 am
Re: Release 2.3.19 (21 replies, posted in Announcements)
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.
5,288 11/08/2013 05:55:39 pm
Re: Auth_LDAP repo location? (5 replies, posted in Modules Add-on's)
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
5,289 11/08/2013 04:50:55 pm
Re: About set_marker - That's Overdue Color (7 replies, posted in FA Modifications)
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;
}5,290 11/08/2013 07:45:18 am
Re: Auth_LDAP repo location? (5 replies, posted in Modules Add-on's)
Have updated the textcart extension, you may want to pull it in.
5,291 11/08/2013 07:43:48 am
Re: About set_marker - That's Overdue Color (7 replies, posted in FA Modifications)
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?
5,292 11/08/2013 07:40:39 am
Re: New Version 2.3.19 (10 replies, posted in Report Bugs here)
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.
5,293 11/08/2013 07:33:39 am
Re: About set_marker - That's Overdue Color (7 replies, posted in FA Modifications)
State sequence of menu choices that lead to the target page where you want your feature. Screenshots would be useful too.
5,294 11/08/2013 07:30:07 am
Re: LDAP Auth (6 replies, posted in Installation)
It is indeed quite heartening to note that my GitHub repo has been forked by 11 people and 3 users have provided a star (*) as well.
https://www.github.com/apmuthu/frontaccounting
(*) Date of Fork with Github.com path
2013-09-30 4myPAL / frontaccounting
* 2013-09-05 ahmedgomaa / frontaccounting
2013-10-14 badboys0505 / frontaccounting
2013-09-30 bregananta / frontaccounting
2013-04-30 christianestrella / frontaccounting
2013-05-30 dinhseva / frontaccounting
2013-10-14 jgera / frontaccounting
2013-09-05 MSofiaH / frontaccounting
2013-11-07 msquared-id-au / frontaccounting
2013-05-30 qernni / frontaccounting
2013-05-30 TuyetVu / frontaccounting
5,295 11/08/2013 06:36:51 am
Re: textcart - Purchasing error (4 replies, posted in Modules Add-on's)
Fixed in my Git Repo commit
5,296 11/07/2013 02:49:26 pm
Re: Release 2.3.19 (21 replies, posted in Announcements)
The core folder in my repo is just the full file set in the FA release directly from the SF release page and not a pull from the official repo. This is done for easy maintenance between version upgrades. All old files are wiped out when a new release comes in. No files are added to the core folder. A sibling to the core folder is the extensions folder that contains the files of the various extensions.
5,297 11/07/2013 12:20:15 pm
Re: Release 2.3.19 (21 replies, posted in Announcements)
My repo's core folder is the exact code base as the official one but on a release to release upload and the there are extras as well in a separate extensions folder in the repo.
I use this for comparing my personal changes against the official core and have the files from the fa extensions repo as well for any fixes in the interim that may come about.
5,298 11/07/2013 12:17:26 pm
Re: Compare automatical incomming /outgoing payments with invoices (6 replies, posted in Banking and General Ledger)
Probably the right description you were after was Automatic Allocation Reconciliation
5,299 11/07/2013 12:15:09 pm
Re: Invoice. (2 replies, posted in FA Modifications)
Create two customers for the customer with some suffix to distinguish between the two. Make one taxable and the other non taxable or other taxable.
5,300 11/07/2013 12:08:07 pm
Re: Indonesian Language (3 replies, posted in Translations)
On and after line 14299, all translations have been prefixed with "#~ "
Take the latest empty.po and the install empty.po files and translate to Indonesian and submit to FA.