Search options (Page 1 of 230)

08/29/2021 04:42:24 pm

The LTR version is attached where the Company Name follows the logo. What do you want to do?

08/29/2021 04:41:22 pm

@hannah: I tried many times to make logo little down in the invoice , I can't
Please can you show me which file and line i have to edit..?

08/29/2021 02:03:22 pm

@joe: run into this issue?

08/29/2021 01:58:27 pm

Quotations is a special form of Invoice and hence it should be done in the same manner. State your need very specifically and post your bounty in the Job Offers board.

08/22/2021 05:19:17 am

Should this need a company level flag in sys_prefs?

08/22/2021 05:12:18 am

Try and let us know what results you get.

08/19/2021 04:09:45 am

Checkout Secuimage CAPTCHA with FA at:
https://frontaccounting.com/punbb/viewtopic.php?id=3341

08/19/2021 03:36:23 am

In gl/includes/db/gl_db_banking.inc there is a function write_bank_transaction() that may a clue to what changed since 27th Oct 2010 when the said function name was changed in FA v2.3 RC3.

The original function was:

//----------------------------------------------------------------------------------
//    Add bank payment or deposit to database.
//
//    $from_account - bank account id
//  $item - transaction cart (line item's amounts in bank account's currency)
//  $person_type_id - defines type of $person_id identifiers
//  $person_id    - supplier/customer/other id
// $person_detail_id - customer branch id or not used
//
// returns an array of (inserted trans type, trans no)

function add_bank_transaction($trans_type, $from_account, $items, $date_,
    $person_type_id, $person_id, $person_detail_id,    $ref, $memo_, $use_transaction=true)
{
    global $Refs, $SysPrefs;

    // we can only handle type 1 (payment)and type 2 (deposit)
    if ($trans_type != ST_BANKPAYMENT && $trans_type != ST_BANKDEPOSIT)
        display_db_error("Invalid type ($trans_type) sent to add_bank_transaction");

    $do_exchange_variance = false;
    $exchanged = false;
    if ($use_transaction)
        begin_transaction();

    $currency = get_bank_account_currency($from_account);
    $bank_gl_account = get_bank_gl_account($from_account);

    // the gl items are already inversed/negated for type 2 (deposit)
    $total_amount = $items->gl_items_total();

    if ($person_type_id == PT_CUSTOMER)
    {
        // we need to add a customer transaction record

        // convert to customer currency
        $cust_amount = exchange_from_to($total_amount, $currency, get_customer_currency($person_id), $date_);
        // we need to negate it too
        $cust_amount = -$cust_amount;

        $trans_no = write_customer_trans($trans_type, 0, $person_id, $person_detail_id, $date_,
            $ref, $cust_amount);

    }
    elseif ($person_type_id == PT_SUPPLIER)
    {
        // we need to add a supplier transaction record
        // convert to supp currency
        $supp_amount = exchange_from_to($total_amount, $currency, get_supplier_currency($person_id), $date_);

        // we need to negate it too
        $supp_amount = -$supp_amount;

        $trans_no = add_supp_trans($trans_type, $person_id, $date_, '',
            $ref, "", $supp_amount, 0, 0);

    }
    else
    {
        $trans_no = get_next_trans_no($trans_type);
        $do_exchange_variance = $SysPrefs->auto_currency_revaluation();
        if ($do_exchange_variance)
            $trans_no1 = get_next_trans_no(ST_JOURNAL);
    }

    // do the source account postings

    add_bank_trans($trans_type, $trans_no, $from_account, $ref,
        $date_, -$total_amount,
        $person_type_id, $person_id,
        $currency,
        "Cannot insert a source bank transaction");
    $total = 0;
    foreach ($items->gl_items as $gl_item)
    {
        $is_bank_to = is_bank_account($gl_item->code_id);

        if ($trans_type == ST_BANKPAYMENT AND $is_bank_to)
        {
            // we don't allow payments to go to a bank account. use transfer for this !
            display_db_error("invalid payment entered. Cannot pay to another bank account", "");
        }

        // do the destination account postings
        $total += add_gl_trans($trans_type, $trans_no, $date_, $gl_item->code_id,
            $gl_item->dimension_id, $gl_item->dimension2_id, $gl_item->reference,
            $gl_item->amount, $currency, $person_type_id, $person_id);

        if ($is_bank_to)
        {
            add_bank_trans($trans_type, $trans_no, $is_bank_to, $ref,
                $date_, $gl_item->amount,
                $person_type_id, $person_id, $currency,
                "Cannot insert a destination bank transaction");
            if ($do_exchange_variance)
            {
                add_exchange_variation($trans_no1, $date_, $is_bank_to, $gl_item->code_id, 
                    $currency, $person_type_id, $person_id);
            }        
        }
        // store tax details if the gl account is a tax account

        $amount = $gl_item->amount;
        $ex_rate = get_exchange_rate_from_home_currency($currency, $date_);
            
        add_gl_tax_details($gl_item->code_id, $trans_type, $trans_no, -$amount,
            $ex_rate, $date_, $memo_);
    }

    // do the source account postings
    add_gl_trans($trans_type, $trans_no, $date_, $bank_gl_account, 0, 0, $memo_,
        -$total, null, $person_type_id, $person_id);

    if ($do_exchange_variance)
    {
        if ($exchanged || add_exchange_variation($trans_no1, $date_, $from_account, $bank_gl_account, 
            $currency, $person_type_id, $person_id))
        {    
               $ref1 = $Refs->get_next(ST_JOURNAL);
            $Refs->save(ST_JOURNAL, $trans_no1, $ref1);
            add_audit_trail(ST_JOURNAL, $trans_no1, $date_);
        }    
    }

    add_comments($trans_type, $trans_no, $date_, $memo_);

    $Refs->save($trans_type, $trans_no, $ref);
    add_audit_trail($trans_type, $trans_no, $date_);

    if ($use_transaction)
        commit_transaction();

    return array($trans_type, $trans_no);
}

