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,401 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)
4,402 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,403 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,404 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,405 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,406 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,407 02/17/2015 07:26:14 am
Re: bank accounts (16 replies, posted in Banking and General Ledger)
Hope this suffices:
4,408 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,409 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,410 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,411 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,412 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,413 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,414 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,415 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,416 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,417 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,418 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/
4,419 02/15/2015 05:12:24 pm
Re: bank accounts (16 replies, posted in Banking and General Ledger)
Lines 36 to 41 in gl/manage/bank_accounts.php:
if ($Mode=='ADD_ITEM' && (gl_account_in_bank_accounts(get_post('account_code'))
|| key_in_foreign_table(get_post('account_code'), 'gl_trans', 'account'))) {
$input_error = 1;
display_error(_("The GL account selected is already in use. Select another GL account."));
set_focus('account_code');
}
Line 39 above can have the error message modified as @joe stated or the if statement modified to be more tolerant like:
if ($Mode=='ADD_ITEM' && (gl_account_in_bank_accounts(get_post('account_code')) )) {
$input_error = 1;
display_error(_("The GL account selected is already in use. Select another GL account."));
set_focus('account_code');
}
4,420 02/15/2015 10:38:01 am
Re: bank accounts (16 replies, posted in Banking and General Ledger)
@joe: The error string would be quite explanatory, but what was the need to check if there were transactions prior to it's assignment to the Bank Account? Is it not sufficient to check if it was just already allotted to some other Account?
4,421 02/15/2015 10:35:30 am
Re: Incentive or Penalty while receiving goods (13 replies, posted in Accounts Payable)
Provide an example of the 2 fields envisaged - are they different for each GRN or only their values are different for each GRN or they have some relationship (calculatable formula) with existing constants / field values?
You might want to experiment with manually entered values into the sys_prefs table and / or use special charge / service items in the GRN.
Checkout the screenshot in the wiki and make a mockup of what you want and link it in here.
4,422 02/15/2015 10:24:19 am
Re: Sorting the Outstanding work order screen...or any option for filters (19 replies, posted in Manufactoring)
Upgrade your install by overwriting with the changed files from this post.
4,423 02/15/2015 10:21:51 am
Re: Sales invoice with VAT Rate column for UK (8 replies, posted in Accounts Receivable)
Where is the Polish version hosted? Any screenshots?
4,424 02/15/2015 06:06:25 am
Re: Remove % from Sales Discount (3 replies, posted in FA Modifications)
Where? If it is the text in the report, look at the doctext.inc and/or correct it in the translations.
4,425 02/15/2015 06:05:03 am
Re: exchange rates not updating automatically (9 replies, posted in Banking and General Ledger)
Banking and General ledger => Currencies => Edit Currency => tick AutoUpdate => Update