Hi,

I think Approval System for GL Transactions should work fine here. Refer Forum Post.

So system administrator/Accountant  can review and approve it.

Hi anoobpmb, I just read this thread and I agree. It is possible and often necessary to credit an account with a normal debit balance and vice versa. Your solution is the most ideal, as is the script suggested by kvvaradha and the comments of joe and detkenn.

I look forward to receiving the files for Version 2.4.8 of your Approval System for GL Transactions.

Celito

I think Approval System for GL Transactions should work fine here. Refer Forum Post.

So system administrator/Accountant  can review and approve it.

I believe the petty cash is not a bank account right? It's money kept at hand by the petty cashier I believe for quick transactions that do not require writing of a check and making small payments like perdiems, transportation, fuel etc..

Regards

Joe

With that in mind, I am bringing this illustration;

Not all payments are done through bank transactions right? Assuming I need to make a payment of $2, am I going to write a check for that amount?
The petty cashier is often given a certain amount of money at hand to pay for small transactions, now when He you process a payment, the petty cash must be credited and the other account debited.

Is there a possibility to allow a cash account (WHICH IS NOT BANK ACCOUNT) (if not all asset accounts) to appear in the list when processing a payment? @joe

Regards to all

Cedrick

Joe

Hope this feature would be helpful for others.

A thousand times thanks brother @kvvaradha . The code worked perfectly.
This was exactly what I needed. I will modify it little bit with your permission for other accounts too.

Big thanks again!!!

That's good to hear it.

If you modify the code, I feel it's very much usefull to FA  community. So provide it for us to update FA  core.

@Joe,  can you check this to update it to core. May be its useful feature for others.

Big thanks again!!!

Here is a screenshot for reference what i talked. And code i modified in gl_journal.php

// New function to check it 
function check_account_selection($code, $amount){
    $sql = "SELECT ms.*, cl.class_name, cl.ctype FROM ".TB_PREF."chart_master AS ms LEFT JOIN ".TB_PREF."chart_types AS tp ON ms.account_type= tp.id LEFT JOIN ".TB_PREF."chart_class AS cl ON cl.cid = tp.class_id WHERE account_code= ".db_escape($code);
    $res = db_query($sql, "Cant get the chart class selection");
    if(db_num_rows($res) == 1 ){
        if($row = db_fetch($res)){
            if($row['ctype'] == CL_EXPENSE && $amount > 0)
                display_warning(_("You are entered the Expense under the debit side"));
            if($row['ctype'] == CL_ASSETS  && $amount < 0 )
                display_warning(_("You are entered the Asset in credit side"));
        }
    }

}
function handle_new_item()
{
    if (!check_item_data())
        return;


    if (input_num('AmountDebit') > 0)
        $amount = input_num('AmountDebit');
    else
        $amount = -input_num('AmountCredit');
    
    check_account_selection(get_post('code_id'), $amount);  // This is new line in existing code
    

    $_SESSION['journal_items']->add_gl_item($_POST['code_id'], $_POST['dimension_id'],
        $_POST['dimension2_id'], $amount, $_POST['LineMemo'], '', get_post('person_id'));
      unset($_SESSION['journal_items']->tax_info);
    line_start_focus();
}

abd for updating of exiting entry.

 
function handle_update_item()
{
    if($_POST['UpdateItem'] != "" && check_item_data())
    {
        if (input_num('AmountDebit') > 0)
            $amount = input_num('AmountDebit');
        else
            $amount = -input_num('AmountCredit');


        check_account_selection(get_post('code_id'), $amount); // This is new line in existing code


        $_SESSION['journal_items']->update_gl_item($_POST['Index'], $_POST['code_id'], 
            $_POST['dimension_id'], $_POST['dimension2_id'], $amount, $_POST['LineMemo'], '', get_post('person_id'));
        unset($_SESSION['journal_items']->tax_info);
        line_start_focus();
    }
}