Search options (Page 13 of 26)

Good news

Yes you are right, it works with direct invoices. We can create an option in the setup to let user decide whether it is good to delete all deliveries or just work for Direct invoices

I fear, this thread may die. I request other developers to test and give their feedback. @joe, @itronics please do consider this in core.

@anoopmb thanks, this is OK

@anoopmb. If possible kindly share any DropBox link of the Code. I was about to implement. Thanks

Perfect @notrinos. I got it working. Very Simple Just like Reports. Hats off to you.

Here is the Screen Shot.

@apmuthu as you said in Post#24, I think @notrinos is just showing his work to be included in the Core if found useful for all developers. Once decided, optimizing the code and structure to be used in separate folder or reporting folder can be done by our gurus @Joe and @itronics.

My vote is 100% for this modification to be included in the core.

Great .

@notrinos please do have a closer look.

Your First para in the above post means that 55 is more accurate cost of the Item A than 60. Where will you then place the wrong Reflections in GL Transactions and Inventory Account. as shown in this image

I am unable to understand that why there is a special handling for a condition $qoh==0 in both files grn_db.inc and work_order_costing_db.inc. This special handling is not necessary at all.

For this special condition we are taking a Non Weighted Average while if $qoh is either +ve or -ve we are taking Weighted Average.

For Calculating Average Material Cost using Non Weighted Average formula is a violation of Cost Accounting Practices irrespective of $qoh value.

I hope my explanation will help you to investigate it correctly.

@notrinos

yes I just checked the history of this file. I found that earlier it was

if ($qty > 0 && ($qoh != -$qty))
        $avg_cost = ($avg_cost*($qoh+$qty_delayed)+$unit_cost*$qty_new)/($qoh+$qty);

And I think this was perfect because this was taking the Weighted Average of the Item Produced

Later this was changed to

if ($qty > 0 && ($qoh != -$qty)) {
        if ($qoh == 0 && $avg_cost != 0)
            $avg_cost = ($avg_cost + ($unit_cost*$qty_new)/$qty)/2;
        else
            $avg_cost = ($avg_cost*($qoh+$qty_delayed)+$unit_cost*$qty_new)/($qoh+$qty);
    }

Here I am unable to understand that why we need to take Simple Average for condition

if ($qoh == 0 && $avg_cost != 0)

Assume following transactions
1. Item A was produced qty=300 with cost allocated after WO process = 50
2. Item A was sold qty = 300 @ 200 price
3. Item A was again produced qty = 400 and cost allocated after WO Process = 60

Now as per your revised condition the Average Material Cost calculation is taking the weightage of Cost 50 (Existing Avg Cost)

hence New $avg_cost will be calculated as 55

While the Old working will calculate the Weighted Average, that will Nullify the Weightage of 50 (Existing Avg Cost) and New $avg_cost will be calculated as 60, that is required.

Yes login, log out page in theme folder shall over write the core one. Good idea

@phpninja123 what is the time  for search now?