Search options (Page 10 of 26)

Actually Customers / Suppliers are basically Subsidiary accounts of Accounts Receivable / Accounts Payable . While Banks and Cash or any other accounts are main gl Accounts. So this particular column is for Sub Accounts

Given a test today with basic reports and find Margins issue as mentioned here
http://prnt.sc/okysmi

Thanks @poncho1234 you have suggested a non javascript solution.

But still my question is that how to get the Jquery Function workable after Ajax Call. My problem is discussed here. I have tried them but could not find workable in FA.

I have successfully implemented this jquery solution for column and header freeze.

But I am stuck that once a page is reloaded due to Ajax Call then the following Jquery Function at the bottom of the page is not called.

<script>
$(document).ready(function() {

  $(".table-scrollable").freezeTable({
    'scrollable': true,
        'columnNum' : 5,

  });

});
</script>

If you agree with my post#5 then

This condition

$types = array(ST_SUPPCREDIT, ST_SUPPRECEIVE);
            if (in_array($type, $types))
                $unit_cost = $row["price"];
            else
                $unit_cost = $row["standard_cost"];

in function void_stock_move in includes/db/inventory_db.inc will be changed to

$unit_cost = $row["price"];

Because now this will work for all transaction types to fetch the unit_cost affecting avg_cost.

on includes/db/inventory_db.inc at line # 475 we shall add this condition

if ($type!=ST_LOCTRANSFER) 

before the following function call

update_average_material_cost($row["supplier_id"], $row["stock_id"],
                    $unit_cost, -$row["qty"], sql2date($row["tran_date"]), false, "Void Stock Move # $type_no and type = $type_no");

Rationale

There is no reason for updating average cost while Voiding Stock Move due to Location Transfer. The inventory is neither gaining not loosing here.

If we don't do this then Avg Unit Cost is adversely affected. Because the stock_moves table doesn't contain any price for Location Transfer hence $unit_cost parameter passed to update_average_material_cost is ZERO so the resulting weighted average is not correct at the end of transaction.

`standard_cost` changed to `avg_cost` - store for item average cost (stock_master.material_cost)  before transaction

I think is the store of average cost after transaction. the resulting average cost of the item due the unit_cost being used in the transaction.

I think I didn't sleep well last night. All is working now

Yes waiting for all good news

@joe, not for this topic now. But I have few suggestions for 2.5. This post https://frontaccounting.com/punbb/viewtopic.php?id=8137 doesn't allow us to post. Where can we post for suggestions for 2.5.

@joe,

You can do either, or but I think better keep the one in post # 11. I have tested it. It has changed conditions as well as some removal of logical bugs and

Post #8 should be committed otherwise domestic_price will not calculate correctly.

With my finally suggested codes in post#8 and post#11 domestic_price is calculating correctly the average cost.

Regards.