and that got changed then to

//----------------------------------------------------------------------------------
//    Add bank payment or deposit to database.
//
//    $from_account - bank account id
//  $item - transaction cart (line item's amounts in bank account's currency)
//  $person_type_id - defines type of $person_id identifiers
//  $person_id    - supplier/customer/other id
// $person_detail_id - customer branch id or not used
//
// returns an array of (inserted trans type, trans no)
//
// FIXME -revise code for update case
//
function write_bank_transaction($trans_type, $trans_no, $from_account, $items, $date_,
    $person_type_id, $person_id, $person_detail_id,    $ref, $memo_, $use_transaction=true)
{
    global $Refs, $SysPrefs;

    // we can only handle type 1 (payment)and type 2 (deposit)
    if ($trans_type != ST_BANKPAYMENT && $trans_type != ST_BANKDEPOSIT)
        display_db_error("Invalid type ($trans_type) sent to add_bank_transaction");

    $do_exchange_variance = false;
    $exchanged = false;
    if ($use_transaction)
        begin_transaction();

    if ($trans_no)
        clear_bank_transaction($_SESSION['pay_items']->trans_type, $_SESSION['pay_items']->order_id);

    $currency = get_bank_account_currency($from_account);
    $bank_gl_account = get_bank_gl_account($from_account);

    // the gl items are already inversed/negated for type 2 (deposit)
    $total_amount = $items->gl_items_total();

    if ($person_type_id == PT_CUSTOMER)
    {
        // we need to add a customer transaction record

        // convert to customer currency
        $cust_amount = exchange_from_to($total_amount, $currency, get_customer_currency($person_id), $date_);
        // we need to negate it too
        $cust_amount = -$cust_amount;

        $trans_no = write_customer_trans($trans_type, $trans_no, $person_id, $person_detail_id, $date_,
            $ref, $cust_amount);

    }
    elseif ($person_type_id == PT_SUPPLIER)
    {
        // we need to add a supplier transaction record
        // convert to supp currency
        $supp_amount = exchange_from_to($total_amount, $currency, get_supplier_currency($person_id), $date_);

        // we need to negate it too
        $supp_amount = -$supp_amount;

        $trans_no = write_supp_trans($trans_type, $trans_no, $person_id, $date_, '',
            $ref, "", $supp_amount, 0, 0);

    }
    else
    {
        if (!$trans_no)
            $trans_no = get_next_trans_no($trans_type);
        $do_exchange_variance = $SysPrefs->auto_currency_revaluation();
        if ($do_exchange_variance)
            $trans_no1 = get_next_trans_no(ST_JOURNAL);
    }

    // do the source account postings

    add_bank_trans($trans_type, $trans_no, $from_account, $ref,
        $date_, -$total_amount,
        $person_type_id, $person_id,
        $currency,
        "Cannot insert a source bank transaction");
    $total = 0;
    foreach ($items->gl_items as $gl_item)
    {
        $is_bank_to = is_bank_account($gl_item->code_id);

        if ($trans_type == ST_BANKPAYMENT AND $is_bank_to)
        {
            // we don't allow payments to go to a bank account. use transfer for this !
            display_db_error("invalid payment entered. Cannot pay to another bank account", "");
        }

        // do the destination account postings
        $total += add_gl_trans($trans_type, $trans_no, $date_, $gl_item->code_id,
            $gl_item->dimension_id, $gl_item->dimension2_id, $gl_item->reference,
            $gl_item->amount, $currency, $person_type_id, $person_id);

        if ($is_bank_to)
        {
            add_bank_trans($trans_type, $trans_no, $is_bank_to, $ref,
                $date_, $gl_item->amount,
                $person_type_id, $person_id, $currency,
                "Cannot insert a destination bank transaction");
            if ($do_exchange_variance)
            {
                add_exchange_variation($trans_no1, $date_, $is_bank_to, $gl_item->code_id, 
                    $currency, $person_type_id, $person_id);
            }        
        }
        // store tax details if the gl account is a tax account

        $amount = $gl_item->amount;
        $ex_rate = get_exchange_rate_from_home_currency($currency, $date_);
            
        add_gl_tax_details($gl_item->code_id, $trans_type, $trans_no, -$amount,
            $ex_rate, $date_, $memo_);
    }

    // do the source account postings
    add_gl_trans($trans_type, $trans_no, $date_, $bank_gl_account, 0, 0, $memo_,
        -$total, null, $person_type_id, $person_id);

    if ($do_exchange_variance)
    {
        if ($exchanged || add_exchange_variation($trans_no1, $date_, $from_account, $bank_gl_account, 
            $currency, $person_type_id, $person_id))
        {    
               $ref1 = $Refs->get_next(ST_JOURNAL);
            $Refs->save(ST_JOURNAL, $trans_no1, $ref1);
            add_audit_trail(ST_JOURNAL, $trans_no1, $date_);
        }    
    }

    add_comments($trans_type, $trans_no, $date_, $memo_);

    $Refs->save($trans_type, $trans_no, $ref);
    add_audit_trail($trans_type, $trans_no, $date_);

    if ($use_transaction)
        commit_transaction();

    return array($trans_type, $trans_no);
}

