Skip to forum content
FrontAccounting forum
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 172 of 247)
Topics by apmuthu User defined search
Posts found: 4,276 to 4,300 of 6,163
The devs have updated the FA v2.3 extensions pkg repo on 2015-03-21 and "there is just a version bump and old changes to import_items extension" which does not yet incorporate the latest fixes in my unofficial Github repo.
The Charts for chart_ar_EG-GAAP and chart_en_GB-general have not been updated from my repo and remain erroneous.
Attached is the patch for the various extensions to make it uptodate (without the attendant config and files in the _init folder in each of them).
Also the Tamil language files and the new Venezuelan Chart of Accounts files have not been inducted as also the rep_email_customers extension.
FA v2.4 pkg extensions have been proviced for Charts, Themes and Languages - replace 2.3 with 2.4 in version.php's repo array. The module extensions are not yet migrated.
Use GRN - Goods receival note. It is designed for such imports.
The "Exclude from sales" is stored in the field stock_master.no_sale and it's usage is affected by the field stock_category.dflt_no_sale.
Line 620 of includes/ui/ui_lists.inc:
$sql .= " AND !i.inactive AND !s.inactive AND !s.no_sale";
blindly checks the presence of any value and may not discern the nuances of different values for it in your design unless changed accordingly.
Other files that use this field are:
inventory\manage\item_categories.php
includes\db\items_category_db.inc
inventory\includes\db\items_db.inc
inventory\manage\items.php
Create a database for FA to use.
Create a MySQL user for FA to use to access the FA database created earlier (set all privileges for the user to access the db).
Files and Folder permissions for the FA fileset should be readable and writeable by the web server user.
The latest is in the Official Git Repo.
http://devel.frontaccounting.com/git/?p … ;a=summary
FA v2.3.23 has been released today.
Choose the settlement currency for the vendor.
Get an exchange rate entered for the date on which you book the import.
Create the direct sales invoice and a proper Goods Receival Note (GRN) for it.
Then make payment entries for it and book the expenses for the purchase.
Are you using OpenMiracle? This is the FA Forum.
Apache 2.4 has a different apache config format which must be taken into account - then FA will run okay. FA generally runs well in Apache 2.2.
If MySQL is running, just run
mysql -u root -p -e 'SHOW VARIABLES LIKE "%version%";'
Checkout the FreeBSD MySQL page.
Make sure all files and folders under the webroot of FA is owned by the webserver user for starters (secure it later).
Browse to your FA webroot and install from the browser after having setup a MySQL database and a user with all privileges for it and flushing the privileges.
Take the latest FA snapshot from the official Git Repo.
FA 2.4 is a moving target .... just stick with FA 2.3 and roll your own for now.
Read the FA Wiki..
Purchases => Supplier Inquiry - last column in searched page.
This can be done using the the Non Field DB Data method used for Bin Location in Inventory. Just put in an optional piece of text like "TID#1254352" into the memo_ field and have it parsed and used like the BinLoc pseudo field in Inventory. This would indicate your unique Tax ID number 1254352.
Take a backup. Check for the said transaction in the sql and make changes there and then upload and restore it! If anything breaks, you can always revert to the original state.
It can be added in the address of the Customer if needed.
The Non Field DB Data concept may also be used for both screen form and report requirements to modify existing ones as desired.
You may be able to use federated tables in MySQL to achieve it with a combination of user access permissions and policies. AFAIK, FA does not yet support such a feature.
A bad and yet working workaround may be to change the starting month of the active Fiscal Year temporarily....
Module is the best way to go in general. Where a report needs to be modified for use in all it's instances in the same company, then it would be better to keep the modified version in company/#/reporting/repXXX.php so that it is used when the appropriate report in the FA menu system is called. This is valid only if there are no extra parameters to be passed on from the report request form. If you need more form fields than are there in the default report request form, then make a module of it.
Give me an example of extra field you would want in the gl_trans table and you may be able to accommodate it elsewhere using the Non Field DB Data method explained in the wiki.
Custom modules for complex requirements can have their own tables linked on a 1:1 or 1:N basis with the core FA tables. This way, when an FA upgrade occurs, you will not be left standing high and dry.
Most generally:
customers masters are in crm_contacts, crm_persons, cust_branch, debtor_trans
suppliers masters are in crm_contacts, crm_persons, suppliers
selling prices are in prices
purchase prices are in purch_data
inventory are in stock_master, stock_category, item_codes, loc_stock, item_units
Refer the ERD in the Wiki for further details.
Do you want to make it positive inventory only? Do you want to avoid recalculation after switching back from Allowing negative inventory? Then manually set the value in the sys_prefs table and config.php file.
If you use the standard fonts for English without utf-8 then see that the appropriate font is available. Else use the dejave.zip file from frontaccounting.com's downloads section. The Wiki has what you need.
The rate is a double type field and may generally need to be rounded to 2 decimal places - otherwise it gets stored will a lot of decimal places unlike a float (10, 2).
The dossier can be done using Tags. Dimensions are generally used for departments / branches / locations on a global scale. Tags are for issue related transactions. Documents can also be attached to transactions.
You being a 1 man show can easily beat SAP (Slow and Painful) for small enterprises! Congrats and all the best.
Create a page in the wiki detailing your solution - it will be a nice resource for the community. Alternatively, prepare a PDF document about what changes need to be done, complete with code files and zip them and upload them somewhere and then post your link here.
Tax Accrued (Payable) and Tax Paid accounts are there for this reason.
FA currently supports only one exchange rate per day per currency. You can try to delete the rate for the day after the transaction has been performed and then put in a new one for the next transaction but the notional exchange profit and loss account will get calculated with the value in the rate table at the time of reporting.
Posts found: 4,276 to 4,300 of 6,163
