@joe: Should we not backport the missing parameter fix from FA v2.4 commit to v2.3? rep107 has an extra request form field "Customer Filter" prior to the "Orientation" field.
4,376 02/17/2015 07:50:04 pm
Topic: Backporting rep107 fix in reporting.inc (2 replies, posted in Reporting)
4,377 02/17/2015 07:32:16 pm
Re: Importing customer csv data in FA v2.3.6 (65 replies, posted in Setup)
1. FA 2.4 is still a work in progress with basic FA v2.3 functionality merged into it and some new features being implemented. The db schema is subject to change and quite a few unused fields in FA v2.3 will be removed and some new ones are now being introduced. For all but very basic small installs, FA 2.4 will be trouble at the moment. Progress on FA 2.4 has been slow (yes, years in the making...) and in bursts and spurts when the key dev @itronics gets the time. Meanwhile changes in FA 2.3 need to be incorporated in FA 2.4 from time to time as well. If you know what you are doing and can manage a separate fork of 2.4 for your trajectory, then it will be suitable. If only basic usage is envisaged and no upgrades are needed, FA 2.4 might just fit the bill.
2. You need items in inventory before they can be chosen to be ordered! If all items in your supplier invoices need not be tracked, then they can be listed as a Service Item with editable description. If you do not wish to track inventory at all (Service Item) and avoid purchase order generation itself, then just maintain journal vouchers - manually compute taxes if any....
4,378 02/17/2015 07:22:40 pm
Re: Dashboard Install info and Screenshots in Wiki (4 replies, posted in Modules Add-on's)
The said Line 98 in includes/db/connect_db.inc is:
return mysql_fetch_array($result);
When the $result is false, ie., no rows from the source SELECT statement, this error results in some PHP versions. There are quite a few functions in the same file that have the same issue. They can be overcome with:
if ($result !== false) return mysql_fetch_array($result);
else return false;
The actual function mysql_fetch_array() above can be replaced with the appropriate function in each of the affected functions in the said file.
4,379 02/17/2015 07:14:25 pm
Re: Importing customer csv data in FA v2.3.6 (65 replies, posted in Setup)
@instance & @ahrtgnbn: Thankyou for your kind words. With 2 dedicated Canadians on the team, FA is now set to scale great heights!
OFX (Open Financial eXchange) can be used directly in FA as it is XML. An extension can be hammered out for data interchange between FA and OFX. That way there need be no CSV conversions / import / export rigmarole.
Where 1-way data transfer is envisaged, the target database can have the affected tables replaced as views of queries based on the source database tables. That way there will be no need for any data exchange at all.
When implementing Inventory, the foreign item codes may cause the item_code tables to have different item_codes for the same stock_id which is intentional to enable different vendors to map their same products onto common stock_id of FA and such item_codes will be used for ordering from the respective suppliers.
FA does not have history of item prices in it's price lists but all goods sold / purchased will have such history in their transaction records.
The wiki will need good cross referencing within it's pages and between the wiki and the forum threads besides summarizing the distilled info from the forums into properly linked wiki pages in context to enable easy and intuitive search / navigation.
When time permits, do test out the FA v2.4 as it is now undergoing some final testing before release. There is a separate thread on it's developmental progress.
4,380 02/17/2015 01:27:54 pm
Re: Front Accounting Sync with vTiger CRM (1 replies, posted in FA Modifications)
Follow this post. The vTiger devs would be helpful if you subscribe to their service.
4,381 02/17/2015 01:26:10 pm
Re: Customer / Supplier type (1 replies, posted in Accounts Payable)
Sales Groups were introduced (settable in the Customer branch only) for filtering Customers but is currently being used only for recurring invoice generation and will be available in reports in FA 2.4 (see another post on this).
4,382 02/17/2015 01:23:49 pm
Re: Page numbering on sales invoice PDF's (12 replies, posted in Accounts Receivable)
Just remove the page number for now or keep resetting the page number in the report when a new invoice is generated.
4,383 02/17/2015 01:22:45 pm
Re: How to add Item's Old Sales Price and New Sales Price? (5 replies, posted in Items and Inventory)
FA does not have PriceList history but sales price history can be culled out from the invoices. You will have to manually store the old price value in the long_description field of the item in stock_master table.
4,384 02/17/2015 01:21:07 pm
Re: Any CRM project out there for FA? (10 replies, posted in Wish List)
Modules? Only Tables and specific fields in them. eg., enter all customers in FA and have them mirrorred in vTiger....
4,385 02/17/2015 01:15:00 pm
Re: Incentive or Penalty while receiving goods (13 replies, posted in Accounts Payable)
The code appears incomplete since the "incen_fine" form variable is not defined (did you mean to replace the 'mahamai' with a single +Incentive / -Fine variable).
Any reason why you would want to comment out the $taxes and $tax_total assignments and prevent it forming part of the $display_total?
I would expect the last part of the function display_po_items() to be:
start_row();
label_cell(_("Incentive / -Fine"), "colspan=$colspan align=right");
small_amount_cells(null, 'incen_fine', price_format(get_post('incen_fine',0)));
label_cell('', 'colspan=2');
end_row();
// $display_sub_total = price_format($total + input_num('incen_fine'));
// label_row(_("Sub-total"), $display_sub_total, "colspan=$colspan align=right","align=right", 2);
$taxes = $order->get_taxes(input_num('freight_cost'));
$tax_total = display_edit_tax_items($taxes, $colspan, $order->tax_included, 2, $order->trans_type==ST_SUPPINVOICE);
$display_total = price_format($total + input_num('freight_cost') + $tax_total + input_num('incen_fine'));
start_row();
label_cells(_("Amount Total"), $display_total, "colspan=$colspan align='right'","align='right'");
$order->order_no ? submit_cells('update', _("Update"), "colspan=2 align='center'", _("Refresh"), true)
: label_cell('', "colspan=2");
end_row();
end_table(1);
div_end();
}
But where does the 'incen_fine' get stored and how?
4,386 02/17/2015 07:46:50 am
Re: Front Accounting Sync with vTiger CRM (4 replies, posted in Setup)
Use http://www.anterp.com 's CartSnap / vTiger sync or state what parts you want to sync and in which direction(s). You can use any of the several REST / SOAP APIs listed in the wiki to achieve it. In some simple cases just a cron job executing standard sqls or triggers in the db can also achieve it.
4,387 02/17/2015 07:44:50 am
Re: Importing customer csv data in FA v2.3.6 (65 replies, posted in Setup)
When done, don't forget to submit it here and to the project to assist others.
4,388 02/17/2015 07:27:30 am
Re: Edit or delete invoice without price (Gift) (3 replies, posted in Accounts Receivable)
Use Stock Adjustment.
4,389 02/17/2015 07:26:14 am
Re: bank accounts (16 replies, posted in Banking and General Ledger)
Hope this suffices:
4,390 02/16/2015 11:24:40 pm
Re: exchange rates not updating automatically (9 replies, posted in Banking and General Ledger)
Attempting to pay a foreign supplier (in non default currency of the company) too should trigger the exchange rate acquisition.
4,391 02/16/2015 11:01:54 pm
Re: exchange rates not updating automatically (9 replies, posted in Banking and General Ledger)
@ckrosco: In your first post here you stated
I have to manually update the currencies every day.
Does this mean that you entered the exchange rate manually or got it from the FA exchg rate provider by manually clicking the get rate button?
4,392 02/16/2015 04:22:53 pm
Re: Any CRM project out there for FA? (10 replies, posted in Wish List)
FA now has a rudimentary CRM in place that should be good for basic use. EMail ID, Phone Phone 2, Fax, Notes, etc.
All Suppliers, Customers, Customer Branches, etc have their persons in crm_persons and crm_contacts tables linked to the appropriate FA table entities.
Documents can be attached to various transactions as well.
Only form letters / emails are not in FA's CRM.
4,393 02/16/2015 04:19:30 pm
Re: Incentive or Penalty while receiving goods (13 replies, posted in Accounts Payable)
It would be nice if you provided the changed files (or actual workflow menu click sequence) so that it may be included in the next version natively.
4,394 02/16/2015 10:05:41 am
Re: Single and double quote in Item Description (7 replies, posted in Items and Inventory)
This needs to be fixed in FA 2.3 itself so that there is no carry forward errors into FA 2.4.....
4,395 02/16/2015 10:04:07 am
Re: Incentive or Penalty while receiving goods (13 replies, posted in Accounts Payable)
Provide the changed code to test.
4,396 02/16/2015 06:43:54 am
Re: bank accounts (16 replies, posted in Banking and General Ledger)
@bobloblian: Just check if the wiki is worded as desired:
4,397 02/16/2015 06:20:31 am
Re: Incentive or Penalty while receiving goods (13 replies, posted in Accounts Payable)
If the incentive is calculatable from the quantity, then a enable/disable flag (0/1) is sufficient for it and an amount variable for delays if it is variable with no dependancy will suffice. Better to have a quick entry for those transactions where these issues arise with no fields necessary in the tables. The fields can be avoided altogether if quick entries are used except that manual computation will be necessary.
4,398 02/16/2015 06:14:29 am
Re: 0-VAT again (44 replies, posted in Reporting)
That is indeed a nice expose on the ERD lacunae in FA.
@joe: In FA 2.4, we need to replace the primary key "counter" in gl_trans table with one containing 2 new fields - "Transaction_No" and "Transaction_Line_No".
Currently, the gl_trans table's field named 'type' can have more than one 'type_no' and 'type_no' can have more than one 'type'.
Using 'type' for a field name!
4,399 02/16/2015 03:09:50 am
Re: exchange rates not updating automatically (9 replies, posted in Banking and General Ledger)
Try to uncheck the auto-update, save, tick the auto-update, save and see what happens. Actually, there should be only one update each day for each currency.
From the comments on line 297 in includes/ui/ui_view.inc:
"autoupdate means use remote service & store exrate on first transaction."
Hence there is no cron job used here!
4,400 02/15/2015 05:19:54 pm
Re: Work Order, How does this work? (8 replies, posted in Manufactoring)
The demo is at:
http://demo.frontaccounting.eu/