FrontAccounting forum — Error: no supplier trans found for given params

Re: Error: no supplier trans found for given params

2020-11-28T15:11:38Z

Committed to stable 2.4.8 repo.

Fixed files can be fetched here and here.

/Joe

Re: Error: no supplier trans found for given params

2020-11-28T13:37:27Z

Thanks @notrinos.

I will fix this later today.

Joe

Re: Error: no supplier trans found for given params

2020-11-28T12:58:19Z

Acctually I already made my own solution for the problem by replace line 406 of allocation_cart.inc with this code:

elseif ($_SESSION['alloc']->person_type == PT_SUPPLIER && $_SESSION['alloc']->allocs[$counter]->type != ST_PURCHORDER)

But it will damage the solution of @itronics
A better solution in my opinion is to add a function called get_po() to po_db.inc like this

function get_po($order_no) {
    $sql = "SELECT * FROM ".TB_PREF."purch_orders WHERE order_no = ".db_escape($order_no);
    $result = db_query($sql);

    return db_fetch($result);
}

Then add a check for purchase orders in the allocation table by replace line 407 of allocation_cart.inc by this code:

if ($_SESSION['alloc']->allocs[$counter]->type == ST_PURCHORDER)
                $trans = get_po($_SESSION['alloc']->allocs[$counter]->type_no);
            else
                $trans = get_supp_trans($_SESSION['alloc']->allocs[$counter]->type_no, $_SESSION['alloc']->allocs[$counter]->type);

Re: Error: no supplier trans found for given params

2020-11-27T17:22:24Z

@notrinos, if you found solution for the bug. Update here. @joe will fix the bug.

Error: no supplier trans found for given params

2020-11-27T14:54:34Z

This commit has made the error on Payment to Supplier process
Function get_supp_trans() at line 407 of allocation_cart.inc will fire the error when allocation table has a purchase order