Search options (Page 175 of 247)

@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:

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

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?

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?

Try to mock up a report image and post it or state what changes would you want to see in a similar report.

Create a batch Invoice. Refer the Wiki.

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.

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']);

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.

First of all the UK Chart of Accounts is broken if taken from the official pkg repo. After installing it from there, just update the en_GB-general.sql file from my GitHub Repo. Just upload the said sql file overwriting the one in the sql folder and then create your UK company. Let your default company be created with the en_US-new.sql and your actual company be created with the new UK sql file.

When entering your items, just choose Tax Exempt for now. When you get to qualify for VAT, then change the settings to Tax in the items. All the old invoices will remain in their Non Tax state.

Look at what broke in modifying the report - use a diff tool like say WinMerge - mostly syntax errors, missing variables/objects, missing arguments, scope, etc. Check the apache error logs and the FA error logs as well.

There are quite a few placed where D is hard coded in the core and in the extension files.

A brief history of mb_flag changes:

2014-09-12: Removed redundant mb_flag 'A'.
2009-05-18: Added mb_flag 'M' in demand checks
2009-05-17: Removed obsolete 'K' mb_flag checks.

Extensions having mb_flag and referencing 'D' or 'S':

Extensions/api/sync_db.inc : Lines 393, 418, 1069, 1109, 1152 => D
Extensions/import_items/import_items.php : Line 246 => S
Extensions/import_items/readme.txt : Line 111, 163 => S

Core files having mb_flag and referencing 'D' or 'S':

includes/data_checks.inc : Line 333 => D
includes/manufacturing.inc : Line 27 => D
includes/db/inventory_db.inc : Line 114 => D
includes/ui/ui_lists.inc : Lines 915, 924 => D
manufacturing/work_order_add_finished.php : Line 139 => D
reporting/rep301.php : Line 113 => D
reporting/rep307.php : Line 40 => D
reporting/rep308.php : Line 70 => D