The extensions are on my personal Git Hub Repo at:
https://www.github.com/apmuthu/frontaccounting
5,301 11/07/2013 12:01:11 pm
Re: Auth_LDAP repo location? (5 replies, posted in Modules Add-on's)
5,302 11/07/2013 11:52:50 am
Re: textcart - Purchasing error (4 replies, posted in Modules Add-on's)
The textcart extension uses the "&$_SESSION" term in quite a few places - do they all have to be changed?
Line 412 in modules/textcart/purchasing/po_entry_items.php (also present in corresponding core file modules/purchasing/po_entry_items.php):
$cart = &$_SESSION['PO'];
Line 87 in modules/textcart/inventory/adjustments.php
$adj = &$_SESSION['adj_items'];
Line 83 in modules/textcart/inventory/transfers.php
$tr = &$_SESSION['transfer_items'];
In modules/textcart/sales/sales_order_entry.php
Line 295:
$cart = &$_SESSION['Items'];
Line 244:
$cart = &$_SESSION['Items'];
5,303 11/07/2013 11:42:39 am
Re: Simplified Chinese (1 replies, posted in Translations)
Thankyou @ombhrum. It is indeed very nice of you to do so.
There are two existing (Traditional ?) Chinese translations namely
zh_CN
and
zh_TW
in FA presently that can be installed from the FA Repo.
Now that FA v2.3.19 has been released, you might want to update the translations for your Simplified Chinese as well.
5,304 11/07/2013 11:29:46 am
Re: Release 2.3.19 (21 replies, posted in Announcements)
I handle my own FA Git Repo on GitHub only and is updated only when I have the time and is mostly done from release to release with primary focus on the extensions' files besides enabling easy forking within the Github Browser GUI.
The Official Git Repo mirror of the main Hg Repo on SF is managed by Janusz and has not been updated in more than 10 days.
Upgrade from FA v2.3.18 to v2.3.19 can be done by uploading the changed files attached in this post.
Post release fixes are in the Mercurial repo.
5,305 11/04/2013 02:34:09 am
Re: Foreign Exchange Gain Appearing for no reason (11 replies, posted in Accounts Payable)
Does not yet show up in the official Git Repo. Present in Mercurial though. Get the Mercurial Snapshot of the stable branch here. The unstable branch snapshot is here but it's changelog is stuck at May 2013 though more recent changes have been merged into it. We would need more testing on the unstable branch and it would be nice if mirrored on the official Git site.
5,306 11/03/2013 12:00:06 pm
Re: Add a "Return To" link to Login and Logged out screens. (4 replies, posted in Setup)
Joe/Janusz -> This would be a nice to include into the FA core code with the "return to" link to be provided in the config.php and displayed if not false (backward compatible)
5,307 11/03/2013 11:40:55 am
Re: Chinese version of Chart of Accounts are incorrect (18 replies, posted in Misc. Charts of Accounts)
For those interested in providing the Chinese CoA, the English translation would be:
2013 New Chart of Accounts
No. Name of the sequence number of accounts Accounts Scope
An asset class
11,001 Cash
21,002 Bank deposits
31,003 Bank balances with central banks dedicated
41,011 Due from banks bank-specific
51015 Other Monetary Fund
61021 Private Securities settlement provisions
71,031 Refundable deposits Financial Shared
81,051 Placements with financial shared
91101 -trading financial assets
101,111 resale of financial assets Financial Shared
111,121 Notes receivable
121,122 Receivables
131,123 Prepayments
141,131 Dividends receivable
151,132 Interest receivable
161,211 savings accounts to protect the insurance -specific
171,221 Accounts Insurance Subrogation section dedicated
181,222 Accounts receivable from reinsurers dedicated Insurance
191,223 receivable reinsurance unearned amount that an insurance -specific
201,224 Reinsurers Insurance Private insurance reserves
211,231 Other receivables
221 241 Provision for bad debts
231,251 discounted bank-specific assets
241,301 share lending banks and insurance
251 302 Loan loss provisions banking and insurance shares
261,311 Securities banking and insurance cashing shared
271321 agency business assets
281401 material procurement
291,402 materials in transit
301,403 Raw materials
311,404 Material cost difference
321,406 stock merchandise
331,407 delivered goods
341,410 net price of goods
351411 consigned processing materials
361412 packaging materials and consumables
371,421 expendable barter agricultural assets dedicated
381,431 private contractors working materials, construction
391441 precious bank-specific
401,442 Repossessed assets Financial Shared
411,451 loss goods insured dedicated
421 461 Provision for inventories
431,501 Prepaid expenses
441,511 dedicated separate account assets Insurance
451,521 Held-to -maturity investments
461 522 Impairment of held-to -maturity investments
471 523 Available for sale financial assets
481 524 Long-term equity investments
491 525 Long-term equity investment impairment
501 526 Investment property
511 531 Long-term receivables
521,541 Unearned finance income
531,551 Statutory deposits insured dedicated
541,601 Fixed assets
551,602 Accumulated depreciation
561 603 Impairment of fixed assets
571,604 Construction in progress
581605 Construction materials
591 606 Disposal of fixed assets
601,611 Finance leases Assets leased dedicated
611,612 unguaranteed residual value leasing dedicated
621,621 agricultural productive biological assets dedicated
631,622 Accumulated depreciation of productive agricultural biological assets dedicated
641623 Agricultural dedicated public welfare biological assets
651,631 private oil and gas oil and gas assets
661,632 private oil and gas accumulated depletion
671,701 Intangible Assets
681,702 Accumulated amortization
Impairment of intangible assets 691 703
701,711 Goodwill
711 801 Long-term deferred expenses
721 811 Deferred income assets
731,901 pending loss of property
Second, the debt category
742,001 Short-term borrowings
752,002 Deposits Financial Shared
762,003 Funds borrowed financial shared
772,004 bank dedicated to the Central Bank
782,011 private banks to banks
Bank deposits 792,012 dedicated
802,021 special discounted liabilities Bank
812101 -trading financial liabilities
822 111 Financial assets specifically the financial share buyback
832,201 Notes payable
842,202 Accounts payable
852,205 Receipts in advance
862,211 Accrued payroll
872 221 Taxes payable
882,231 Dividends payable
892,232 Interest payable
902,241 Other payables
912 251 Insurance policyholder dividends payable dedicated
922,261 Accounts payable to reinsurers Insurance dedicated
932,311 private securities brokerage deposits
942,312 securities underwriting agency securities and banking shares
952313 models cashing securities securities and banking shares
962314 agency business liabilities
972,401 Accrued expenses
982,411 Accrued liabilities
992 501 Deferred revenue
1,002,601 Long-term loans
1,012,602 long-term bonds
1,022,701 Unearned payments insurance special
1,032,702 Insurance Private insurance reserves
1042711 Private Insurance policyholders' deposits
Separate account liabilities 1,052,721 Private Insurance
1,062,801 Long-term payables
1072802 unrecognized financing charges
1082811 Special payables
1,092,901 Deferred income tax liabilities
Three common classes
1103001 cleared funds dedicated bankers
1,113,002 Foreign exchange trading in financial shares
1,123,101 Derivatives
1133201 hedging instruments
1143202 hedged item
Fourth, the owners' equity
1,154,001 Paid-in capital
1,164,002 Capital surplus
1,174,101 Surplus reserve
1,184,102 General reserve financial shared
1,194,103 Profit for the year
1,204,104 Profit Distribution
1,214,201 treasury shares
Five , the cost category
1225001 production costs
1,235,101 Manufacturing expenses
1,245,201 labor costs
1,255,301 R & D expenditures
1265401 construction construction contractor dedicated
1,275,402 project settlement construction contractor dedicated
1,285,403 mechanical operations the contractor dedicated
Six , profit or loss category
Income from principal operations 1,296,001
1,306,011 Interest income financial shared
1,316,021 Fee income financial shared
1,326,031 Insurance premiums special
1,336,032 reinsurance premium income of the insurance -specific
1,356,041 Rental income Rental Special
1,356,051 Other operating income
1,366,061 Exchange gains and financial Dedicated
1,376,101 Changes in fair value
1,386,111 Investment income
1,396,201 Reinsurers' share of insurance reserves Private Insurance
1,406,202 Reinsurers' share of claims paid private insurers
1,416,203 Reinsurers' share of special expenses insurance
1,426,301 Non-operating income
1,436,401 Cost of sales
1,446,402 Other operating expenses
1,456,405 Business tax and surcharges
1,466,411 Interest expense finance Shared
1,476,421 Financial Shared Service charges
1,486,501 extract unearned payments insurance special
1496502 summarized Insurance Private insurance reserves
1,506,511 Insurance claims paid special
1516521 Private Insurance Policyholder dividends
1,526,531 Surrenders Insurance dedicated
1,536,541 Insurance premiums ceded dedicated
1546542 reinsurance expenses
1,556,601 Selling expenses
1,566,602 Administrative expenses
1,576,603 Finance costs
1,586,604 Exploration expenses
1,596,701 Asset impairment losses
1,606,711 Non-operating expenses
1,616,801 Income tax
1,626,901 prior period adjustments
Above is from Google Translate and the numbers are to considered as:
1,626,901 => 162 901
5,308 11/03/2013 11:32:51 am
Re: barcode integration possible in FrontAccounting (10 replies, posted in Wish List)
Items and Inventory => (Maintenence) Foreign Item Codes
Refer Wiki:
https://frontaccounting.com/fawiki/index.php?n=Help.ForeignItemCodes
5,309 11/03/2013 03:28:18 am
Re: Can't install extension (15 replies, posted in Installation)
It may be simpler to remove the "\0" in the filenames or use an appropriate option in the extraction program used.
All extension files in extracted form are available at my github repo.
5,310 11/03/2013 03:25:59 am
Re: cancel a deposit/opening balance (9 replies, posted in Banking and General Ledger)
Make sure this checking bank account is not an overdraft / loan account.....
5,311 11/03/2013 03:24:36 am
Re: how to hide checking account? (3 replies, posted in Setup)
Could be a deep design decision and the need to Keep It simple S... that no one will be interested to spend time on now at least not before the release of v2.4.x
5,312 11/03/2013 03:18:13 am
Re: Prevent same user logged in simultaneously (14 replies, posted in Setup)
Multiple logins using same password can be implemented only when sessions are stored in the database and the date and time, IP and unique browser signature must be stored as well within it to verify.
Otherwise, the mere logging out of all existing sessions for the currently logged in user can be implemented if the end-users are willing to accept getting thrown out of their legitimate first initiated sessions! In this case, just issue a logout to every existing session for the same user and then allow the current request to login as that user. How it is done will need to enable the script to snoop into others sessions while being inside the requester's one. Recreation of a user persistence key may be one way though where it would propagate into the session array.
The moot question would be why should anyone share their password at all and not change it frequently enough to avoid this situation in the first place!
5,313 10/28/2013 10:34:23 am
Re: Remove some items from setup tab (13 replies, posted in FA Modifications)
1. Export existing company and view the sql and note the table prefix - say ("0_")
2. Create new company and mote it's table prefix to be say ("1_")
3. Edit the sql from step 1 above and replace the table prefix with that of the newly created company
4. Restore the edited sql into the newly created comapny
5. Restore the sql/en_US-new.sql file into the default first company and change the admin password
6. Set the $hide_inaccessible_menu_items = 1; in config.php
Use the newly created company as your real company.
Use the default company as the control company.
5,314 10/28/2013 10:26:47 am
Re: cancel a deposit/opening balance (9 replies, posted in Banking and General Ledger)
How did it become negative? FA requires that the Cash/Checking account always be positive.
5,315 10/28/2013 10:25:01 am
Re: how to hide checking account? (3 replies, posted in Setup)
User based Account restriction is not implemented in FA as yet. I do not think it should be done since then the users may not be able to see transactions that involve the checking account.
5,316 10/28/2013 10:22:13 am
Re: God create human kind and human made excuse (8 replies, posted in Modules Add-on's)
You had installed the Dashboard Theme.
You need to install the Dashboard Module as well and then activate it. Only afterwards, you should choose the Dashboard theme for the user.
Hence:
1. Choose some other theme (default)
2. Install Dashboard Module from default company
3. Activate the Dashboard Theme for the target (maybe even current one if so needed) company
4. Login to the target company (if different from default one)
5. Change theme to Dashboard theme for logged in user
6. You may need to logout and then login and possibly clear browser cache and server cache (company/*/js/*.js)
5,317 10/28/2013 10:17:08 am
Re: I want to create Chart Of Accounts for Morocco (6 replies, posted in Misc. Charts of Accounts)
Go ahead - paste the Morroccan CoA data here. Use the code tags within square brackets see how to use BBCode.
5,318 10/28/2013 10:12:44 am
Re: Can't install extension (15 replies, posted in Installation)
The said extension's files are available at:
https://github.com/apmuthu/frontaccounting/tree/master/extensions/Extensions/import_multijournalentries
@kfrance: Please notify which files had the null characters in their names.
5,319 10/28/2013 10:02:10 am
Re: Apply interest charges to overdue payments (4 replies, posted in Setup)
A trigger can be setup in the database that runs when a certain condition is met. This trigger can auto populate the interest records.
5,320 10/28/2013 10:00:11 am
Re: Cannot place a Purchase Order (19 replies, posted in Accounts Payable)
If you create a new currency make sure the company currency and the supplier currency be what they should be and that the exchange rates be set anew with "1" being the rate of the company default currency. Logout then and clear cache - possibly even the company cache (company/*/js/*.js) and then see if it persists.
5,321 10/28/2013 09:57:10 am
Re: Prevent same user logged in simultaneously (14 replies, posted in Setup)
If a computer hung when using FA, then the session would become stale in time, but the user can just reboot at once and then login again, otherwise the stale session would lock out any login if based on existing valid sessions being alive.
Hence, keep passwords safe and make and get staff to use separate usernames for audit trail.
Social engineering / hacking (looking for passwords over the user's shoulder as they are being typed) and looking thru CCTV footage should by now be well understood as they have been shown in movies / TV serials quite commonly.
5,322 10/28/2013 09:49:53 am
Re: Add a "Return To" link to Login and Logged out screens. (4 replies, posted in Setup)
access/login.php
access/logout.php
5,323 10/28/2013 09:45:05 am
Re: System no record data (1 replies, posted in Installation)
Create a file called faillog.php in the webroot's tmp folder and make the file writeable by the webserver user.
5,324 10/28/2013 09:26:59 am
Re: Return authorization lable (1 replies, posted in Accounts Receivable)
Approval process in FA needs to be made as a separate module for each context it is desired to be in. In this case, the return reference would be the return entry's voucher number.
5,325 10/28/2013 09:24:54 am
Re: The entered transaction does not exist or cannot be voided (7 replies, posted in Report Bugs here)
Cash Account should always be in debt to every account who provided it the cash in the first place. Hence in FA, is debit balance shown as positive?