Search options (Page 5 of 5)

The Backup and Restore function works on the database.
So what happens to attached documents? Are these saved in the database as well (as blobs)? If that is the case the no problem. On the other hand, if such documents are not saved in the database, then one has to backup the company folder as well. These are located in fa/company/xx where xx is a number starting at  0, 1, 2, etc.

Now I am assuming that the attachments are left in the folder fa/company/xx/attachments. And that the table xx_attachments only points to this location.

So let's say I have been backing up my companies on a regular basis and writing my backups to DVD for quite some time. What happens when a company is deleted? The folder of the company is changed.

Now all my backups point to the wrong folder. Sometimes it happens that I want to go back six months or even a year. Restoring old backups may ruin current companies.

My suggestion: For each and every new company create a new database. (see my other post elsewhere for modifying fa to do just that). But most importantly, create the company in a folder with the same name as the database. This way, all company details remain the same, throughout the lifetime of the company.

Also, when deleting a company, make sure to delete the folder AND drop the database.

What say you?

When sharing the same database for different companies, there exists the possibility that a user of one company maliciously overwrites the data of another company. To eliminate this risk, one has to use a different database for each company.

I have eased the process this way:

in fa/admin/create_coy.php add the following code:

function rand_string( $length ) {
    $chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";   

    $size = strlen( $chars );
    for( $i = 0; $i < $length; $i++ ) {
        $str .= $chars[ rand( 0, $size - 1 ) ];
    }

    return $str;
}

then CHANGE the following lines:
        else
        {
                $_POST['tbpref'] = $tb_pref_counter."_";
                // Insert the current settings as default
                $conn = $db_connections[user_company()];
                $_POST['name'] = '';
                $_POST['host']  = $conn['host'];
                $_POST['dbuser']  = $conn['dbuser'];
                $_POST['dbpassword']  = $conn['dbpassword'];
                $_POST['dbname']  = $conn['dbname'];
        }

TO:

        else
        {
                $_POST['tbpref'] = $tb_pref_counter."_";
                // Insert the current settings as default
                $conn = $db_connections[user_company()];
                $_POST['name'] = '';
                $_POST['host']  = $conn['host'];
                $_POST['dbuser']  = $conn['dbuser'];
                $_POST['dbpassword']  = $conn['dbpassword'];
                $_POST['dbname']  = rand_string(8);             //$conn['dbname'];
        }

This would put a random 8 character string in the database name every time a new company is about to be created. One can always overwrite what is presented.

Can we have this included in the next release?

TAX Inquiry shows proper amounts for all TAX percentages except for the 0% (Exempt) TAX.

Hello,

When filling the VAT Return, one has to fill in the amount of sales and purchases of items and services that have a 0% VAT, also, in a separte location one has to fill the amounts of Intra EU and Out of EU 0% VAT amounts.

In my setup under Tax Types, I created two different 0% VAT (TAX) types and each is linked to a different GL Account.
Then I created relevant TAX Groups as well and also created Item Tax Types.

Then I created Items that use one or the other of the 0% VAT Types.
After issuing some invoices, I issued the TAX report, but the 0% VAT entries (amounts) remain 0.00

What am I missing?
Thanks and regards
Carmelo