2,776

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

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,778

(27 replies, posted in Banking and General Ledger)

What is the base currency of your company?

Yes

Give the link like http://www.yourdomain.tld/<path_to_fa>/Screenshot_csv_source.png

2,781

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

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

(11 replies, posted in Accounts Receivable)

That's how the wiki has been built - great to have another diligent wiki contributor! smile

2,784

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

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

(11 replies, posted in Accounts Receivable)

Thanks @joe and @poncho1234. This info has been wiki-ed.

2,787

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

Read about GRN.

2,789

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

Paste link here.

2,791

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

(4 replies, posted in Installation)

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.

2,795

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

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

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.

2,798

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

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.

2,799

(1 replies, posted in FA Modifications)

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.

2,800

(1 replies, posted in FA Modifications)

https://frontaccounting.com/fawiki/index.php?n=Devel.BarCodeUsage