Is the FA v2.3.19 patch in the attached file sufficient to now port to FA v2.3.22+?
4,327 03/07/2015 12:50:38 pm
Re: BACKUP FILE (9 replies, posted in Setup)
Lines 506 to 513 of admin/db/maintenance_db.inc:
$res = db_query("show table status");
$all_tables = array();
while($row = db_fetch($res))
{
if (($conn["tbpref"] == "" && !preg_match('/[0-9]+_/', $row['Name'])) ||
($conn["tbpref"] != "" && strpos($row['Name'], $conn["tbpref"]) === 0))
$all_tables[] = $row;
}
gets the list of tables to be exported into the array variable $all_tables. Now all you need to do is to remove the table names you do not want from them.
To do so, after the above code insert the following:
if (($key = array_search($conn["tbpref"].'users', $all_tables)) !== false) {
unset($all_tables[$key]);
}
if (($key = array_search($conn["tbpref"].'security_roles', $all_tables)) !== false) {
unset($all_tables[$key]);
}
4,328 03/07/2015 12:37:46 pm
Re: How to add Item's Old Sales Price and New Sales Price? (5 replies, posted in Items and Inventory)
Edit your CoA sql file in a code editor like NotePad++ and set the encoding to "Encode in UTF-8 without BOM". See attachment. Then fill in the "?" with the appropriate symbols and use them in FA.
4,329 03/07/2015 12:29:26 pm
Re: Sales return, purchage return and invoice. (5 replies, posted in Items and Inventory)
Goods Return Voucher (Journal) or edit Sales/Purchase Order.
4,330 03/07/2015 12:18:17 pm
Re: Adding item that isn't in items list... (3 replies, posted in Accounts Payable)
Adding items on the fly is done by pressing F4 key when entering a Direct (Supplier) Invoice or Purchase Order Entry.
4,331 03/04/2015 02:36:20 pm
Re: Work Orders (7 replies, posted in Manufactoring)
Manufacturing => Outstanding Work Orders
Pressing the '#' sorts the Work_Order IDs.
@joe: how does this fix @touchman's issue?
Rewards: if you support FA users, you can cruise ..... Have a nice time.
4,332 03/04/2015 08:46:12 am
Re: Batching Invoice against Sales Delivery (8 replies, posted in Accounts Receivable)
I hope you used the last method instead of hacking the code.
4,333 03/03/2015 07:36:59 pm
Re: Plug-in Tax Inquiry - Cash Basis reports incorrect input tax (11 replies, posted in Reporting)
@joe: this needs to be corrected.
4,334 03/03/2015 07:21:11 pm
Re: Batching Invoice against Sales Delivery (8 replies, posted in Accounts Receivable)
@joe: maybe we need to remember the ticks of the previous page in the session variables before going to the next page.
Try to increase the number of items to say 20 or more. Try changing line 207 in sales/inquiry/sales_deliveries_view.php:
$table =& new_db_pager('deliveries_tbl', $sql, $cols);
by hardcoding it to
$table =& new_db_pager('deliveries_tbl', $sql, $cols,,20);
The function new_db_pager() is defined in includes\db_pager.inc at line 482 with the following prototype:
function &new_db_pager($name, $sql, $coldef, $table = null, $key = null, $page_len = 0) {
If the default $page_len is left as zero (0), then the #_users.query_size field's value (default 10) is taken.
It can also be set in Setup => Display Setup (Preferences) => Query page size:
4,335 03/03/2015 07:04:02 pm
Re: Sales Summary Report extension (4 replies, posted in Wish List)
Get image post rights from @joe or upload it elsewhere and paste the link here.
The current age analysis tool can be modified to change the sort order to get what you want.
4,336 03/03/2015 03:00:58 pm
Re: Sales Invoice Print (1 replies, posted in Reporting)
For different Page Sizes in FA, refer this forum post besides the Wiki.
4,337 03/03/2015 02:45:57 pm
Re: Work Orders (7 replies, posted in Manufactoring)
@touchman: duplicate post here.
@joe: Where is the '#' label to press?
4,338 03/03/2015 02:40:48 pm
Re: Issuing additional items to WO (5 replies, posted in Manufactoring)
Lines 101 to 106 in manufacturing/work_order_issue.php are:
$failed_item = $_SESSION['issue_items']->check_qoh($_POST['Location'], $_POST['date_'], !$_POST['IssueType']);
if ($failed_item != -1)
{
display_error(_("The issue cannot be processed because it would cause negative inventory balance for marked items as of document date or later."));
return false;
}
Try to comment out the above lines and see how it proceeds.
@joe: any variable scope and visibility issues?
4,339 03/03/2015 02:33:53 pm
Re: Dimensions in Purchase Order (5 replies, posted in Dimensions)
@joe: Should the PO form include a Dimension field to get it's default from the Supplier and have it selected / changed by the user?
4,340 03/03/2015 02:17:30 pm
Re: Disable editing of Price before Tax on Direct Sales Invoice (1 replies, posted in FA Modifications)
When a Direct Invoice is made by your POS employees, if the price before tax is not editable, then the standard price will apply and the invoice can then not be edited. The account manager can make invoices with these values being editable before making the invoice but the manager would still not be able to edit these values in an invoice created by the POS employees as it would then affect other tables. Check out the User roles and access permissions for the POS employees envisaged.
@joe: There is no specific "Price Before Tax Edition" permission as of now and if it is wanted it needs to be hacked in - wanna do it?
4,341 03/03/2015 02:03:19 pm
Re: Same item with different sales tax (4 replies, posted in Items and Inventory)
@zunixaani: nice suggestion. A new topic would be better to post it in.
@joe: want to hack it in as a hardcoded subset of Direct Invoice?
4,342 03/03/2015 01:59:02 pm
Re: Sales Summary Report extension (4 replies, posted in Wish List)
Try to mock up a report image and post it or state what changes would you want to see in a similar report.
4,343 03/03/2015 01:56:07 pm
Re: 2.3 - Extensions. How ? (13 replies, posted in Modules Add-on's)
There is no official payroll extension in FA as yet. Where did you get the clone? If it is made for an older version of FA, you will have to adjust it for FA 2.3.x
4,344 03/03/2015 01:52:01 pm
Re: Batching Invoice against Sales Delivery (8 replies, posted in Accounts Receivable)
Create a batch Invoice. Refer the Wiki.
A batch invoice, a single invoice created from multiple work orders/deliveries, can be processed if all items have been sent to the same location. Click the check-box beside each delivery and click the Batch button at the top of the column to make such an invoice.
4,345 03/03/2015 01:49:15 pm
Re: Advanced and Assembly Manufacturing Different (1 replies, posted in Manufactoring)
The said wiki page is quite clear. The Simple Assembly is done in one shot and the Advanced Assembly is done in a sequential process with multiple entries for each step.
4,346 03/03/2015 01:33:46 pm
Re: change header in report ...!! (3 replies, posted in Reporting)
Copy the original reporting/includes/header2.inc to company/#/reporting/includes/header2.inc and edit the latter to suit your needs. Now place a copy of the reporting/rep112.php file (Print Receipts) into the company/#/reporting folder to have those reports alone use the new header2.inc.
4,348 03/03/2015 01:19:19 pm
Re: How to amend Purchase Order PDF (2 replies, posted in Accounts Payable)
Which version of FA are you on? Your "==" should be "!=".
Also $Addr2 will always be an array and be available and you are comparing an array to a scalar value.
Where do you get 'NA' for the value of $Addr2 ?
Lines 160 to 164 currently are:
// address2
$this->row = $temp;
$this->Text($mcol, $Addr2['name']);
$this->NewLine();
$this->TextWrapLines($mcol, $this->rightMargin - $mcol, $Addr2['address']);
and the change you probably you wanted is:
// address2
$this->row = $temp;
// Added by Steve to not print company name if N/A
if ($Addr2["name"] != "") {
$this->Text($mcol, $Addr2['name']);
$this->NewLine();
}
$this->TextWrapLines($mcol, $this->rightMargin - $mcol, $Addr2['address']);
4,349 03/03/2015 01:02:10 pm
Re: HR and Payroll Module (66 replies, posted in Modules Add-on's)
This rendering of the HR and Payroll is @Farhaj's closed source version he is trying to sell. Checkout the last known open source version cloned at GoogleCode.
4,350 03/03/2015 12:47:00 pm
Re: osCommerce Order and Customer Import Module (8 replies, posted in Modules Add-on's)
TYPE keyword is depreciated (since MySQL v5.0) and not supported in MySQLv5.5.
Replace TYPE=MyISAM with ENGINE=MyISAM
@Alan: nice catch
Get the amended file from the commit in my GitHub Repo.