4,326

(44 replies, posted in Reporting)

Is the FA v2.3.19 patch in the attached file sufficient to now port to FA v2.3.22+?

4,327

(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]);
}

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.

Goods Return Voucher (Journal) or edit Sales/Purchase Order.

Adding items on the fly is done by pressing F4 key when entering a Direct (Supplier) Invoice or Purchase Order Entry.

4,331

(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.

I hope you used the last method instead of hacking the code.

@joe: this needs to be corrected.

@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

(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

(1 replies, posted in Reporting)

For different Page Sizes in FA, refer this forum post besides the Wiki.

4,337

(7 replies, posted in Manufactoring)

@touchman: duplicate post here.

@joe: Where is the '#' label to press?

4,338

(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

(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?

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?

@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

(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

(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

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.

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

(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,347

(16 replies, posted in Wish List)

Wiki-ed it

4,348

(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

(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.

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.