Search options (Page 232 of 246)

Please state the exact numbers involved in the division / multiplication like base amount and / or final amount, taxrate(21%), erroneous amount (29.29, 29.30) name, etc.
Also one navigation is given as General Ledger > Tax Inquiry and what is the other navigation for invoice?

Any chance of porting the reports to the stable branch or are they directly usable with the stable branch?

It works with latest Foxit Reader v5.4.4 on WinXP SP3. See screenshots.

In Foxit Reader:
Edit -> Preferences -> Trust Manager -> Enable Safe Reading Mode -> Uncheck

All recent versions of PDF Readers disallow Web access by default. We need to enable it when we are sure.

Which PDF reader?

Adobe Acrobat / SumatraPDF Readers work.

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.