All email in FA are sent using the class email which is in reporting/includes/class.mail.inc.

Search for the text "new email" in the FA code and all such places that use it will emerge and in FA it will be:

reporting/includes/inventory_db.inc => function send_reorder_email()
reporting/includes/pdf_report.inc => function FrontReport::End()

Since it is inside functions, search  recursively for each function call in the codebase.

You mentioned that you are a "experienced Front Accounting..... expert" .....

Kindly note that FA 2.3 is quite mature whilst it's CoAs in the official repo are not all of the "exact" schema. Since you are implementing FA for your clients, you will do well to check out the extensions development in the unofficial repo as well besides the FAMods.

Other than being free what made you choose FA after so much experience with "big ERPs"?

Cheers and good luck. Enjoy FA.

3,528

(20 replies, posted in Announcements)

For those trying to install FA 2.4RC1 in the pt_PT and de_DE languages, the corrected language files for the installer are zipped up and attached in this post. The necessary diffs are in my commit that can be pulled into the Official Repo by the devs.

For those using the Charts of Accounts from the Official FA 2.4 PKG Repo, be aware that they have not been updated in a while. As an example, a diff for the en_US-4digit.sql has been done with the standard sql/en_US-new.sql and arranged for easy comparision with the original and attached herein.

It appears that the FA pkg files in the official repo get regenerated together for both FA 2.3 and FA 2.4 changing only their timestamps. There appear to be no changes in over 6 months now in the pkg files in the FA 2.3 official repo as on date. My unofficial pkg repo has the pkgs as farepo.zip.

All that is required is to manually create the taxes for each State in FA and backup the tax tables for import and use by others.

3,531

(1 replies, posted in Setup)

FA is really "Single User" as far as multiple simultaneous submits to a form are done at least in FA 2.3.x. Hence when 2 or more users open a new invoice form, all will have the same "next" reference number in it which tries to be posted and only one succeeds.

Azhar,

As you have just queried the forum for simple solutions (1, 2 and 3) - are you really experienced so soon?

3,533

(2 replies, posted in Reporting)

Put the phone number in the TaxID field.

3,534

(1 replies, posted in Setup)

Make a copy of the sql/en_US-new.sql or other Chart of Accounts sql file you are using - and name it uniquely and place it in the same sql folder after editing the currency and other details in it.

3,535

(1 replies, posted in Setup)

Edit the file config_db.php and remove the offending entry in the $db_connections array.

3,536

(24 replies, posted in Installation)

State which version of XAMPP / PHP and OS, FA you are using.

In both FA 2.3.x and 2.4.x, the function user_company() is defined in includes/current_user.inc file.

See if any info in this post solves your issue.

3,537

(1 replies, posted in Banking and General Ledger)

Journal Entries.

The file includes/dashboard.inc in FA 2.4 uses several translated strings like "Top $limit .....". Where do these translations reside?

3,539

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

I trust it is  a self join with:

0_debtor_trans_details.src_id = 0_debtor_trans_details.id

Yes. That is what Manufacturing is. If you wish to make it separate Manufacturing orders, split the raw material quantities on separate orders to what is needed for the one manufactured.

3,541

(1 replies, posted in Setup)

CAS (Central Authentication Service) like a Single Sign On is possible with FA. Check the login code and what values accrue in it's session and make sure the CAS replicates it on login.

3,542

(21 replies, posted in Items and Inventory)

You can state all pre-deducted charges in the description and use the net price in your invoice.

Check the collation and charset of the old and new dbs.
Also check the PHP / MySQL / Apache versions of both installs.
There may be some missing php modules (php -m) in the new one.

3,544

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

Create an invoice manually in FA for one invoice from Unicenta. Take the diffs of the before and after backups and you will see what has been inserted and what has been updated. Do the same in your procedure directly into FA's tables.

3,545

(2 replies, posted in Reporting)

State versions of OS, platform and FA used.

You can use the company number in an if statement to prevent it's inclusion / execution for the specific company you want to suppress it for. The currently logged in company should be in the session.

3,547

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

You may have some dummy entries in the table that links entities (branches) to contacts - FA's basic CRM tables. See the ERD link in the wiki alluded to in the second post in this thread.

https://frontaccounting.com/fawiki/index.php?n=Devel.BarCodeUsage
has the necessary code.

3,549

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

Study the ERD at:
https://frontaccounting.com/fawiki/index.php?n=Devel.ERDiagram23

Then you will notice that in this new version, there are additional CRM tables where entities are linked to instances.
Take a backup now.
Choose one customer and add a branch.
Tanke another backup.
Use WinMerge or some diff tool to study what records got added.
Do it likewise for the other imported customers.

If the petty cash paid and petty cash received have been incorporated into the cash and bank accounts, then they should be zero or at the very least equal to one another with sign reversal. Make a journal voucher moving the amounts in balance in each of the petty cash accounts to the cash account and then use the resultant trial balance.