4,551

(3 replies, posted in Installation)

Execute the following commands as root (sudo):

BASEDIR=/var/www/html
chown -R www-data:www-data ${BASEDIR}
find ${BASEDIR} -type f -exec chmod 644 \{\} \;
find ${BASEDIR} -type d -exec chmod 755 \{\} \;

Make sure that no config.php or config_db.php file exists to start with.

4,552

(22 replies, posted in Reporting)

Which version of FA are you using. What are your client and server platforms and versions of php/mysql used? What collation is your database on? You might be getting utf-8 and latin1 mixed up.

4,553

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

And possibly their content as well. Any reason for rejection of hook patch?

4,554

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

Doesn't the pkg install the various files to patch the FA? If so, the textcart documentation in the wiki may need updation.

I have just updated in my GitHub repo with the new rep_email_customers extension from it's official Git repo.

It is however not yet in the offical pkg repo.

Anyone tested it?

4,556

(21 replies, posted in Setup)

Lookup the reference code at lines 191 to 212 in reporting/includes/header2.inc:

        // Footer
        $this->Font('italic');
        $this->row = $iline7 - $this->lineHeight - 6;

        foreach ($Footer as $line => $txt)
        {
            if (!is_numeric($line))    // title => link
            {
                $this->fontSize -= 2;
                $this->TextWrap($ccol, $this->row, $right - $ccol, $line, 'C');
                $this->row -= $this->lineHeight;
                $this->SetTextColor(0, 0, 255);
                $this->TextWrap($ccol, $this->row, $right - $ccol, $txt, 'C');
                $this->SetTextColor(0, 0, 0);
                $this->addLink($txt, $ccol, $this->row, $this->pageWidth - $this->rightMargin, $this->row + $this->lineHeight);
                $this->fontSize += 2;
            }
            else
                $this->TextWrap($ccol, $this->row, $right - $ccol, $txt, 'C');
            $this->row -= $this->lineHeight;

        }

For a specific company you can place an override in the company/#/reporting/reporting/includes/header2.inc file for which you may use the original reporting/includes/header2.inc as a template to start with.

Actually, according to the wiki, the Direct Invoice is the one that combines Sales Order, Delivery and Invoicing into one step. Direct Delivery just bunches the Sales Order and Delivery together.

4,557

(21 replies, posted in Setup)

Generally in any ERP (as opposed to normal accounting software), a certain workflow is standard - delivery and invoicing are separate functions and need to be done by different entities (roles - same person can don several roles).

The Direct Delivery has been made available for such simple situations as yours and to simulate functionality of normal accounting software for new users to gain traction quickly in familiar operations. In actuality, the Invoicing and all GL entries are made as if a Sales Order was generated and then Invoiced and then Delivered in the Direct Invoice! In the case of Direct Delivery only the Sales Order and Delivery are bunched together.

Limiting invoicing items to 10 or any other hardcoded number is not advisable for the form elements as paging is done on printing only and it is best left to the user's choice depending on how much text is desired to be input for printing at the end of the items. If however your terms and conditions is a fixed text display, you may want to place it in small font and possibly in the invoice footer.

4,558

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

Compare your module files with those in my GitHub repo. There was a commit I made on 2013-11-08 there that has not yet been assimilated into the official packages. It pertains to the file  modules/textcart/purchasing/po_entry_items.php.

Replace line 532

$textcart_mgr->tab_display('', &$_SESSION['PO'], "display_order_in_tab");

with

$textcart_mgr->tab_display('', $_SESSION['PO'], "display_order_in_tab");

4,559

(48 replies, posted in Setup)

Today's developments in FA v2.4:

The config.default.php in FA 2.4 will now be holding all the defaults and only changes in the variable values need to be stored in the config.php unlike the monolithic config.php in earlier versions.

4,560

(21 replies, posted in Setup)

Delivery is part of the Sales (orders) tab. The Access Roles permissions page for Sales tab functions has only the following feature roles:

Sales configuration:    
Sales types    
Sales prices edition    
Sales staff maintenance    
Sales areas maintenance    
Sales groups changes    
Sales templates    
Recurrent invoices definitions

All Direct Sales Delivery have the Sales Orders and Invoicing done automatically in the background and hence choosing to disable them (other than in the menu items) would lead to unknown configuration state. Just do not use them then.

If in the file, applications/customers.php, you comment out lines 19 and 20 you will find the Sales Quotation Menu link missing in the Sales tab in FA.

Look at the version.php file - the official repo is listed there. You can override it with your own values for the same variables in config.php. Search the forum for how to run your own pkg repo. @garrapato led such a discussion once.

4,562

(21 replies, posted in Setup)

Is that needed even for Sales => Direct Delivery?

4,563

(5 replies, posted in Reporting)