and now in v2.4.10+ stands at:

//----------------------------------------------------------------------------------
//    Add bank payment or deposit to database.
//
//    $from_account - bank account id
//  $items - transaction cart (line amounts in bank account's currency); negative for deposit
//  $person_type_id - defines type of $person_id identifiers
//  $person_id    - supplier/customer/other id
//  $person_detail_id - customer branch id or not used
//  $settled_amount - settled amount in AR/AP (if applicable) in customer/supplier currency (always non-negative number)
//
// returns an array of (inserted trans type, trans no)
//
// FIXME -revise code for update case
//
function write_bank_transaction($trans_type, $trans_no, $from_account, $items, $date_,
    $person_type_id, $person_id, $person_detail_id,    $ref, $memo_, $use_transaction=true, $settled_amount=null)
{
    global $Refs, $SysPrefs;

    // we can only handle type 1 (payment)and type 2 (deposit)
    if ($trans_type != ST_BANKPAYMENT && $trans_type != ST_BANKDEPOSIT)
        display_db_error("Invalid type ($trans_type) sent to add_bank_transaction");

    $do_exchange_variance = false;
    if ($use_transaction)
        begin_transaction();

    $args = func_get_args(); if (count($args) < 11) $args[] = true;
    $args = (object)array_combine(array('trans_type', 'trans_no', 'from_account', 'items', 'date_',
        'person_type_id', 'person_id', 'person_detail_id', 'ref', 'memo_', 'use_transaction', 'settled_amount'),
        $args);
    hook_db_prewrite($args, $trans_type);

    $aid = 0;
    if ($trans_no) {
        $old_trans = $trans_no;
        $Refs->restore_last($trans_type, $trans_no);
        $aid = has_attachment($trans_type, $trans_no);
    } else
        $old_trans = false;

    $currency = get_bank_account_currency($from_account);
    $bank_gl_account = get_bank_gl_account($from_account);

    // the gl items are already inversed/negated for type 2 (deposit)
    $total_amount = $items->gl_items_total();

    if ($person_type_id == PT_CUSTOMER)
    {
        // we need to add a customer transaction record
        // convert to customer currency
        if (!isset($settled_amount)) // leaved for backward/ext compatibility 
            $cust_amount = exchange_from_to(abs($total_amount), $currency, get_customer_currency($person_id), $date_);
        else
            $cust_amount = $settled_amount;

        if ($trans_type == ST_BANKPAYMENT)
            $cust_amount = -$cust_amount;

        $trans_no = write_customer_trans($trans_type, 0, $person_id, $person_detail_id, $date_,
            $ref, $cust_amount);
        if ($old_trans)
            move_trans_attachments($trans_type, $old_trans, $trans_no);
    }
    elseif ($person_type_id == PT_SUPPLIER)
    {
        // we need to add a supplier transaction record
        // convert to supp currency
        if (!isset($settled_amount)) // leaved for for backward/ext compatibility 
            $supp_amount = exchange_from_to(abs($total_amount), $currency, get_supplier_currency($person_id), $date_);
        else
            $supp_amount = $settled_amount;

        if ($trans_type == ST_BANKPAYMENT)
            $supp_amount = -$supp_amount;

        $trans_no = write_supp_trans($trans_type, 0, $person_id, $date_, '',
            $ref, "", $supp_amount, 0, 0);
        if ($old_trans)
            move_trans_attachments($trans_type, $old_trans, $trans_no);
    }
    else
    {
           $trans_no = get_next_trans_no($trans_type);
        $do_exchange_variance = $SysPrefs->auto_currency_revaluation();
        if ($do_exchange_variance)
            $trans_no1 = get_next_trans_no(ST_JOURNAL);
    }
    if ($aid != 0)
    {
        $row = get_attachment($aid);
        update_attachment($aid, $row['type_no'], $trans_no, $row['description'],
            $row['filename'], $row['unique_name'], $row['filesize'], $row['filetype']);
    }
    // do the source account postings

    add_bank_trans($trans_type, $trans_no, $from_account, $ref,
        $date_, -$total_amount,
        $person_type_id, $person_id,
        $currency,
        "Cannot insert a source bank transaction");
    $total = 0;
    foreach ($items->gl_items as $gl_item)
    {
        $is_bank_to = is_bank_account($gl_item->code_id);

        if ($trans_type == ST_BANKPAYMENT AND $is_bank_to)
        {
            // we don't allow payments to go to a bank account. use transfer for this !
            display_db_error("invalid payment entered. Cannot pay to another bank account", "");
        }

        // do the destination account postings
        $total += add_gl_trans($trans_type, $trans_no, $date_, $gl_item->code_id,
            $gl_item->dimension_id, $gl_item->dimension2_id, $gl_item->reference,
            $gl_item->amount, $currency, $person_type_id, $person_id);

        if ($is_bank_to)
        {
            add_bank_trans($trans_type, $trans_no, $is_bank_to, $ref,
                $date_, $gl_item->amount,
                $person_type_id, $person_id, $currency,
                "Cannot insert a destination bank transaction");
            if ($do_exchange_variance)
            {
                add_exchange_variation($trans_no1, $date_, $is_bank_to, $gl_item->code_id, 
                    $currency, $person_type_id, $person_id);
            }
        }
        // store tax details if the gl account is a tax account

        $amount = $gl_item->amount;
        $ex_rate = get_exchange_rate_from_home_currency($currency, $date_);

        add_gl_tax_details($gl_item->code_id, $trans_type, $trans_no, -$amount,
            $ex_rate, $date_, $memo_);
    }

    // do the source account postings
    add_gl_trans($trans_type, $trans_no, $date_, $bank_gl_account, $gl_item->dimension_id, $gl_item->dimension2_id, $memo_,
        -$total, null, $person_type_id, $person_id);

    if ($do_exchange_variance)
    {
        add_exchange_variation($trans_no1, $date_, $from_account, $bank_gl_account, 
            $currency, $person_type_id, $person_id);
    }

    add_comments($trans_type, $trans_no, $date_, $memo_);

    $Refs->save($trans_type, $trans_no, $ref);
    add_audit_trail($trans_type, $trans_no, $date_);

    // old transaction can be voided only after new transaction is entered,
    //  otherwise the operation could fail for cash accounts due to temporary negative balance
    if ($old_trans) 
    {
        $msg = void_transaction($trans_type, $old_trans, $date_, _("Document reentered."));
        if ($msg)
        {
            display_error($msg);
            return false;
        }
    }


    $args->trans_no = $trans_no;
    hook_db_postwrite($args, $trans_type);
    if ($use_transaction)
        commit_transaction();

    return array($trans_type, $trans_no);
}

