Search options (Page 34 of 247)

@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:

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: This (date wise) should be the way it is by default. Alternatively, a report request flag for this mod can be in the core.

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.

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.

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

Try Quick Entries.

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

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.

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

Then play with the delta value in config.php

The actual installer translations are yet to be added in to the official repo.
Added Now.