As long as it is a file that is uploaded in the core it should be okay. If code is pasted into a field in a FA form, it will cause security issues.

802

(1 replies, posted in Reporting)

The PDF can be viewed before being discarded if not good or needed.

When code is pasted into FA, it can cause security concerns.

Or use PDF2HTML conversion to call the report using PDF and then output all PDFs as HTML when that flag exists.

805

(8 replies, posted in Announcements)

Post Release Fixes attached.

CHANGELOG

New SysPrefs boolean variable added: long_description_invoice on 2020-06-13
Fixes PHP 7.4 bugs and security loophole in adding languages too as of 2020-08-04
Dimensions extended to AR/AP as well - 2020-08-12
TCPDF error introduced on 2020-07-04 has been fixed now.
New layout for Login page
This also has the PHP compatibility fix stated here.

Kindly state your reason for wanting the same.

All suggestions with clear use cases will foster quicker adoption and assimilation into the codebase.

807

(27 replies, posted in Setup)

Most new user downloads from India and some other countries occur from GitHub since the Spoken Tutorial (instructions given during contact classes) use it - this will skew the SF downloads based inferences. Furthermore, many FA service providers in India use UK and US hosts.

@chamber: Your post that stated you needed clarification could not be replied to as it was deleted before I could reply. Also your email domain truenorthprojects.com does not seem reachable having been registered as owned by anonymize.com.

Your message:

apmuthu wrote: "Open ended Client Orders can be edited and added to for the period, on completion of which they can be invoiced."

I do not understand exactly what this means.  My plan was to contact Sunit directly, and arrange our business dealings directly. Each of us obviously has an incentive to deal honestly to protect our reputations here. I will likely need more help in the future. 

Your message implies that my original post was an "order".  Are you suggesting that Sunit and I use this thread for our business dealings?  My preference would be to deal directly with him, not in public. However, because I value my reputation and am new here, I want to understand exactly what you mean so I do not make mistakes or miscommunicate and get off on wrong foot.

Thank you for clarifying. I will do nothing further before I hear from you.

Sunit and you can communicate outside of the forum to the extent that it has specifics and confidential info. The forum would be a nice place to get inputs and assistance from the community. Business dealings must necessarily be outside of the forum.

What I meant was to have open ended orders that can be kept adding to till the time the invoice is made. Orders can be delivered to before being invoiced.

Alternatively, have another extension module created or a separate application made to partake of the FA DB and seamlessly complete the transaction within FA.

@joe: ripe enough to incorporate into the core?

810

(4 replies, posted in Reporting)

@joe: This (date wise) should be the way it is by default. Alternatively, a report request flag for this mod can be in the core.

811

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

Try it first in a sandbox by upgrading to 2.4.8 and with the official import transactions bundle and then replace the files with the one in Post 131 here.

812

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

You have used the template at templates/single_line_salesinvoices.csv in the import_transactions extension.

There are 24 commas (,) which means that there are 25 fields in all in the said template.

FA 2.4.3 was released on 2017-10-11
FA 2.4.8 was released on 2020-02-04

Import Transactions extension was last updated in my unofficial repo on 2019-05-12.

Attached is the changed files necessary to upgrade FA v2.4.3 to 2.4.8. Check for any extra sys_prefs table entries and config.default.php variables to put into your DB and config.php file as needed.

Make sure that the address or other field does not have any commas (,).

State your PHP/MySQL/Server version and locale settings.

Assuming a single voucher for all transactions were entered as at the end of First Year, the broad parts would skeletally be:

On Purchase:
    By HP Co Cr 69000 (15K + 3 x 18K)
    To Fixed Asset Dr 60000
    To Interest Charges Dr 9000

On Down Payment: 
    By Checking Bank Account Cr 15000
    To HP Co Down Payment Dr 15000

On First Year End:
    By Fixed Asset Depreciation Cr 6900
    To First Year Depreciation Dr 6900

