Search options (Page 18 of 27)

Oh yes, you are right

Yes, you are right. There is no Estimation System in FA right now.

Adding following 2 Code Components in gl/includes/db/gl_db_rates.inc Worked

at Line 163

elseif ($provider == 'CCA') //free.currencyconverterapi.com
    {
        $filename = "/api/v5/convert?q={$curr_b}_{$curr_a}&compact=y";
        $site = "free.currencyconverterapi.com";
        $proto = 'https://';

    }

and at Line 240

    elseif ($provider == 'CCA')
    {
        $rates = json_decode($contents, true);
        $val = $rates[$curr_b.'_'.$curr_a]['val'];
      }

and It works for all currencies without fail

Is there any solution for PKR as base currency?

Thanks @joe for considering me. However, I am not a good PHP Developer and don't know anything about Javascript. I am basically a financial consultant. I have been trying to Hack FA Code for some of my solutions for my clients. As you have talked about 'Landing Costs'. I think you meant Import Landing Cost. I have developed a simple module for this using Dimensions and Stock Adjustment. What it does is it Divides the Total Cost of Imports using Weighted Average Method to all products in Imports. Thus Adding Value to the Purchase Price of the Product.

Similarly I have developed a Manufacturing Module. The Current Manufacturing Module of FA have two Levels

1. Simple Manufacturing
2. Advance Manufacturing

In Advance Manufacturing, we can't handle a manufacturing process that generates 2 or more Finished Goods. We can input multiple Raw Materials but Finished Good is Single. Anyhow, I didn't like it.

My manufacturing module can be used for Simple as well as Advanced Processes. However it doesn't take into account the Labour and Overhead Costs separately. But it just calculates the per unit cost of each Finished Good Item using Weighted Average Method.

In Both Imports and Manufacturing Process, you need to open a Job in Dimensions of Type 2.

I have linked the Stock Adjustment also with Dimension. So all Raw Material can be Stocked Out in that Job day by day as process moves on.

Similarly all cash expenses can be loaded to that Job.

Once Job is Finished, you process it and all cost of that Job is allocated to each Item in Process.

If you are interested in this then give me email address to send the code to.

Regards.

Also we need to add following lines in copy_to_cart () function in sales_order_entry.php page

function copy_to_cart()
{
    check_reference($_POST['ref'], $_SESSION['Items']->trans_type, $_SESSION['Items']->trans_no); //added by faisal

@davidkumi, @itronics, @joe, @apmuthu

I have a suggestion and I have tested it with many transactions (not all) and it is working

Modify the function check_reference() with following single line change

function check_reference($reference, $trans_type, $trans_no=0, $context=null, $line=null)
{
    global $Refs;

    if (!$Refs->is_valid($reference, $trans_type, $context, $line))
    {
        display_error(_("The entered reference is invalid.")); return false;
    }
    elseif (!$Refs->is_new_reference($reference, $trans_type, $trans_no))
    {
        $_POST['ref'] = $Refs->get_next($trans_type, null, $context); //modified by faisal
        // display_error( _("The entered reference is already in use.")); return false;
    }
    return true;
}

Before applying to my main server I request you all to please authenticate it. I don't know if it conflicts with some other behaviour of FA

Yes please this is needed.

Hello @joe, could you check this bug

@joe, still one problem exists in rep101.php after applying your last commit

Check the same customer's balances with Parameter ShowBalance=>No

First Date Range 1st Jan 2017 till 31 Dec 2017

Note down Charges, Credits, Allocated and Balance Closing figures

Second Date Range 1st Jan 2018 till date

The above closing shall reflect in this opening but there is a difference Opening

Yes it is working. Thanks alot for your time and input.

@joe
You are absolutely right, but let me show you the situation with real client's data.

Login Here
id: admin
pass: Pakistan1947

Open customer balances report from 1st Jan 2017 till date
Select customer QY009-BABJEE TRADERS
Set Show Balance = Yes
Note down the Ending Balance = 811,922

Now set the date from 23 NOv 2017 till Date with same parameters.
Now the Ending balance will be = -2,609,707

This is because the Opening Balance is wrong i.e. -2,286,233
that is supposed to be 1,135,467

Because you can see 5 Bank Payment Entries that are made to this customer by client.

BP319, BP426, BP747, BP748, BP749.

My point is that since we can't stop customer to make a Bank Payment to a Customer because option is there in FA.

So we need to adjust our report that shall contain such silly accounting mistakes.

I hope my point is clear now.