Hence hash an appropriate add_bank_transaction() function from the above in the said file that spews the stated error and you should be good to go.

Dimensions are now set, the second argument is now a trans_no and a settled_amount is the last optional argument.

08/19/2021 03:27:00 am

@joe: Is this a real issue?

Looks like some cache settings in the browser need to be cleared.

08/15/2021 09:20:44 am

Link not accessible

08/15/2021 09:17:59 am

I hope you are using the module from my repo at:
https://github.com/apmuthu/FA24extensions/tree/master/Extensions/import_multijournalentries

The function add_bank_transaction() was a native function in FA but not available in both v2.3.26 and in any v2.4.x versions now.

08/15/2021 09:00:35 am

Line 153 in config.default.inc:

    $UTF8_fontfile    = $_SESSION['language']->dir == 'ltr' ? "FreeSans.ttf" : "zarnormal.ttf"; // for Arabic Dashboard

should be replaced with:

    $UTF8_fontfile    = @$_SESSION['language']->dir == 'ltr' ? "FreeSans.ttf" : "zarnormal.ttf"; // for Arabic Dashboard

for now till a better solution presents itself.

08/14/2021 02:04:39 am

The recent change to config.default.inc fails when starting up FA where $_SESSION['language'] is not yet defined then in line 153. That line config.default.inc:

    $UTF8_fontfile    = $_SESSION['language']->dir == 'ltr' ? "FreeSans.ttf" : "zarnormal.ttf"; // for Arabic Dashboard

