601

(9 replies, posted in Reporting)

@joe: nice feature - can implement it - branch-wise split up of sales for each customer. A simple checkbox (boolean flag) for branch-wise reporting should be sufficient in the report request form.

Update your FA 2.4.8 install by taking in the post release files from this post.

603

(5 replies, posted in Setup)

In old accounting system:
1. Before closing your old accounting system previous fiscal year, take a trial balance.
2. Segregate entries for unpaid invoices and the partial payments related to them - AR and AP.
3. Get the segregated Trial Balance without the above entries.

In new FA system:
1. In your new FA system, create the previous fiscal and make your current balances as as the end of that fiscal from the segregated Trial Balance obtained above.
2. Make the subsequent entries for the previous fiscal's unpaid invoices for both AR and AP.
3. Create a new fiscal year for the current period in the new FA.
4. Now close the previous fiscal in the new FA.
5. You will now be able to allocate payments to the old AR/AP unpaid invoices in the new FA.

You may need to make a few iterations - so keep a backup at each stage in both the old and the new systems.

If in doubt, take professional assistance.

604

(8 replies, posted in FA Modifications)

That is why the password.php can be bundled into FA in the next version and make it into a separate extension for the current one. Note that the standard Charts will then be unusable until suitably modified.

Keep different sales units as separate inventory items.
Also make stock movements when "disassembly" of such items are desired amongst them.

Some new fixes can override other previous changes that might break some earlier functionality.

@joe: is this an issue?

607

(8 replies, posted in FA Modifications)

No wonder! PHP version 5.5.0 onwards the function password_hash has been available.

reporting/rep30.php can be edited as needed. Also the "OpeningStock" label needs a bit more space as the last letter is truncated in the current FA version though the snapshot in the Wiki appears fine.

The reason why there is no total for Items is that the units for the items can vary and you can possibly get the confusing total of Apples and Bolts!

609

(8 replies, posted in FA Modifications)

Please note that this mod can only be applied in FA 2.5 as older versions of PHP do not have these encryption methods as the function password_hash uses BCRYPT.

For those who wish to use this functionality in PHP 5.3.7+ till < 5.5.0, refer the backward port function at:
https://github.com/ircmaxell/password_compat
and include the file password.php before usage.

Cross Reference:
https://frontaccounting.com/punbb/viewtopic.php?pid=37998#p37998

@joe: is this the solution?

Past references are in Posts 7 and 10 of:
https://frontaccounting.com/punbb/viewtopic.php?id=8672

612

(8 replies, posted in FA Modifications)

Upload changes and before and after screenshots if necessary somewhere and place link here.

613

(82 replies, posted in FA Modifications)

An around 12 MB video of the walkthrough of the demo link above is here.

Good job @joe!

Maybe a set of changed files for the current FA 2.4.8 can be zipped up and provided here for users to test out this theme and dashboard. - Done

Updated video with no Create Company screens and with GL dashboard.

614

(3 replies, posted in Banking and General Ledger)

Upload your Filippino (Tagalog) language and it's English local counterpart you are using for the language files. The FA project can be enhanced with it so that many fellow users in your country can benefit from. The community can also help make it utf-8 compatible too.

Enable php for your web server for the path in which FA is installed. Looks like the cPanel script just copied over the FA files and found that it could not use PHP in the target folder. All that this has exposed is the contents of the raw index.php file without PHP operation.

If you are using the Vivaldi or any non-standard browser, check your file associations for htm, html, php and other files.

617

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

All 41 charts have been updated with the new sys_prefs strings in my extensions repo.

618

(4 replies, posted in Setup)

Can you not install the iso-8859-1 version of Dutch on your NAS?

The nl_NL is the more recent version in my extensions repo and that too is iso-8859-1.

Attached is a specially compiled version in utf-8 from the above for your needs.

If you have already installed the iso version, then edit the installed_languages / installed_extensions file config file with the appropriate encoding as in the _init/config file in the attachment and replace the .mo file in the lang/nl_NL/LC_MESSAGES folder.

619

(1 replies, posted in Setup)

FA => Setup tab => Company Setup => User Interface Options => Search Customer List / Search Supplier List / Search Item List

Tick the check boxes as appropriate and click "Update".

Now the said search box will act as a filter for the drop down box.

1. https://github.com/apmuthu/FA24extensions/blob/master/Extensions/import_multijournalentries/doc/readme.txt
2. https://github.com/apmuthu/FA24extensions/tree/master/Extensions/import_transactions/templates
3. List of CSV fields are explained in https://github.com/apmuthu/FA24extensions/tree/master/Extensions/import_paypal

621

(13 replies, posted in Setup)

An auto logout and login switch script at the top should suffice with no DB or any great UI changes. Auto generation of the new session - can also be mapped to the same username and password in each company allowed.

Security issue: what happens if a site administrator creates a new username to be same as that of another site administrator's company? That is why the username and password should match that of the currently logged in company user in each of the companies to be allowed for the user.

This method can also be used for brute force attacks by using a set of passwords after logging in as one valid user in one company.

Going back in reverse chronological manner for nearly 5 years yields the following commits:

Add dimension to supplier payments
2020-02-20: https://github.com/braathwaate/frontac24/commit/2eb8f5462ef7be2ea9c0e3593e16619f8054be11

add dimension to mfg; more flexible cost types
2019-01-21: https://github.com/braathwaate/frontac24/commit/740a068d847e38027fd8c351bf26be15188cfb85

Add dimension to payments
2018-12-24: https://github.com/braathwaate/frontac24/commit/260d6e330932eb6d8f01584ce58220acda9ec2f1

Add dimension to payments; cash basis on p/l; fix dups on gl names
2018-02-24: https://github.com/braathwaate/frontac24/commit/6899ac7a52454f5cebce90945725056a5c9022f1

@joe: If they do not have any DB changes (or just flags alone could suffice), can we add it to the core?

623

(5 replies, posted in Reporting)

Anyone interested in creating an extension for a report in the Indian GST format can use the attachment as a template.

@joe: any reason why the supplier payment edit was disallowed?

@joe: check if it needs to get into the core.