3,176 Reply by apmuthu

(1 replies, posted in Installation)

Assume you are using a Windows desktop.
1. Install XAMPP for Windows.
2. Use a version that runs PHP 5.3.x, probably in the XAMPP v1.x series.
3. Install Frontaccounting after downloading the latest stable version into the XAMPP htdocs folder.
4. Refer the Wiki.

Go to forum: Installation

3,177 Reply by apmuthu

(44 replies, posted in Announcements)

Since you are interested in the Chinese language, it would be best if you install the latest Chinese Language Extension and then take it from there. Each language used by FA must be an element in the $installed_languages array.

I have an example for the Tamil language in my repo (recently updated) you can use for reference.

Go to forum: Announcements

3,178 Reply by apmuthu

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

Make a mockup of the final payslip printout pdf file and link it in here. We can then hammer out the tables needed. Highlight the data elements in different legend-ed colours for each of the following, data as pertinent to:
1. This pay slip instance only
2. All Pay Slips
3. This employee only
4. All such designations/pay scales
5. All such payment accounts

Only after the ERD as above is done, should we begin to make the module code and menu items.

Go to forum: Modules Add-on's

3,179 Reply by apmuthu

(1 replies, posted in Setup)

QNAP can host multiple websites. Setup a joomla instance in the QNAP device and then ftp the FA files into it instead of the joomla file and folder structure.

Go to forum: Setup

3,180 Reply by apmuthu

(1 replies, posted in Items and Inventory)

Different Item Codes in FA and in the Vendor supplies are available for matching along with appropriate unit conversion factors. On the Customer side, the FA Item code holds and there is no mapping available. You will have to make a custom module/extension for it with a table that stores FA_Item_Code/Stock_ID, Customer_ID/Debtor_Master_ID, Customer_Item_ID, Customer_Unit(if different), Unit_Conversion_Factor(if different unit).

Go to forum: Items and Inventory

3,181 Reply by apmuthu

(9 replies, posted in Wish List)

vQmod is an overhead that no production site would want unless you change themes frequently and have a need to do so.

"vQmod™" (aka Virtual Quick Mod) is an override system designed to avoid having to change core files. The concept is quite simple... Instead of making changes to the core files directly, the changes are created as xml search/replace script files. These script files are parsed during page load as each "source" core file is loaded with the "include" or "require" php functions. The source is then patched with the script file changes, and saved to a temp file. That temp file is then substituted for the original during execution. The original source file is never altered. This results in a "virtual" change to the core during execution without any actual modification to the core files.

Any such integration should be for future versions and that too in theme developer mode.

Go to forum: Wish List

3,182 Reply by apmuthu

(3 replies, posted in Setup)

You can use either a hard coded approach (Quick and Dirty) or change the encoding of all the php files to be in the utf-8 character set.

Go to forum: Setup

3,183 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,184 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,185 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,186 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,187 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,188 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,189 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,190 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,191 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,192 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,193 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,194 Reply by apmuthu

(7 replies, posted in Reporting)

Answered in this thread.

Go to forum: Reporting

3,195 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,196 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,197 Reply by apmuthu

(13 replies, posted in Setup)

Updated Wiki with the Tax Inclusion info.

Go to forum: Setup

3,198 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,199 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,200 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