should be replaced in the config.php with:

    $UTF8_fontfile    = "FreeSans.ttf";
    //$UTF8_fontfile    = "zarnormal.ttf"; // for Arabic Dashboard

or suppress the error with "@" prefix to the original line or make sure it "isset" before testing it with some default.

08/14/2021 01:48:36 am

@joe: can this get into the core?

08/14/2021 01:44:25 am

Changing the language files to replace all instances of customers with donors and then re-compiling them would be easiest. Otherwise, confusion would ensue where it is referred to as donors only in places where such changes have been made. Restricting such changes to just those files in the new module may be one such option provided that outputs of standard core functions in FA used in the new module are not touched and acceptable as is.

08/14/2021 01:42:14 am

Which version of FA and platform versions are you on? Linux/Windows/Mac, PHP, MySQL versions.

08/14/2021 01:39:38 am

Hedge / book the currencies in your home currency and prepare the purchase order accordingly with the quoted currencies in the memo field and book the costs in the local currency.

Alternatively, break up the purchase order into separate currency ones and live within standard FA.

08/11/2021 04:09:20 pm

Lines 38 and 40 in js/utils.js need this change.

08/11/2021 04:01:25 pm

@joe: can include this?

08/05/2021 07:33:11 am

Properly indented and assimilated changes into:
https://github.com/apmuthu/FA24extensions/tree/master/Extensions/rep_cash_flow_statement

Wonder why translation for "Accounts" was removed in @kvvaradha's version.

08/05/2021 06:20:42 am

The really updated and synched en_US-demo2.sql to existing en_US-demo.sql is available at

https://github.com/apmuthu/FA24extensions/blob/master/Charts/chart_en_US-demo2/en_US-demo2.sql

This has the field orders synched too.

08/05/2021 06:00:59 am

One Journal entry should suffice.

08/05/2021 05:57:00 am

@joe: has this been done?

08/05/2021 05:56:34 am

@joe: is this necessary?

08/05/2021 05:54:29 am

https://www.cs-cart.com/
https://github.com/cscart/

