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.
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by apmuthu
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.
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.
What is the base currency of your company?
Yes
Give the link like http://www.yourdomain.tld/<path_to_fa>/Screenshot_csv_source.png
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.
Increase the number of decimal places for Exchange Rate to 8 from the default 4 in Setup -> Display Setup (Preferences).
That's how the wiki has been built - great to have another diligent wiki contributor!
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.
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.
Thanks @joe and @poncho1234. This info has been wiki-ed.
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?
Read about GRN.
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.
Paste link here.
Taxes are % of price and hence not directly possible.
Bill full value and apply adhoc discount after tax.
The Board Admin will need to allow it - PM @joe.
Does it have anything to do with hardcoded primary keys of any auto added primary key that starts with 1 each time?
Probably yes - try it and document it.
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.
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.
Import Transactions is not contained in any "FA 2.4.2 update". It is a plugin by itself that has not been updated as yet in the official FA pkg distribution repo. Install it and overwrite the files with their counterparts from my repo for now till the devs update the pkg in the official repo.
This post has what you need. If you need to put it in the db connection script see this post for FA 2.3 and port it accordingly into the mysql/mysqli connect scripts. @braathwaate's instructions were for PHP versions.
In your Purchase Return file, you will have a copy of the function check_data() where the error emanates. Try to capture the value of the price form field variable and check what rounding off error causes it based on PHP version, MySQL version and Apache version nuances apart from platform dependancies - mention these versions and which version of FA you are using.
https://frontaccounting.com/fawiki/index.php?n=Devel.BarCodeUsage
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.