Search options (Page 1 of 5)

Any update on this ?

Hi Joe,

similar to following code in view_receipt.php
display_allocations_from(PT_CUSTOMER, $receipt['debtor_no'], ST_CUSTPAYMENT, $trans_id, $receipt['Total']);

we can add
display_allocations_to(PT_CUSTOMER, $receipt['debtor_no'], ST_SALESINVOICE, $trans_id, $receipt['Total']);

custalloc_db.inc has function get_allocatable_to_cust_transactions similarly we can write function get_allocatable_FROM_cust_transactions
as below -

function get_allocatable_from_cust_transactions($customer_id, $trans_no=null, $type=null)
{
    if ($trans_no != null and $type != null)
    {
        $sql = get_alloc_trans_sql("amt", "trans.trans_no = alloc.trans_no_from
            AND trans.type = alloc.trans_type_from
            AND alloc.trans_no_to=".db_escape($trans_no)."
            AND alloc.trans_type_to=".db_escape($type)."
            AND trans.debtor_no=".db_escape($customer_id),
            "".TB_PREF."cust_allocations as alloc");
    }
    else
    {
        $sql = get_alloc_trans_sql(null, "round(ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount-alloc,6) > 0
            AND trans.type <> " . ST_CUSTPAYMENT . "
            AND trans.type <> " . ST_BANKDEPOSIT . "
            AND trans.type <> " . ST_CUSTCREDIT . "
            AND trans.type <> " . ST_CUSTDELIVERY . "
            AND trans.debtor_no=".db_escape($customer_id));
    }

    return db_query($sql." ORDER BY trans_no", "Cannot retreive alloc to transactions");
}

Hope I am clear enough.

Thanks

Hi chvypwrd,

I am unable to reproduce the issue of negative cost .
Could you please provide a case if possible ?

Thanks

Sorry wrong place.

Is there any progress on this topic.
This is a required feature

Hi Joe,

In that case, I am not clear about what is actual usage/advantage of applying service items on BOM?

Thanks,

Can we add service items on BOM ?

Thanks

Hi Gatson, if I am getting u correct -

You may manually apply the tax using tax gl item.
Here tax will not be auto calculated.