2,151

(7 replies, posted in Report Bugs here)

Since you have pressed the upload button without selecting any flie to upload, the error arises. Hence change line 169 in admin/backups.php:

if (get_post('upload'))

to be:

if (get_post('upload') && isset($_FILES['uploadfile']) && array_key_exists('tmp_name', $_FILES['uploadfile']))

When you buy for yourself (non stocked items like hosting) directly take it into expenses.
If these are stocked items then issue to your expenses account or have an own use customer with no tax.

2,153

(1 replies, posted in Setup)

Browser cache? Logout and login again and see your error logs in FA/tmp/ and in WebServer (eg., Apache) logs.

2,154

(5 replies, posted in Report Bugs here)

Check in the company/#/pdf_files if the pdfs are generated and saved there. Then check the browser preferences for display of PDFs / popups for the domain.

2,155

(30 replies, posted in Fixed Assets)

Precisely that - enter the fixed assets into FA first. Enable those permissions in the Setup => Roles for the user role you want those permissions for, logout and then login again and the said use with the appropriate role will be able to create fixed assets.

(100 * 5) / 105 = 4.76%

2,157

(3 replies, posted in Translations)

https://frontaccounting.com/fawiki/index.php?n=Help.InstallUpdateLanugages
https://frontaccounting.com/fawiki/index.php?n=Main.Usage

@joe: any Standard Operating Procedure for this in FA?

A really "kludgy" workaround is to duplicate the company stanza in config_db.inc file and put in a different user / password with restricted credentials! Alternatively, hack the save() function for the cart and/or tweak the insert statements for adding in a where clause to see if the session current_user is either admin or matches the record owner.

Otherwise, post your bounty in the Job Offers board with a clear description of what you want.

Sell it to the charity at 0 cost or 100% discount.

FA allows all locations to sell all products. If you want to restrict items sold at each shop, setup a separate POS for each shop outside of FA and import transactions into FA or make a separate extension for the same. Warehouse locations may be a filter that might be useful.

2,161

(6 replies, posted in Reporting)

@joe: can the wiki notes be clarified?

2,162

(6 replies, posted in Reporting)

Refer any report where you find a centered field and provide screenshot. We can then trace what works for alignment in Arabic.

2,163

(6 replies, posted in Reporting)

Read the Wiki.

2,164

(6 replies, posted in Reporting)

If you center the amounts in the body of the invoice, they will not align correctly for the decimal places. But if you still want it, then amke line 61 of reporting/rep107.php:

    $aligns = array('left',    'left',    'right', 'center', 'right', 'right', 'right');

to be:

    $aligns = array('left',    'left',    'right', 'center', 'right', 'right', 'center');

The top summary table has it's elements already center aligned in the English version - see attachment. The values in it are populated in the $aux_info array in reporting/includes/doctext.inc file.

The file reporting/includes/header2.inc that the invoice report uses aligns the values in it's lines 167-175 ('C'):

        foreach($aux_info as $info_header => $info_content)
        {

            $this->row = $iline2 - $this->lineHeight - 1;
            $this->TextWrap($col, $this->row, $width, $info_header, 'C');
            $this->row = $iline3 - $this->lineHeight - 1;
            $this->TextWrap($col, $this->row, $width, $info_content, 'C');
            $col += $width;
        }

2,165

(1 replies, posted in Reporting)

State what report in FA closely resembles the one you want and provide a screenshot of a mockup of your target report.

2,166

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

This is a very important extension for FA and should have been built into the core as export/import are the important integration hooks for other applications to exchange data.

@itronics: please update the pkg repo accordingly.

The Unicenta/OpenBravo POS is a compiled application for Windows/Linux/MacOS etc and is currently at v4.1. The database is at v3.91.3 and uses the Apache Derby DB by default. It can be configured to use MySQL database among others, but no public MySQL schema for it is commonly available. Make a set of unitary transactions in Unicenta POS and at each execution list the database changes that have occurred with respect to the actual transactions done that you want to port to FA. Then use and possibly extend the SlimREST API for FA as desired.

The user input control functions that provide the dropdown select box php code should not get confused and the search delimiters should not be ambiguous. URL encoding too will convert space to "+".

We can also add the back tick character to the forbidden list it as well - "`". A semicolon too may be added to the list.

Here is an elegant way to check a string for presence of any character in an array:

$arrayOfBadCharacters =array(' ', "'", '"', '+', '&', chr(9), chr(10), chr(13), '`', ';');
$chars = preg_quote(implode('', $arrayOfBadCharacters));
if(preg_match('/['.$chars.']/', $_POST['NewStockID']) {
    // bad character(s) found
}  

These bad characters may be stripped off and the code used instead of throwing an error.

2,169

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

The direct Sales Invoice Imports works as per attachment.

@joe: can now commit it to official pkg repo.

2,170

(22 replies, posted in Accounts Receivable)

The addition af a nice POS into FA would make it very usable for the retail segment. Nevertheless, there are many dedicated POS systems with great advancements in it's development that to replicate the effort here would dilute the offering as voluntary maintainers with core skills and interests are hard to find and would be spread thin for it to be sustainable. Hence the need to natively integrate with an FA connector to popular Open Source POS applications.

A rudimentary POS in FA is the Direct Invoice entry screen. With a proper native FA RestAPI in place, integration with any POS by building a connector would become relatively easy.

@boxygen: nice corollary.
@joe: can commit.

2,172

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

The sales document types were missing for processing them. They have now been added.
Possible errors that may still remain are the fixed asset parameter in FA 2.4 for adding an invoice though a synch with the core cart class has been done.
The core may not yet have to be modified to degrade gracefully if the results of these changes demonstrate.

2,173

(2 replies, posted in Installation)

If you have different databases for each company, then there is no need to change the table prefix. Just put in the correct prefix into the company_db.inc file for the specific company's array element before usage.

2,174

(27 replies, posted in Accounts Receivable)

The Direct Invoice entry would suit such Cash entries with the Credit Card info in the memo with a pdf attached as a document to it. Possibly modify it for another menu link by hardcoding a Direct Credit Card Invoice entry.

Better still, use a POS and import transactions into FA.

2,175

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

@joe: Thanks for the commit.