Search options (Page 226 of 240)

1. Backup v2.3.11 - SQL, config_db.php, config.php, installed_extensions.php lang/linstalled_languages.inc
2. Uninstall all extensions.
3. Backup SQL again along with the said files
4. rename the frontaccounting folder.
5. extract latest mercurial build onto new frontaccounting folder
6. install FA to another dummy db.
7. compare the saved files (config_db.php, config.php, installed_extensions.php lang/linstalled_languages.inc) with the currently installed ones and make changes to use the old db.
8. Login to the 0 company and go to Setup -> Software Upgrade and force an upgrade.

Post your php.ini file along with the output of:
uname -a
php -m

Better still, VNC your desktop which can be chrooted into your cloud server.

Report Generator extension is broken / unsafe for FA v2.3.13+

Lines 205 and 209 in the file reporting/includes/header2.inc attached in the previous post are both:

$this->row -= $this->lineHeight;

If the said lines are commented out, the blank line in the middle of the footer disappears.

Attached herein is the before and after picture set of an invoice.

Your Pretty Link is done!
Replace file reporting/includes/header2.inc with the one attached.

Fixed this issue natively using TCPDF class base methods itself. Fully backwards compatible from TCPDF induction into FA onwards.

Patch for reporting/includes/header2.inc attached.
This patch is for current Mercurial Build 3135.

Obtained the backup sql of your system and am testing it out in an OpenVZ VPS - a sort of test ride  troubleshooting using it.

The changes from the stock FA v2.3.13 to the Mercurial Build now as far as the database is concerned is only the following statements (You are using company 0 with a table prefix of "f1_"):

# Default value is not '1' but blank
ALTER TABLE `f1_users` 
    CHANGE `print_profile` `print_profile` varchar(30)  COLLATE latin1_swedish_ci NOT NULL DEFAULT '' after `pos`;

# InnoDB needed for Foreign Keys - not mere unique key
ALTER TABLE `f1_tag_associations` 
    ADD PRIMARY KEY(`record_id`,`tag_id`), 
    DROP KEY `record_id`, ENGINE=InnoDB; 

ALTER TABLE `f1_tags` ENGINE=InnoDB; 

# New feature in Mercurial build needs it
INSERT INTO `f1_sys_prefs` VALUES ('bcc_email', 'setup.company', 'varchar', '100', NULL);

Typo in Company Name - Extraordinaire.

The config.php must be matched with the config.default.php to make up for the missing/changed entries. Stick to default themes for now till the other themes are updated to accommodate the changed function locations that affect the renderer.php in the older themes.

The choice of white background in your logo blends well with stock white paper invoice!
COA has Retained Earnings, Owner's Drawings and Owner's Equity in Owner's Capital type(7).

Working on the prettier link without having to change the code much.....

It is possibly easier than it appears.

The form input page can have a dropdown of various paper sizes - A4, Letter, etc.

The reports can remain the existing repXXX.php - no duplication is required.

The horizontal layout of the report for each page size for heading and detail can have their numbers in arrays - one of which is chosen based on the flag taken from form input data. In all other cases, where separate arrays are not available for different page sizes, the Landscape should be the same as the Portrait except that the longest field if any may be expanded to fill the slack space.

The Vertical Layout remains the same as long as the headers and detail elements add from the top and the footer elements subtract from the bottom and the page size determines the number of lines inbetween - that is all automatic in tcpdf used.

Each element is populated in the report only if the variable exists.
unsetting the "not required" elements of variable $this->company like $this->company['gst_no'] during report population and the setting it back would suffice.

As for number to words, use a function price_in_words() in your language locale.inc (this does not seem to be documented yet).

The default function price_in_words() is defined in includes/ui/ui_view.inc and the default documents it is used in are when $document is any of ST_SUPPAYMENT / ST_CUSTPAYMENT / ST_CHEQUE

The actual number to words conversion is done in the function _number_to_words() in the same file.

Date functions use date subtraction and date intervals usually. Hence the PHP/Apache TimeZone in general is assumed to match the MySQL TimeZone setting. I have not had the time as yet to look into the exact code and why this occurs and if it is an exception for your environment.

As for the Mercurial Build, it is advisable to work on a clone of the earlier db and try Setup -> SoftwareUpgrade. Alternatively on a new database and mercurial build, try with the demo data.

If the only usage is a pdf that will be emailed or seen in a browser, then the shortened text with the hyperlink beneath it would have been okay.

The reason that is expanded in full is that in a printout the URL is not clickable!

Please try replacing Lines 1350-1355 in includes/ui/ui_view.inc for your requirement (inspite of reason listed) with:

if (!isset($payment_services))
{
    $payment_services = array(
        'PayPal' => "<a href='https://www.paypal.com/xclick/business=<company_email>&item_name=<comment>&amount=<amount>&currency_code=<currency>'>Payment Link</a>",
    );
}

Line 259 in file reporting/includes/doctext.inc:

$Footer[_("You can pay through"). " $service: "] = "$url";

and Line 1014 in file reporting/includes/pdf_report.inc:

$msg.= _("You can pay through"). " $service: $url\n\n";

are used to display the assembled $url string.

BTW: your screenshot was http and not https and yes, upload rights are controlled by the board admin.

Set the Help URL in FA to see context sensitive help and mirror the wiki locally for minimizing bandwidth usage.
Or else, PDF the Wiki.

Make a PDF of the pages in the Wiki

Is the server date/timezone affecting the issue?

Want to try it out in the later Mercurial build ?