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

778

(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.

779

(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.

780

(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.

783

(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.

784

(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

785

(8 replies, posted in Announcements)

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

Try Quick Entries.

787

(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.

791

(18 replies, posted in Setup)

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

792

(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

793

(18 replies, posted in Setup)

$config_allocation_settled_allowance value in config.php.

794

(18 replies, posted in Setup)

Then play with the delta value in config.php

Explain how you wish to treat admin expenses on accrual basis.
Normal journal entries should suffice.
Otherwise, if inventorable goods are used and wish to be tracked, then open a sales order and keep adding to it and keep delivering it in part and when all are done, "invoice" it by allocating from an equivalent credit note for self expenses.

796

(8 replies, posted in Translations)

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

797

(5 replies, posted in Setup)

https://www.transifex.com/gnuacademy/frontaccounting-1/ -- FA 2.3.x
https://www.transifex.com/gnuacademy/frontaccounting24/  -- FA 2.4.x

Check out the codebase after the recent menu popups fixes in the FA GitMaster.

799

(3 replies, posted in Setup)

Since you are only drop shipping it, have a separate PHP Application or FA module made that reads from the FA tables and do it as a cron job for population of the new application/module's tables. The only real page for the application/module would be to choose the drop ship customer and provide reports. This way, you need not divulge the rates / prices of your real customer to their downlines.

800

(7 replies, posted in Wish List)

Other Chat applications that will need manual integration in a similar manner are:

* On SourceForge: PHPChat, PHPFreeChat.
* Fox21 PHPChat
* Make Your Own Chat Script in PHP - Tutorial