The download link http://www.kwikpay.co.nz/download/import_paypal.zip seems to be unavailable.
Even the domain default page http://www.kwikpay.co.nz/ is inaccessible too.
4,776 12/05/2014 04:15:17 am
Re: Import of Paypal transactions (8 replies, posted in Banking and General Ledger)
4,777 12/05/2014 04:12:31 am
Re: Email Address on Sent Email (3 replies, posted in Setup)
Please refer Wiki page.
Other relevant / related posts may be:
https://frontaccounting.com/punbb/viewtopic.php?id=341
https://frontaccounting.com/punbb/viewtopic.php?id=3774
https://frontaccounting.com/punbb/viewtopic.php?id=5258
4,778 12/05/2014 04:06:43 am
Re: Manual Bulk Import of Items (2 replies, posted in Items and Inventory)
To import opening stock of items we need to make sure how we are going to handle the contra entry in values of the stock.
1. If it is going to a lump sum value in the stock asset account then that account must be treated as the supplier.
2. If each individual supplier is going to be credited with the contra value of the stock, then a transfer of such values in each supplier account should be journal vouchered into the stock asset account.
The latter, though cumbersome, has the added feature of automatically getting in the cost price to the stock table directly.
For the former, the material_cost field in the stock_master table should be entered and the final open stock value computed (adjustments stock qty * material_cost) and put in to the stock asset account.
4,779 12/05/2014 03:58:55 am
Re: Install/Activate Extensions, Theme, Chart of Accounts not working (27 replies, posted in Installation)
Each PHP build, not necessarily based on version alone, will have different default php modules/extensions installed or enabled. A check on php -m would reveal all those available to it and a comparision will possibly reveal the lack of gzopen() function.
The PHP 5.5 gzopen() bug is quite well alluded to in stackoverflow.com and other public forums.
http://pear.php.net/bugs/bug.php?id=20246
http://ubuntuforums.org/showthread.php?t=2217927
https://bugs.launchpad.net/ubuntu/+source/php5/+bug/432291/comments/7
The bug is NOT zlib link problem because it can open gz files with "fopen" for example:
<?php
$gzfile = fopen("compress.zlib://hello.txt.gz", "w");
fwrite($gzfile, "hello world!");
fclose($gzfile);
?>is work well on released binaries. BUT "gzopen" is not defined in php5 binaries it cannot run:
<?php
$data = "Hello World!";
$gzfile = gzopen("hello.txt.gz", "w9");
gzwrite($gzfile, $data);
gzclose($gzfile);
?>
configure php with the --with-zlib=yes option and for 64 bit systems check if gzopen64() exists and possibly either do a search and replace in the FA code or create an alias function / wrapper for it:
http://stackoverflow.com/questions/23417519/php-zlib-gzopen-not-exists
https://wordpress.org/support/topic/php-function-is-disabled-abort-expected-gzopen-updraft
"because of large file support, gzopen() has been replaced by gzopen64()"
Link: http://www.dotdeb.org/2012/03/01/php-5-4-0-preview-packages/#comment-23656Looks like the gzopen() function is no longer available on new versions..
4,780 12/04/2014 09:07:30 am
Re: Need Salesman wise report (25 replies, posted in Reporting)
@joe: must this get into the core - ZONES => AREAS ?
4,781 12/04/2014 09:05:45 am
Re: Import of Paypal transactions (8 replies, posted in Banking and General Ledger)
You can hardcode the dot-slash coding inside the php script and allow the full filename with path to be put in there instead.
4,782 12/04/2014 09:03:21 am
Re: Invoices and Customer filter (5 replies, posted in Reporting)
Some partners may be busy with ongoing projects or moved on and hence the lack of response.
The current v2.3.22 mo file for German is available in the FA repo as a language pkg and is also available in extracted form in my unofficial GitHub repo.
You can also convert the mo to po file and then translate/modify it before recompilation and use.
4,783 12/03/2014 12:06:07 pm
Re: How to make FA wiki help ? (4 replies, posted in FA Modifications)
Refer Wiki page on config.php and the comments in the config.php file itself - self explanatory.
Search for the variable: $help_base_url
and read the comments around it.
4,784 12/03/2014 12:02:40 pm
Re: Invoices and Customer filter (5 replies, posted in Reporting)
You can still work your old 16/32 bit program in a virtual machine inside Win7 (VMWare Player, VirtualBox, QEMU/KVM, etc) on a (local) cloud.
Look at the invoice tables and you will see the invoice ids for filter ranges. Invoices must first exist.
4,785 12/02/2014 08:01:22 pm
Re: Invoices and Customer filter (5 replies, posted in Reporting)
For your first question, the customer filter is to set up a range of customer codes to print in a batch.
For your second question, I am unable to find the string "Print Invoices" hard coded anywhere in FA.
The only place in the file you referred to is line 95:
$reports->addReport(RC_CUSTOMER, 107, _('Print &Invoices'),This is to indicate that the Alt-I key combination can also be used to click the link.
Hence search for the string "Print &Invoices" in the appropriate translation file.
For your third question, you can hard code your strings in the code for a quick and dirty job.
4,786 12/02/2014 07:50:55 pm
Re: Pre-sales questions: time, bank sync, dimensions (2 replies, posted in Setup)
1) Use a Service Item with unit "hr"
2) Some extension is being developed for syncing with some banks - see the wiki main page links
3) Dimensions are generally independent but in practice they are used for Areas/Departments, Stores/Shifts hierarchical models as well. This way we can look at all entries of a single department across all Areas and those of a single Shift across all stores as well!
4,787 12/02/2014 07:31:16 pm
Topic: Invalid characters in stock_id (0 replies, posted in Items and Inventory)
Line 149 in inventory/manage/items.php states:
display_error( _('The item code cannot contain any of the following characters - & + OR a space OR quotes'));Actually the hyphen / minus ("-") character is allowed in Item Codes (stock_id). Also allowed is the underscore character ("_").
4,788 12/01/2014 01:24:41 pm
Re: HR and Payroll Module (66 replies, posted in Modules Add-on's)
The list of themes dished out of the FA repo does not include your "solution master" theme. See Attachment.
4,789 12/01/2014 02:03:47 am
Re: How to activate Custom Report (1 replies, posted in Reporting)
Install the extension.
Update the files of the extension from my unofficial GitHub Repo. The changes proposed via this file set was not accepted as it was considered an unsafe extension - which is better - an unsafe extension which works but is listed as unsafe or an extension that does not work - you decide.
Activate the extension for the target company.
In the target company, enable the access roles for the Admin for this extension.
4,790 12/01/2014 01:58:25 am
Re: HR and Payroll Module (66 replies, posted in Modules Add-on's)
@Farhaj: Which dead link did I provided in this thread?
@Farhaj: Your themes, if shared with @itronics, has yet to be placed in the official repo - this is what comes of not providing it via a GitHub fork and the limitations of sending it to a project email link!
@Farhaj: no one will ever try to sell it if it is openly available like on Github.
@serbanc: Please fork on GitHub and include your patches to the HR Module to make it workable.
4,791 11/29/2014 09:55:06 am
Topic: Rename theme greyred to grayred (0 replies, posted in Modules Add-on's)
The theme grayred is being erroneously distributed in the repo as greyred. This was reported by the fork Chia-KY of my unofficial github fork where it has now been committed.
Come fork (and join the 41 forks in place already - screenshot attached) and contribute!
4,792 11/28/2014 07:48:47 pm
Topic: Manual Bulk Import of Items (2 replies, posted in Items and Inventory)
The Wiki has been updated with raw SQLs (use after editing for appropriate company # and other specifics) to bulk import Items into FrontAccounting manually.
4,793 11/28/2014 04:09:43 pm
Topic: Single and double quote in Item Description (7 replies, posted in Items and Inventory)
Items like "Pipe 15 ft long" in the Item description displays fine. But if the abbreviation of feet as as an apostrophe / single quote is used, then it gets entered into the table as ' instead.
Hence the Item: "Pipe 15' long" now becomes "Pipe 15' long"
This is due to the way function db_escape() is programmed in includes/db/connect_db.inc.
function db_escape($value = "", $nullify = false)
{
$value = @html_entity_decode($value, ENT_QUOTES, $_SESSION['language']->encoding);
$value = @htmlspecialchars($value, ENT_QUOTES, $_SESSION['language']->encoding);
//reset default if second parameter is skipped
$nullify = ($nullify === null) ? (false) : ($nullify);
//check for null/unset/empty strings
if ((!isset($value)) || (is_null($value)) || ($value === "")) {
$value = ($nullify) ? ("NULL") : ("''");
} else {
if (is_string($value)) {
//value is a string and should be quoted; determine best method based on available extensions
if (function_exists('mysql_real_escape_string')) {
$value = "'" . mysql_real_escape_string($value) . "'";
} else {
$value = "'" . mysql_escape_string($value) . "'";
}
} else if (!is_numeric($value)) {
//value is not a string nor numeric
display_error("ERROR: incorrect data type send to sql query");
echo '<br><br>';
exit();
}
}
return $value;
}MySQL now has an builtin QUOTE() function that can now dispense with quoting / cleaning up any string to be entered through SQL directly.
The use of htmlspecialchars() is dictated by certain PHP environment settings:
' " ' (double quote) becomes '"' when ENT_NOQUOTES is not set.
" ' " (single quote) becomes ''' only when ENT_QUOTES is set. 4,794 11/28/2014 03:42:07 pm
Re: Tax rate in tax_group_items - where is it used? (2 replies, posted in Setup)
Thanks for the info Joe. That's a real time saver. When fields are considered redundant, we need to mention it in some place in the wiki.
4,795 11/28/2014 03:39:58 pm
Re: Significance of field sys_types.type_no (2 replies, posted in Setup)
Hence is it safe to ignore the type_no field in the #_sys_prefs table and assume the trans_no / type_no fields in invoices and other tables are independent of the value in the type_no field in the #_sys_prefs table?
4,796 11/28/2014 03:35:29 pm
Re: How to set inventory physical location (bin or shelf) (7 replies, posted in Items and Inventory)
Bin Location can be made as part of the Item Name but it will be subject to changes and will get reflected in the invoice. Even if it is part of the long_description field in the stock_master, it may possibly appear in some reports.
If the item_code field in the item_codes table is not used for UPC/EAN, then it can be used for Bin Location. This can be part of the foreign code naming then.
4,797 11/28/2014 02:09:42 pm
Topic: Tax rate in tax_group_items - where is it used? (2 replies, posted in Setup)
The field #_tax_group_items.rate does not seem to be used.
The field #_tax_types.rate seems to be used.
@joe please clarify.
4,798 11/28/2014 01:35:25 pm
Topic: Significance of field sys_types.type_no (2 replies, posted in Setup)
The table #_sys_types has 3 fields, viz., type_id, type_no, next_reference.
The first one - type_id - serves to be the input form field suffix for the form textbox input element's name attribute in Setup => Forms Setup.
The last one - next_reference - serves to be the next ID number available for a new record in the appropriately related table.
All references in sql statements in FA refer to only these fields in the WHERE clauses.
In includes/db/references_db.inc:
function save_next_reference($type, $reference) => Updates the next_reference field
function get_next_reference($type) => Obtains the next_reference field
In includes/systypes.inc:
function get_systypes() => "SELECT * FROM ".TB_PREF."sys_types";
Where does the middle field "type_no" get used in?
The function get_systypes() gets called in the file admin/forms_setup.php only and that too once for displaying the form and then for saving the form values.
There appears to be nowhere that the field type_no is used.
Does the sys_prefs.type_no have anything to do with the type_no and trans_no in various related tables?
case 31 refers to the non existent "service_orders" table in function get_systype_db_info() in includes/systypes.inc.
4,799 11/28/2014 07:29:44 am
Topic: Please help FA by filling up the wiki (0 replies, posted in Announcements)
Many Wiki pages may be outdated and / or lack sufficient screenshots and many are not filled in at all. Those users who implement FA afresh will go thru a learning curve which will be useful in remedying the lacunae / lack of information in the wiki.
Example of a page I have currently filled in is the Backup and Restore Wiki page for reference.
Culling out nuggets of information from the forum and appropriately cross referencing and placing them in the logical locations in the wiki will help everyone especially the newbies find the information easily instead of repeatedly asking for help in the forums.
Users are requested to volunteer for this huge effort that will also benefit from translations as well. This is a priceless contribution (beyond exchange rates based capability to pay) to the FA project that will surpass any donations in monetary terms that users provide (your monetary contributions are certainly valuable as it goes into sustaining the physical world costs of maintaining FA for all).
4,800 11/28/2014 05:31:57 am
Re: HR and Payroll Module (66 replies, posted in Modules Add-on's)
@itronics: The said project is not only stalled, the link is dead - returns a 404.
All new links have been updated in the wiki and the cache of your link is also provided for "last known" state. A Public Clone is available for forking as well.
Looks like @Farhaj is not quite done "covering basic expenses" since he has not released his code as yet, @itronics suggestion stands as the best GPL3 way forward.