Uses PHP/MySQL - so FA integration is possible

Search options (Page 1 of 230)

Posts found: 1 to 25 of 5,736

1 Reply by apmuthu 08/29/2021 04:42:24 pm

Re: Logo on invoices in RTL (2 replies, posted in FA Modifications)

2 Topic by apmuthu 08/29/2021 04:41:22 pm

Topic: Logo on invoices in RTL (2 replies, posted in FA Modifications)

3 Reply by apmuthu 08/29/2021 02:03:22 pm

Re: BUG in Inventory Valuation Report (1 replies, posted in Reporting)

4 Reply by apmuthu 08/29/2021 01:58:27 pm

Re: REQUIRE SOME MODIFICATION IF POSSIBLE (3 replies, posted in FA Modifications)

5 Reply by apmuthu 08/22/2021 05:19:17 am

Re: Remnant Data Show up in New Sales Direct Sales Invoice (13 replies, posted in Report Bugs here)

6 Reply by apmuthu 08/22/2021 05:12:18 am

Re: Import Multiple Journal Entries - nothing imported (7 replies, posted in Modules/Add-on's)

7 Reply by apmuthu 08/19/2021 04:09:45 am

Re: Securing the login form with the CAPTCHA system. (2 replies, posted in FA Modifications)

8 Reply by apmuthu 08/19/2021 03:36:23 am

Re: Import Multiple Journal Entries - nothing imported (7 replies, posted in Modules/Add-on's)

9 Reply by apmuthu 08/19/2021 03:27:00 am

Re: Remnant Data Show up in New Sales Direct Sales Invoice (13 replies, posted in Report Bugs here)

10 Reply by apmuthu 08/15/2021 09:20:44 am

Re: Remnant Data Show up in New Sales Direct Sales Invoice (13 replies, posted in Report Bugs here)

11 Reply by apmuthu 08/15/2021 09:17:59 am

Re: Import Multiple Journal Entries - nothing imported (7 replies, posted in Modules/Add-on's)

12 Reply by apmuthu 08/15/2021 09:00:35 am

Re: config.default.inc error on startup (3 replies, posted in Report Bugs here)

13 Topic by apmuthu 08/14/2021 02:04:39 am

Topic: config.default.inc error on startup (3 replies, posted in Report Bugs here)

14 Reply by apmuthu 08/14/2021 01:48:36 am

Re: Unable to void a Sales Invoice (10 replies, posted in Report Bugs here)

15 Reply by apmuthu 08/14/2021 01:44:25 am

Re: Custom Labels (2 replies, posted in Modules/Add-on's)

16 Reply by apmuthu 08/14/2021 01:42:14 am

Re: Shipment Tracking Module (8 replies, posted in Modules/Add-on's)

17 Reply by apmuthu 08/14/2021 01:39:38 am

Re: Multi-currency purchase order (2 replies, posted in Accounts Payable)

18 Reply by apmuthu 08/11/2021 04:09:20 pm

Re: ERROR Report GL Trans (show warning sign) (18 replies, posted in Reporting)

19 Reply by apmuthu 08/11/2021 04:01:25 pm

Re: Nginx server and PHP version (8 replies, posted in Report Bugs here)

20 Reply by apmuthu 08/05/2021 07:33:11 am

Re: Cash Flow Statement Bank Filter (4 replies, posted in Banking and General Ledger)

21 Reply by apmuthu 08/05/2021 06:20:42 am

Re: New company login password incorrect (13 replies, posted in Setup)

22 Reply by apmuthu 08/05/2021 06:00:59 am

Re: Can we group the Similar accounts during the time of writing GL Trans (2 replies, posted in Banking and General Ledger)

23 Reply by apmuthu 08/05/2021 05:57:00 am

Re: Credit This Option for Supplier Invoice Doesn't Show Quantity Invoiced (3 replies, posted in Report Bugs here)

24 Reply by apmuthu 08/05/2021 05:56:34 am

Re: NEW LINE BUG IN INVENTORY LOCATION TRANSFER (2 replies, posted in Items and Inventory)

25 Reply by apmuthu 08/05/2021 05:54:29 am

Re: cs-cart Integration with FA? or web shop Required (1 replies, posted in Modules/Add-on's)

Posts found: 1 to 25 of 5,736