2,751 Reply by apmuthu

(2 replies, posted in Banking and General Ledger)

The "Banking and General Ledger => GL Accounts => Edit Bank Account" does not bear the Currency details.
The "Banking and General Ledger => Bank Accounts => Edit" does not allow the changing of Currency once set. This can be changed in the database directly only. Take a backup, correct it in the sql and upload and restore it. This should be done only when you know that no transactions exist for the said Bank Account as yet.

Make sure that the Home Currency is properly set in the Setup => "Company Setup".

Go to forum: Banking and General Ledger

2,752 Reply by apmuthu

(5 replies, posted in Manufactoring)

Raw Milk, Toned Milk and Cream are 3 different products.

100 Ltr of Raw Milk = 100 Ltr of Toned Milk + 10 Kg of Cream

If you treat the output products as the real constituent items and the input product as the "Kit", you will ordinarily be dismantling the "Kit" and selling the constituent items whilst you can also sell the Raw Milk directly if desired - directly in the "Kit" form.

Go to forum: Manufactoring

2,753 Reply by apmuthu

(30 replies, posted in Fixed Assets)

Fixed Assets was an extension in FA 2.3 and is builtin to FA 2.4 natively. The wiki does not yet have a page on it.. Fixed Assets on the Wiki

To configure the Fixed Assets, enable the role for it (Fixed Assets Configuration), save the role and logout and login again.

The attached screenshots are self explanatory.

Go to forum: Fixed Assets

2,754 Reply by apmuthu

(12 replies, posted in Reporting)

This has already been committed in the Official repo and in the standard charts. It will hence be part of the next release.

Go to forum: Reporting

2,755 Reply by apmuthu

(16 replies, posted in Accounts Receivable)

To avoid sql injection where we know the 2 POST variables are integers, just use:

        $deletecustomer = $_POST['deletecustomer']+0;
        $keepcustomer = $_POST['keepcustomer']+0;

Go to forum: Accounts Receivable

2,756 Reply by apmuthu

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

Compare the files in the official repgen pkg as extracted to the modules folder with that in my GitHub repo and synch as needed.

There 2 places in repgen_createfunct.php (88, 104) and 1 place in repgen_del.php (58) where http can be changed to https - maybe it should be coded to auto choose.

Go to forum: Modules Add-on's

2,757 Reply by apmuthu

(16 replies, posted in Accounts Receivable)

Study the schema / ERD for your version of FA and then replace all discardable customer ids with the preferred customer id.
The FA 2.3.x schema is available in the Wiki and FA v2.4.x isn't too different.

Go to forum: Accounts Receivable

2,758 Reply by apmuthu

(13 replies, posted in Reporting)

Attached is the Company Setup page with the said option.

Go to forum: Reporting

2,759 Reply by apmuthu

(12 replies, posted in Reporting)

Attached is the screenshot of the new Company Setup page.
Also incorporate in all the Charts as in my FA24Mods.

Go to forum: Reporting

2,760 Reply by apmuthu

(7 replies, posted in Installation)

@joe: change line 23 in sql/alter2.4.php:

        $this->description = _('Upgrade from version 2.3 to 2.4RC1');

to

        $this->description = _('Upgrade from version 2.3 to 2.4.1');

Also line 158 in the same file needs to be conditionally acquired:

        $old_encoding = 'latin1'; // default client encoding

Looks like your db schema needs 900 secs time out instead of 300. Also check the attached schema differences between FA 2.3 and 2.4.

Go to forum: Installation

2,761 Reply by apmuthu

(1 replies, posted in Banking and General Ledger)

See the reflines table. The pattern field  in FA 2.4.2 which automatically does this.

Go to forum: Banking and General Ledger

2,762 Reply by apmuthu

(12 replies, posted in Reporting)

Would be nice to have it on a per company basis.
Will an entry in the sys_prefs table override this setting treating the global one as the default?

The Wiki has been updated.

Go to forum: Reporting

2,763 Reply by apmuthu

(5 replies, posted in Announcements)

Greenshot does not yet do scrolling window capture (FastStone does). It, however, has a portable version and a non installer zip version too.

Go to forum: Announcements

2,764 Reply by apmuthu

(5 replies, posted in Announcements)

Format your BBCode using the likes of WYSIWYG BBCode Editor.

FastStone Screen capture was free till v5.3 and makes for good screenshots although PrtScreen button and MS Paint do the job as well. Various portable ones are available too.

Go to forum: Announcements

