Clever Accounting's Cloud Accounting System is based on FrontAccounting. Anyone used it and if so what is different?
5,076 09/03/2014 05:25:37 am
Topic: Anyone tried Clever Accounting based on FA? (5 replies, posted in Installation)
5,077 09/03/2014 05:23:44 am
Re: Error in inventory valuation report (45 replies, posted in Report Bugs here)
Then Inventory Valuation Report must be right as on the day of preparing the report only. Like Joe stated, "The item cost price can be manually adjusted in the Items and Inventory tab" temporarily for a different past dated report!
5,078 09/03/2014 04:12:53 am
Re: Ideal Inventory Management For Electronic Products Manufacturing (4 replies, posted in Manufactoring)
Is such a manual now available? This is the only one so far.
5,079 09/03/2014 04:08:15 am
Re: MySQL "INNER JOIN" change in 5.0.12 (2 replies, posted in Report Bugs here)
Are there any more such constructs in FA now (function is now at line 1613)? In such cases, do the referred corresponding fields in the tables within those in the parantheses get automagically equated?
In this case, the WHERE clause states:
chart.account_code=acc.account_codeshould it be
chart.account_code=acc.account_code AND chart.account_code=type.account_codeinstead?
5,080 09/03/2014 03:37:48 am
Re: Quick Entries - Journal Entry (2 replies, posted in Banking and General Ledger)
Refer the FA Wiki page on Quick Entries and specifically an example of expenses screenshot.
5,081 09/03/2014 02:40:55 am
Re: Primary Development Repo from mid May 2013 - Git (17 replies, posted in Announcements)
I did not take it from the official git with fetch. I took each release and created my github repo. In recent times I manually extract the files from the official git / hg repo (which ever is current) and then test them in batches when I have the time and then merge it into my repo manually. This method was initially chosen to help in migrating from one version to another. I had published the widely used OpenVZ template publicly till v2.2.11 and many users needed to migrate to the current version.
Changes are generally few and far between except when a release happens.
There may be one or more private extension repos where only "encapsulated" code gets into the FA deployment - a conscious decision on the part of the devs. This way they have control of the community and the code and possibly helps support the development and makes sure the community does not get sidetracked / splintered / misguided.
Furthermore, the devs recommend that all contributions go to their designated email address and not into this forum. This may have something to do with legalese and/or premium deliverables in support of the project.
The end result is that we get to have cool working code well preserved and developed over several years - can't complain at all!
My github repo was made so as to enable the community to
develop extensions on their own and
fix / enhance existing ones and
also to have their own locally hosted extension repos.
5,082 09/02/2014 05:20:34 am
Re: Items vs. Foreign Item Codes (1 replies, posted in Items and Inventory)
In Items and Inventory -> Items the primary database entries (assuming company #2) are:
insert into `2_item_codes`(`id`,`item_code`,`stock_id`,`description`,`category_id`,`quantity`,`is_foreign`,`inactive`)
values
(1,'TUNEV1','TUNEV1','A Tune a Day for Violin - Book 1',1,1,0,0);
insert into `2_loc_stock`(`loc_code`,`stock_id`,`reorder_level`)
values
('DEF','TUNEV1',0);
insert into `2_stock_master`(`stock_id`,`category_id`,`tax_type_id`,`description`,`long_description`,`units`,`mb_flag`,`sales_account`,`cogs_account`,`inventory_account`,`adjustment_account`,`assembly_account`,`dimension_id`,`dimension2_id`,`actual_cost`,`last_cost`,`material_cost`,`labour_cost`,`overhead_cost`,`inactive`,`no_sale`,`editable`)
values
('TUNEV1',1,2,'A Tune a Day for Violin - Book 1','A Tune a Day for Violin - Book 1 by C. Paul Herfurth packed full of lessons, illustrations, fingering charts, daily practice records, test questions, and manuscript paper for homework.','each','B','4010','5010','1510','5040','1530',0,0,0,0,0,0,0,0,0,0);When the sales price gets entered:
insert into `2_prices`(`id`,`stock_id`,`sales_type_id`,`curr_abrev`,`price`)
values
(1,'TUNEV1',1,'SGD',12);5,083 09/02/2014 05:13:56 am
Re: How can I setup a company that sells energy bars? (7 replies, posted in Manufactoring)
For your followup question please refer Sales Kits in the FA Wiki.
All of the first 3 need to be setup in your FA instance to achieve what you want. Set up a No Tax entry in the taxes. There is also a stock location transfer method that can be used to avoid any vendor transfer transactions.
Company A defines their inventory stock items and Sales Kits composition of such items
Company A transfers individual component stocks to their storage location in Company B
Company B levies labour charge on Company A (accounted for as a vendor bill in Company A 's accounts)
Simultaneously, Company A now takes back the finished goods from their storage location in Company B back into Company A's main location, but this time it is in units of Sales Kits (components that make a single billable item).
Company A now sells the "Sales Kits" bunched component items set to their customers.
How to do all of this is well documented in the FA Wiki.
A related situation using Manufacturing / Assembling is this forum post.
5,084 09/02/2014 05:05:19 am
Re: Primary Development Repo from mid May 2013 - Git (17 replies, posted in Announcements)
The HG Repo is quite current with a commit made less than a day ago. It is also mirrorred faithfully on the Official Git but my unofficial github repo will lag a while behind as I update it only after vetting the changes and and when I have the time to do it.
Choosing GitHub over SF's Git repo is a matter of choice:
ease in mirrorring within SF and
the dev's comfort level besides
they may as a policy not like unbridled GitHub forking that may cause identity crisis and
splitting of the userbase.
5,085 09/01/2014 07:14:59 am
Topic: Items vs. Foreign Item Codes (1 replies, posted in Items and Inventory)
In Items and Inventory -> Items there is no place to enter the open stock of the Item and the item_code = stock_id and the hardcoded quantity = 1 whilst is_foreign = 0.
In Items and Inventory -> Foreign Item Codes there is a place to enter stock and the item_code can be blank or be set to the ISBN13 code (or EAN/UPC) whilst the stock_id can be non unique since the primary key is the id field and the is_foreign = 1.
Both these entries get into the same table #_items and are treated individually and both forms have the category field - so the same stock_id can belong to 2 different categories if they come from different forms above.
5,086 08/31/2014 12:15:51 pm
Re: Amount left to allocate is not settled after payment to the customer (4 replies, posted in Accounts Receivable)
Wiki-ed it.
5,087 08/31/2014 12:12:10 pm
Re: Problem with saving Json encoded datas. (2 replies, posted in Report Bugs here)
Use escape character "\"
5,088 08/31/2014 12:09:59 pm
Topic: FA Wiki Updated with balance Reports Screenshots (0 replies, posted in Reporting)
The Reports page on the FA Wiki is now updated with 33 balance Screenshots - hope this helps potential FA users quickly decide to jump off the fence and into the FA lap.
5,089 08/31/2014 12:05:26 pm
Topic: Reports display in newer Firefox browsers (0 replies, posted in Reporting)
There is a limitation of the JavaScript-based PDF Viewer in FireFox which currently does not support all the features of the Adobe plugin (or stand-alone version of Adobe Reader). You can test that theory using the steps in this article: How to disable the built-in PDF viewer and use another viewer.
While an end user can switch around among viewers by changing their Firefox options, unfortunately there currently is no way for websites to detect which viewer is in use and assist visitors in a personalized manner. I think for now you may need to recommend that Firefox users use the above article for assistance if more complex PDFs do not render as expected.
You can set the pdfjs.disabled pref to true on the about:config page to disable the build-in PDF viewer.
You can check the value of the plugin.disable_full_page_plugin_for_types pref on the about:config page and remove the application/pdf part if present or reset the pref to the default via the right-click context menu.
http://kb.mozillazine.org/about:config
See also:
https://support.mozilla.org/kb/view-pdf-files-firefox-without-downloading-them
5,090 08/31/2014 11:57:16 am
Re: Report Selector Orientation (Portrait, Landscape) implmented in FA 2.4 (7 replies, posted in Reporting)
Hope the recent sync of v2.3.21 to v2.4 unstable does this.
5,091 08/30/2014 07:26:14 pm
Re: Forum server breakdown during the last day. (4 replies, posted in Announcements)
The Official Git Repo is now uptodate with the Mercurial one. Thanks.
5,092 08/30/2014 07:23:46 pm
Re: Clone a company minus the transactions? (4 replies, posted in Installation)
Import Inventory Items is an extension for FA. It can be installed and activated from within FA. The pertinent files are available for analysis / forking at my unofficial GitHub repo. The format of the import CSV would be the same as the export one and can be culled from the extension.
5,093 08/30/2014 07:20:24 pm
Re: Looking for partners to do FA for PHilippine-based busineses (3 replies, posted in Jobs wanted/offered, non-free offers)
The Support page on the FA Wiki has a few companies that might be interested in assisting you. Some will even provide you virtualised hosting as well.
5,094 08/30/2014 07:14:52 pm
Re: Redesign invoice format (6 replies, posted in Jobs wanted/offered, non-free offers)
The image is quite blurred. The letter head (Header of the Invoice) already has the supplier name and details - putting it above the client details seems redundant.
5,095 08/30/2014 06:49:03 pm
Re: How can I setup a company that sells energy bars? (7 replies, posted in Manufactoring)
Company A sells ingredients, packaging to Company B on no tax (escrow).
Company A buys back the finished product at the same cost plus the labour charge from Company B.
Company A now adds on shipping and sells it with tax to it's client.
No need to setup any manufacturing at all in Company A.
5,096 08/21/2014 09:59:48 pm
Re: Accessing links gives 403 if no parameters are sent (1 replies, posted in Report Bugs here)
Check your Apache conf file and your .htaccess file for mod_rewrite errors.
5,097 08/21/2014 09:33:59 pm
Re: New to the forum - Introduction (1 replies, posted in Jobs wanted/offered, non-free offers)
You might want to update your codebase with recent fixes.
5,098 08/21/2014 09:23:23 pm
Re: how i add or delete some item from menu ? (2 replies, posted in Setup)
Lines 15 to 21 of frontaccounting.php:
include_once($path_to_root . '/applications/customers.php');
include_once($path_to_root . '/applications/suppliers.php');
include_once($path_to_root . '/applications/inventory.php');
include_once($path_to_root . '/applications/manufacturing.php');
include_once($path_to_root . '/applications/dimensions.php');
include_once($path_to_root . '/applications/generalledger.php');
include_once($path_to_root . '/applications/setup.php');Comment out which ever tab you do not want. The first one (applications/customers.php is sales).
Way down in the same file comment out the applications ($this->add_application) you don not want:
function init()
{
$this->menu = new menu(_("Main Menu"));
$this->menu->add_item(_("Main Menu"), "index.php");
$this->menu->add_item(_("Logout"), "/account/access/logout.php");
$this->applications = array();
$this->add_application(new customers_app());
$this->add_application(new suppliers_app());
$this->add_application(new inventory_app());
$this->add_application(new manufacturing_app());
$this->add_application(new dimensions_app());
$this->add_application(new general_ledger_app());
hook_invoke_all('install_tabs', $this);
$this->add_application(new setup_app());
}In applications/customers.php comment out which ever add_module or add_lapp_function or add_rapp_function you do not want. The rapp is Right side located function and lapp is left side located function.
5,099 08/21/2014 09:20:18 pm
Re: Serial and Batch Tracking (1 replies, posted in Items and Inventory)
What you need is a custom MIS that takes in data from various sources and provides you a dashboard for decision making.
PM me for business analytics.
5,100 08/21/2014 09:16:03 pm
Re: Paid Development Required (2 replies, posted in Jobs wanted/offered, non-free offers)
Assume all goods are duty paid - those actually not duty paid would be having a duty payable account entry.