3,126 Reply by apmuthu

(44 replies, posted in Announcements)

Hope you compiled the *.mo file in utf-8. The C language is generally in iso-8859-1 as the original gettext strings in the code are in that language.

Go to forum: Announcements

3,127 Reply by apmuthu

(45 replies, posted in Modules Add-on's)

There is no reference to the Employee ID in the "payslip_details" table yet which may be in the "payslips" table which has not been defined yet.

Go to forum: Modules Add-on's

3,128 Reply by apmuthu

(7 replies, posted in Reporting)

What is the input you are providing to extract the related "loc_code"?

The "loc_code" is looked up in the "locations" table to get the "location_name".
The "stock_moves" table records the "loc_code" for the transaction.
The "loc_stock" table records the "loc_code" where an item is stocked.

Go to forum: Reporting

3,129 Reply by apmuthu

(45 replies, posted in Modules Add-on's)

An ERD of the new tables (schema) that will be used in the extension should be set out for reference.

Go to forum: Modules Add-on's

3,130 Reply by apmuthu

(2 replies, posted in Modules Add-on's)

The install link must first be clicked and then the activation must be done for the company intended. The administrator and other users in the company (for which the extension was activated) should have their roles and permissions appropriately set.

Go to forum: Modules Add-on's

3,131 Reply by apmuthu

(1 replies, posted in Items and Inventory)

The "type", "trans_type" fields are the ones that mapped to those in the "types.inc" file. The "trans_no" is the transaction number. Refer the ERD in the Wiki.

Go to forum: Items and Inventory

3,132 Reply by apmuthu

(6 replies, posted in Items and Inventory)

At the close of the year, you should have a list of negative inventory items that you need to account for since your vendor has not invoiced you yet. This list of negative inventory items have actually been supplied by the vendor but stands to be invoiced. You can pass the necessary Supplier Invoices for such inventory as if you have received the invoices, with a note in the memo part to indicate the invoice status.

As in your case, this routinely happens, you can enter the supplier invoice when the goods arrive and then you can invoice your customer for the goods sold. When the vendor's invoice finally arrives, the reference numbers and memo updates can be done.

Go to forum: Items and Inventory

3,133 Reply by apmuthu

(12 replies, posted in Accounts Receivable)

Either you use your own page counter variable in the report file and increment it just before each AddPage() (or FA's NewPage()) or use TCPDF's (reporting/includes/tcpdf.php) page variables ($page is the class property for the current page number, $pages is an array of the pdf pages) that the FA reporting engine uses.

Whilst $this->pageNumber is correct, the $this->totalPageNumber is not used in FA.

As the pdf generation progresses, the max number of pages in the document till then is $this->getAliasNbPages().

Go to forum: Accounts Receivable

3,134 Reply by apmuthu

(3 replies, posted in Setup)

You need to be logged in as the said user before it can get it.

The said function is defined in lines 489-493 of includes/current_user.inc

function user_theme()
{
    return isset($_SESSION["wa_current_user"]) ?
        $_SESSION["wa_current_user"]->prefs->get_theme() : 'default';
}

Go to forum: Setup

3,135 Reply by apmuthu

(1 replies, posted in Jobs wanted/offered, non-free offers)

It is already available in the wiki - look at the section - Add Page to Report.

You can have a generic PDF included into the invoice. Alternatively, you can have a link in the Invoice pointing to a PDF file hosted at your site. Use the TCPDF page number variables at will in the report.

Go to forum: Jobs wanted/offered, non-free offers

3,136 Reply by apmuthu

(1 replies, posted in Translations)

You need to choose the display language for the logged in user or as default for the company.

Go to forum: Translations

3,137 Reply by apmuthu

(7 replies, posted in Reporting)

Answered in this thread.

Go to forum: Reporting

3,138 Reply by apmuthu

(1 replies, posted in Modules Add-on's)

https://frontaccounting.com/punbb/viewtopic.php?id=5169
https://frontaccounting.com/punbb/misc.php?action=pun_attachment&item=211&download=1
https://frontaccounting.com/punbb/viewtopic.php?id=6623

Go to forum: Modules Add-on's

3,139 Reply by apmuthu

(7 replies, posted in Reporting)

The reporting/rep107.php report file outputs the Invoice with the column formatting in $cols and $aligns arrays. The reporting/includes/doctext.inc file (included in the report file indirectly) populates the variable $aux_info with the necessary elements at line 104 - case ST_SALESINVOICE:.

Go to forum: Reporting

3,140 Reply by apmuthu

(13 replies, posted in Setup)

Updated Wiki with the Tax Inclusion info.

Go to forum: Setup

3,141 Reply by apmuthu

(1 replies, posted in Setup)

FA provides Roles that can be used to provide specific modules access to any user assigned  to the specific role.
However, out of the box, FA does not support segregation of POS to specific salesman - this means that if a Salesman is assigned to a POS, he can operate on any POS location. One or more POS are assigned to a specific location. But one POS cannot be assigned to more than one location at a time.

Go to forum: Setup

3,142 Reply by apmuthu

(16 replies, posted in Installation)

As this is specific to very few installs, please use the suggested workaround in the 12th post in this thread referring to includes/session.inc file.

Go to forum: Installation

3,143 Reply by apmuthu

(12 replies, posted in Banking and General Ledger)

@cambell: Your commit is quite nice. You might want to restrict the use of the TB_PREF to the FROM table alone and not in the other parts of the select statement. The WHERE clause can check for on or before instead of just before date.

$sql = "SELECT supp_trans.trans_no,
       supp_trans.type,
       supp_trans.supplier_id,
       supp_trans.tran_date,
       supp_trans.ov_amount,
       bank_trans.ref AS bank_ref,
       bank_trans.amount AS bank_amount,
       bank_accounts.id AS bank_id,
       bank_accounts.bank_name,
       bank_accounts.bank_account_name,
       bank_accounts.bank_curr_code 
FROM " . TB_PREF . "supp_trans supp_trans INNER JOIN 
     " . TB_PREF . "bank_trans bank_trans ON (supp_trans.trans_no = bank_trans.trans_no 
                                   AND supp_trans.type=bank_trans.type) INNER JOIN 
     " . TB_PREF . "bank_accounts bank_accounts ON (bank_trans.bank_act = bank_accounts.id)
WHERE supp_trans.supplier_id=" . $supplier_id . "
  AND supp_trans.tran_date <= '" . $date . "' 
  AND supp_trans.type=" . ST_SUPPAYMENT . " 
ORDER BY supp_trans.tran_date DESC 
LIMIT 1";

@joe: Want to pull it in?

Go to forum: Banking and General Ledger

3,144 Reply by apmuthu

(6 replies, posted in Report Bugs here)

No customisation, no extensions.
Plain vanilla install of FA 2.3.25+ from official GitHub Master.
en_US-demo.sql - CoA with US demo data.

Test Environment:
Server and client (localhost) on WinXPSp3, XAMPP 1.7.3 having:
MySQL Server & Client version: 5.1.41
Apache/2.2.14
PHP Version 5.3.1
Browser FireFox v37.0.2

This change is important as there could be some instances where during some var scope / js / function execution, the value of a POSTed checkbox variable is set to 0 as would obtain when "cleaning" of POST variables occur. In such an instance, mere checking for the existence of the POST variable would be insufficient, it's value must be 1 (for single checkbox value as prevalent in all if not most of FA) or some pre-set value (some have the audacity to make it -1 when not chosen) and at the very least, that, if present, it should be checked if (not) zero.

Since no change is effected on the POSTed checkbox variable by the code using this function, please let me know how batch invoicing / delivery processing would be affected - do they change the value of the POSTed checkbox variable?

Go to forum: Report Bugs here

3,145 Reply by apmuthu

(6 replies, posted in Report Bugs here)

Fixed in my repo.

Go to forum: Report Bugs here

3,146 Reply by apmuthu

(6 replies, posted in Report Bugs here)

@joe: Please fix in both versions.

Go to forum: Report Bugs here

3,147 Topic by apmuthu

(6 replies, posted in Report Bugs here)

Try this:
Setup => Company Setup => Save

Even though the checkbox "Delete Company Logo" is unchecked and there is no change in the logo file that exists, the changes in other fields do not get saved and the error: The existing image could not be removed arises.

This is due to the fact that the function check_value() only checks if the checkbox element exists in the $_POST and not if it's value is set to 1 - some browsers (versions) and windows OSes tested in FA 2.3.x (test on other combinations and even in FA 2.4.x for corrections like this) need the said function in includes/ui/ui_input.inc:

function check_value($name)
{
    if (!isset($_POST[$name]))
        return 0;
    return 1;
}

to be

function check_value($name)
{
    if (!isset($_POST[$name]) || !$_POST[$name])
        return 0;
    return 1;
}

0 is generally evaluates false and if 1 is the value of a ticked checkbox enforced throughout FA, then a NOT check of 1 can be used.

In fact, a very thorough check to accomodate unlike variable type comparisions would entail:

function check_value($name)
{
    if (!isset($_POST[$name]) || ($_POST[$name]+0) === 0)
        return 0;
    return 1;
}

Go to forum: Report Bugs here

3,148 Reply by apmuthu

(8 replies, posted in Accounts Payable)

Setup -> Payment Terms.

The Wiki link in the 2nd post in this thread has a typo.

Go to forum: Accounts Payable

3,149 Reply by apmuthu

(6 replies, posted in Accounts Payable)

Direct Invoice should create a Sales Order and on Delivery, the Invoicing occurs. Hence payment is a separate entry for such tracking.

Go to forum: Accounts Payable

3,150 Reply by apmuthu

(3 replies, posted in FA Modifications)

Shipping can be used for the excess and worded so or transferred by JV.

Go to forum: FA Modifications