2,765 Topic by apmuthu

(5 replies, posted in Announcements)

As the FrontAccounting forum is community managed and driven, please use it diligently and with care. Whilst every effort is taken to ban advertising and undesirable SEO activities, it is incumbent on the user fraternity to report any

1. irrelevant posts,
2. duplicate postings and
3. postings in old threads with seemingly relevant matter often taken from other valid posts.

All of these and others not listed here introduce needless complexity and waste of human resources in moderating the board. Attempting to maintain a Hall of Shame would be an additional waste of resources.

When posting issues, please list

1. version numbers of Platform OS, Browser, PHP, MySQL, Webserver, plugins, upgrade path and locale among others as necessary
2. relevant Menu Navigation sequences,
3. screenshots appropriately annotated (host the images/documents anywhere - flickr, dropbox, etc) and linked into the posts,
4. use BBCode to format your posts

Go to forum: Announcements

2,766 Reply by apmuthu

(8 replies, posted in Manufactoring)

@karl1234: good work!

Committed.

FA 2.3.x not affected.

Go to forum: Manufactoring

2,767 Reply by apmuthu

(8 replies, posted in Accounts Payable)

Try smaller numbers first and see when the error occurs. You should not exhaust the floating point precision of your variable.

This is a PHP issue:

$a = 31975454.54545400;
$b = 3197545.45454540;

echo $a+$b;

// Outputs: 35172999.999999

What is the value of precision in your php.ini file?
Increase it and see what happens.

Increasing it from 14 to 17 in PHP 5.3.3 on 32 bit XAMPP:

$a = 31975454.54545400;
$b = 3197545.45454540;

echo $a+$b;

// Outputs 35172999.999999397

This might do the job.

In the code, it can be dynamically set as well:

ini_set('precision', 17);

Go to forum: Accounts Payable

2,768 Reply by apmuthu

(13 replies, posted in FA Modifications)

Thanks @joe.
Committed

Go to forum: FA Modifications

2,769 Reply by apmuthu

(3 replies, posted in Banking and General Ledger)

There is no 1100 in your image.
If you want an amount in words, then you will have to use the locale script to get it. The template is available in lang/new_language_template/locale.inc. Translate and use in your language folder.

If you want the hint "View this transaction" when you hover on the Trans# link, then add the attribute title="View this transaction" to the link's anchor <a ....> tag.

Kindly take professional assistance on the Job board from someone who understands your language.

Go to forum: Banking and General Ledger

2,770 Reply by apmuthu

(1 replies, posted in Jobs wanted/offered, non-free offers)

Set default printer in AndroidPOS device and print from the browser UI in the Android device itself. Some may also come with the web interface API.

Esc/POS Print Driver for PHP

Go to forum: Jobs wanted/offered, non-free offers

2,771 Reply by apmuthu

(3 replies, posted in Banking and General Ledger)

It is already present.

Go to forum: Banking and General Ledger

2,772 Reply by apmuthu

(8 replies, posted in Manufactoring)

There is certainly no decimals issue in using all hard currencies and the SA Rand.

Posting as Guest has been hopefully disabled by now.

The kit is formed in Assembly like a bunch of items sold together as a pack. It will have another Stock ID as well and hence placing them in stock should be no issue.

Items and Inventory => Sales Kits

@joe: Does this warrant a check? Assign the first post in this thread to user: @karl1234. (done)

Go to forum: Manufactoring

2,773 Reply by apmuthu

(8 replies, posted in Manufactoring)

It appears that your email id is not available and your credentials are wrong. Kindly contact the board admin (@joe) for account validation.

Sell the Necklace as a Kit of 2 items - a sort of package.

Go to forum: Manufactoring

2,774 Reply by apmuthu

(4 replies, posted in Announcements)

The window size of F2, F3, F4 search pages need to be expanded to adjust to the larger layout.
It is very slow to load.

The HTML page output and it's assets sizes are 109KB and 464KB respectively for your theme.
The standard default FA 2.4.2 theme equivalents are 15.9KB and 58.2 B respectively.

Tough convincing any serious accountant to accept such a bloat for visual eye candy.

Go to forum: Announcements

2,775 Reply by apmuthu

(3 replies, posted in Report Bugs here)

It appears that third party extensions are not allowed an extension number in FA. The code is used in function local_extension() in admin/inst_module.php. The function handle_delete() in the same file refers to the version not being a hyphen for a standard uninstall.

Go to forum: Report Bugs here