3,551

(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,554

(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,556

(2 replies, posted in Reporting)

Put the phone number in the TaxID field.

3,557

(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,558

(1 replies, posted in Setup)

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

3,559

(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,560

(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,562

(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,564

(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,565

(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,567

(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,568

(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,570

(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,572

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

Check the error logs and revert.
Since it works in 2.3.24, check out some intermediate versions of 2.3.24+ and see when it breaks.

Alternatively, a credit of maximum usage can be agreed upon and provided as a loan to the customer and advance received back into the customer's account.

A credit limit too can be used.