Try a Journal Voucher: Debit Bank, Credit Interest Received Income
2,826 08/16/2017 02:04:42 am
Re: Release 2.1 - Bank Reconciliation. How to? (4 replies, posted in Banking and General Ledger)
2,827 08/15/2017 10:50:33 am
Topic: Barcode EAN-8 Generator mod (4 replies, posted in Items and Inventory)
Unique EAN-8 Barcode ID generator for FA 2.3.x is enabled in this commit.
2,828 08/15/2017 10:47:12 am
Re: The entered information is a duplicate. (10 replies, posted in Modules Add-on's)
Do a diagnostic check of all your tables and re-index them. Also set the auto increment value of each such table to 1 - it should then set the actual value by itself. Make sure your Chart of Accounts sql schema compares exactly with the sql/en_US-new.sql file.
2,829 08/15/2017 04:32:57 am
Re: Volunteer translators for installaion wizard messages needed (48 replies, posted in Translations)
Most welcome.
2,830 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,831 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,832 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,833 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,834 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,835 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,836 08/14/2017 02:54:03 pm
Re: The entered information is a duplicate. (10 replies, posted in Modules Add-on's)
Yes
2,837 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,838 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,839 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,840 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,841 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,842 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,843 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,844 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,845 08/12/2017 09:10:58 am
Re: Landed Costing of Inventory Items (26 replies, posted in Items and Inventory)
Read about GRN.
2,846 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,847 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,848 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,849 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,850 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?