On First Installment Payment:
    By Checking Bank Account Cr 18000
    To HP Co First Installment (Principal + Interest) Dr 18000

On Repairs before sale:
    By HP Co Cr 1500
    To Repairs Dr 1500

On Repossession Sale:
    By Sale (repossession) Cr 38000
    To HP Co Repossession Dr 38000

Interest Reversion for balance period (assuming Simple Interest):
    By Interest Charges (refunded on repossession) Cr 6000
    To HP Co Interest waiver for balance term Dr 6000

Net Status of the Transaction:
Net Balance due from HP Co (excess sale value) : (15000 +18000 +6000 + 1500 + 38000)  - 69000 = 8000
On sale, Fixed Asset vanishes - 0 Value (Adjustment entry as needed)
No reversion of depreciation as it would become a true expense.

The above assumes that the repossession took place immediately after the payment of the first installment. In case the repossession and sale occurred after the second year, then additional interest and penalties will apply and the profits from sale will be appropriately get reduced.

Kindly pose your accounting questions to your auditor as this forum is not for teaching accounting.

The Forum and the Wiki are the treasure troves you seek for general workarounds.

Open ended Client Orders can be edited and added to for the period, on completion of which they can be invoiced.

815

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

The said string "You must enter reference" does not exist in both the core files of FA 2.3.x and FA 2.4.x and in their respective extension files.

Please check to see if you have done any customisation of the core files where the said alert emanates.

816

(8 replies, posted in Announcements)

Attached is the set of changed files between FA 2.4.7 and FA 2.4.8.
There are no DB changes.
All translations for Tamil and Hindi have been committed in my unofficial FA24extensions repo.

* First 2 day download stats at SF.
* Previous release change fileset post.
* SF Main Download Page
* FA 2.4.8 tar.gz download
* MD5 Hash: f5a66878f841146a8b602220d1ca5623
* Filesize: 1,591,401 bytes

817

(8 replies, posted in Announcements)

New translation strings in FA 2.4.8 attached.
Translations hammered out on Transifex.

Try Quick Entries.

819

(2 replies, posted in Misc. Charts of Accounts)

This is how you create sub ledgers. It works.

https://frontaccounting.com/punbb/viewtopic.php?id=3470

The Dutch CoA has been updated as there was one "inactive" named field which was out of sequence. Also it differs from the en_US-new.sql in that it has some masters data as well and is suitable for a New Install.

On making a single Direct Invoice with a single item, the attached sqls take place.
See if you want to manually interfere to correct such a mistake if one exists.

823

(18 replies, posted in Setup)

@joe: How do we handle such rounding errors in a standardised way to avoid adjustment journal entries?

824

(18 replies, posted in Setup)

Try this piece of code in a test php file:

<?php
if (1.7 >= 17 * 0.1) {
  echo '1.7 is greater than or equal to ' . 17 * 0.1;
} else {
  echo '1.7 is NOT greater than or equal to ' . 17 * 0.1;
}

echo "<br>\n" . (0.1 + 0.2);

?>

In XAMPP 1.7.3 (PHP 5.3.1) we get:

1.7 is NOT greater than or equal to 1.7000000000000002
0.30000000000000004

This is because native operator are indeed interpreted in base 2, and most base 10 decimal converts badly in base 2.

If you need precision, you need to either only manipulate integers (converts perfectly to base 2) or use a dedicated lib such as bcmath (checkout the wrapper to ease bcmath usage Math).

Ref as of 2 months ago:
https://stackoverflow.com/questions/58744298/php-floating-point-multiplication-and-comparison-issue

Ref as of nearly 11 years ago:
https://stackoverflow.com/questions/588004/is-floating-point-math-broken

Ref in PHP.net:
https://bugs.php.net/bug.php?id=74534

Floating point arithmetic for programmers

825

(18 replies, posted in Setup)

$config_allocation_settled_allowance value in config.php.