Alann Toh from Malaysia made a few requests that may be nice if added to the FA core:

  • In reports, I would like to have page numbering x of y pages instead of only page x

  • would also like to add Attn : contact_name auto derived from branch_person / contact_name and editable during invoice input by having a text box

  • A discount textboxt at direct invoice before shipping

On checking out the PDF generation classes and the bridge functions between the older FPDI and the new TCPDF, we find that the Header3() method in excel_report.inc and pdf_report.inc (that uses the Total Number of Pages in PDF data is not used in any of the reports.

Other features of the Info() method in these files too don't go beyond using the first 4 arguments in the report files whereas, the $companylogoenable$footerenable and $footertext arguments provide for additional functionality that obviates the need for repetitive coding in the reports. The excel_report.inc defines 7 arguments in the Info() method whereas it's counterpart in the pdf_report.inc additionally defines the three arguments listed earlier.

These may well be some of FrontAccounting's best kept secrets!

Attached is one way to address Alann's first request.

The second issue notes: The contact_name issue is in flux at the moment since all such info are being collimated into the crm_persons table and some reports still reference the old one though the standard forms now avoid it. It will require custom coding and maintaining it as fixes to the core code arrives will need to be taken care of unless assimilated into the core. The Invoice memo form field is the best alternative for now.

The third request fix: A discount Text box during Invoice Input can be implemented by invoicing a dummy service item (Discounts Offered) of editable description and stating amount (negative) at use time. Otherwise, provide the discount at payment allocation time.

The current stable version 2.3 will only get critical fixes backported as the devs policy which is justified, as resources are best spent on newer versions.

I have just committed a mod into the FAMods folder in my GitHub Repo to enable the display of Customer Purchase Order need in the Sales => Direct Delivery form. This uses the Non Field DB Data functionality I have backported - function parse_notes_params().

Place a space separated entry PO#1 in the cust_branch table's notes field that is space separated for customers who have stated that they must get deliveries (and subsequent invoicing) only for purchase orders they have originated.

4,565

(1 replies, posted in Installation)

@phoanglong: Welcome to the FA community and helping adoption by Vietnamese users.

Take the sql/en_US-new.sq file and copy it as vn_VN.sql and make changes to it to suit Vietnamese Chart of accounts - if you use NotePad++ for editing, use Encoding => Encode in UTF-8 without BOM.

For your reference, the various CoA's are in my GitHub Repo and the language translations are also there.

The template for translations is in lang/new_language_template folder.

Copy the empty.po file as vn_VN.po and edit it using PoEdit or just NotePad++. Compile it with msgfmt:

msgfmt vn_VN.po -o vn_VN.mo

4,566

(21 replies, posted in Setup)

Use Sales => Direct Invoice

@joe: It would require a hack to PunBB to get it done - nice suggestion for a quick link.

4,568

(21 replies, posted in Setup)

Make many Restaurant Service Items.
Make just 1 or 2 Service Items for the Call Center.
Do not track Inventory.
Just have 1 Cash Customer.
1 Credit Card Customer for each Credit Card Type.

POSper is now at: http://posper.net/

All Links at:
http://posper.net/links/

Change your exchange rate provider in the config.php

Second level authentication is not available in FA natively. Roll your own - too many sqls to edit in too many places.

forum menu? The wiki is there for a purpose. Look under the "Working with FA" on the left menu links and choose any one under it => then choose the Reports and Analysis => Tips and Tricks => https://frontaccounting.com/fawiki/index.php?n=Help.ReportsAndAnalysis => dejavu.php missing - TCPDF Font Failure.

Could you suggest any other place....without cluttering the front page of the wiki? Possibly a sticky post - already too many vie for prominence in most topics.

All PO / MO files are in the GitHub repo - use PO Edit to make the po files and use msgfmt and msgunfmt to make the mo and po files respectively.

The following posts may be informative:
https://frontaccounting.com/punbb/viewtopic.php?id=5456
https://frontaccounting.com/punbb/viewtopic.php?id=5242

It is possible that your IP has been blocked by the firewall at the repo.frontaccounting.eu end or your ISP's DNS does not resolve the said url properly.

Try to directly access the url:

http://anonymous:password@repo.frontaccounting.eu/2.3/Release.gz

If it is your DNS problem, then put in the following into your /etc/hosts file:

91.227.122.4  repo.frontaccounting.eu

The file in windows is generally at C:\WINDOWS\System32\drivers\etc\hosts.

In the worst, instance, download the whole repo in one go from the github repo and create your unsigned repo and use it as it is.

4,574

(21 replies, posted in Setup)

Direct Invoice to "Cash Customer" - All service items - no inventory.

http://dry.sailingissues.com/linux-equivalents-verdana-arial.html
http://dejavu-fonts.org/wiki/Download
https://code.google.com/p/pyfpdf/wiki/Unicode

Checkout some Dejavu FreeSans font to use.