Most welcome.
2,801 08/15/2017 04:32:57 am
Re: Volunteer translators for installaion wizard messages needed (48 replies, posted in Translations)
2,802 08/15/2017 04:27:57 am
Re: Add Manual Language (3 replies, posted in Translations)
https://frontaccounting.com/fawiki/index.php?n=Main.Usage
Study how the Tamil Translation was added:
https://frontaccounting.com/punbb/viewtopic.php?id=5242
Browser display issues with Khymer unicode:
http://www.sbbic.org/2014/05/01/fix-khmer-unicode-doesnt-display-correctly-firefox/
https://bugs.chromium.org/p/chromium/issues/detail?id=225717
You can login to http://www.transifex.com and find that the Khymer language (km_KH) translations have been enabled at:
https://www.transifex.com/gnuacademy/frontaccounting24/language/km_KH/
Translate and let us know so we can include it.
2,803 08/15/2017 04:21:29 am
Re: add field (3 replies, posted in Items and Inventory)
Make a module to populate a new table that has the same primary key as the items table and make your enum fields in it with static select boxes in the forms that populate them.
2,804 08/15/2017 04:19:21 am
Re: Editing the FA Wiki. (1 replies, posted in Announcements)
FA Forum login credentials work for the Wiki.
2,805 08/14/2017 05:40:27 pm
Re: Tax on free gift (11 replies, posted in Accounts Receivable)
There is a Sticky Announcement: https://frontaccounting.com/punbb/viewtopic.php?id=922 but not as explicit as your statement.
@joe: remove old stickies and put in one with @poncho1234's suggestion there.
2,806 08/14/2017 02:58:47 pm
Re: Urdu Transalation not working in FA2.41 (1 replies, posted in Translations)
What is your platform OS and versions of PHP/MySQL/Apache and locales available in your OS?
Make sure your browser supports UTF-8 unicode and you have the necessary Arial-Unicode font file or other Urdu fonts available.
The ar_EG (Arabic Egypt) stands updated in my repo.
2,807 08/14/2017 02:55:07 pm
Re: Exchange Variance Error (27 replies, posted in Banking and General Ledger)
What is the base currency of your company?
2,808 08/14/2017 02:54:03 pm
Re: The entered information is a duplicate. (10 replies, posted in Modules Add-on's)
Yes
2,809 08/14/2017 08:44:16 am
Re: The entered information is a duplicate. (10 replies, posted in Modules Add-on's)
Give the link like http://www.yourdomain.tld/<path_to_fa>/Screenshot_csv_source.png
2,810 08/14/2017 08:41:44 am
Re: Exchange Variance Error (27 replies, posted in Banking and General Ledger)
Setup -> Display Setup - Exchange Rates -> 8
Base Currency: USD
Banking and GL -> Exchange Rates -> shows 8 decimal places.
The BuyRate form field is set to allow upto 15 digits.
Now all calculation should be okay.
2,811 08/14/2017 08:22:52 am
Re: Error Rounding with Tax (8 replies, posted in Accounts Payable)
Increase the number of decimal places for Exchange Rate to 8 from the default 4 in Setup -> Display Setup (Preferences).
2,812 08/14/2017 07:12:57 am
Re: Tax on free gift (11 replies, posted in Accounts Receivable)
That's how the wiki has been built - great to have another diligent wiki contributor!
2,813 08/14/2017 07:08:06 am
Re: Transaction Deleter (1 replies, posted in FA Modifications)
Take a backup.
Compare with the original Chart of Accounts you started with.
Cherry pick the differences in the former you wish to retain and then what is left can be restored to be the one without any transactions.
Alternatively, compare the en_US-new.sql and the en_US-demo.sql files in the sql folder and see what transaction tables need to be purged and then purge those tables in your database.
@joe: Though dangerous, this can be an useful menu option greyed out by default and with a permission setting to be enabled on demand atleast for the Super Administrator role.
2,814 08/13/2017 04:32:27 pm
Re: customer id (1 replies, posted in Accounts Receivable)
There is no CustomerID field in FrontAccounting. Which table and which field are you referring to? Customers, Suppliers, etc are stored in the debtors_master table and in the case of customers, the cust_branch table is also cross referenced. The 3 crm_* tables store the actual contact info.
The Customer Short Name too can be used for what you need.
2,815 08/13/2017 10:11:26 am
Re: Tax on free gift (11 replies, posted in Accounts Receivable)
Thanks @joe and @poncho1234. This info has been wiki-ed.
2,816 08/12/2017 09:19:48 am
Re: Tax on free gift (11 replies, posted in Accounts Receivable)
Providing a credit note may do it as will a negative shipping charge (without tax) but will get mixed up with the real shipping charges.
@joe: Can we extend FA to accommodate an AdHoc discount at the end of each invoice as an amount value?
2,817 08/12/2017 09:10:58 am
Re: Landed Costing of Inventory Items (26 replies, posted in Items and Inventory)
Read about GRN.
2,818 08/12/2017 09:05:43 am
Re: Exchange Variance Error (27 replies, posted in Banking and General Ledger)
The Rupiah Exchange rate would need additional decimal places if say the USD is the base currency!
If you keep your Indonesian Rupiah as the base currency all should be well.
Alternatively, you can omit the last 3 decimal places of the Indonesian Rupiah and modify the exchange rate entries accordingly.
As it is, if you want to change the decimal places size, then do it in Setup -> Display Setup (Preferences) in the Web UI.
2,819 08/10/2017 05:21:44 pm
Re: The entered information is a duplicate. (10 replies, posted in Modules Add-on's)
Paste link here.
2,820 08/10/2017 05:20:31 pm
Re: Tax on free gift (11 replies, posted in Accounts Receivable)
Taxes are % of price and hence not directly possible.
Bill full value and apply adhoc discount after tax.
2,821 08/09/2017 05:19:13 pm
Re: FAWiki - How to upload files? (4 replies, posted in Installation)
The Board Admin will need to allow it - PM @joe.
2,822 08/09/2017 05:18:26 pm
Re: The entered information is a duplicate. (10 replies, posted in Modules Add-on's)
Does it have anything to do with hardcoded primary keys of any auto added primary key that starts with 1 each time?
2,823 08/09/2017 05:17:25 pm
Re: Inventory adjustment in FA 2.4.1 (1 replies, posted in Items and Inventory)
Probably yes - try it and document it.
2,824 08/09/2017 05:16:35 pm
Re: Mismatch with payments (1 replies, posted in Banking and General Ledger)
As of the last day of the previous fiscal:
1. Make a dummy invoice for each vendor / customer trackable outstanding
2. Make a journal voucher for the rest of the balance sheet entries
For the first one above, you will be able to allocate payments in the current accounting year.
The current year invoices will now reflect their balances correctly.
2,825 08/08/2017 05:00:28 pm
Re: I get warning Message (3 replies, posted in Announcements)
The table structures / table list of the FA 2.3 has changed in FA 2.4.x. Take a schema dump of the current one and compare it with that of the en_US-new.sql file and see if it is very different and try to run a Setup->Software Upgrade from within the FA Web UI.
Seek professional assistance in the job board and post your offer.