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,402

(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....

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

(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

(65 replies, posted in Setup)

When done, don't forget to submit it here and to the project to assist others. wink

Use Stock Adjustment.

4,407

(16 replies, posted in Banking and General Ledger)

Hope this suffices:

https://frontaccounting.com/fawiki/inde … nkAccounts

Attempting to pay a foreign supplier (in non default currency of the company) too should trigger the exchange rate acquisition.

@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

(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.

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.

This needs to be fixed in FA 2.3 itself so that there is no carry forward errors into FA 2.4.....

Provide the changed code to test.

4,414

(16 replies, posted in Banking and General Ledger)

@bobloblian: Just check if the wiki is worded as desired:

https://frontaccounting.com/fawiki/inde … nkAccounts

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

(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!

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

(8 replies, posted in Manufactoring)

The demo is at:
http://demo.frontaccounting.eu/

4,419

(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

(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?

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.

Upgrade your install by overwriting with the changed files from this post.

Where is the Polish version hosted? Any screenshots?

4,424

(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.

Banking and General ledger => Currencies => Edit Currency => tick AutoUpdate => Update