format("Y-m-d"); $prtTime =Explode(":", date('H:i:s')); $txDate = explode("-",$prfDate); $refYear = $txDate[0]; $refMonth = $txDate[1]; $refMinute = $prtTime[1]; $refSecond = $prtTime[2]; //$NewRefCode = $refYear.''.$refMonth.''.$refMinute.''.$refSecond.''.$uniqueRefID; ?>

📝  READY FOR PO CREATION

📑 Create New PO 📠 Print ⬇ Export
REC.# PRF # COMPANY VENDOR ITEM DESCRIPTION QTY AMOUNT VIEW
"; //echo ""; //echo ""; //echo ""; //####################################################################################################### //####################################################################################################### //$getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `awarded`= 1 AND `deleted`=0 AND `execom_approval_ts`!= '' AND `for_execom_canvass_approval`=1 AND `po_code`='' ORDER BY `execom_approval_ts` DESC LIMIT $offSet, $noOfRecordPerPage "); $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `awarded`= 1 AND `deleted`=0 AND `execom_approval_ts`!= '' AND `for_execom_canvass_approval`=1 AND `po_code`='' ORDER BY `execom_approval_ts` DESC"); while($row=mysql_fetch_array($getItemHdr)){ $regHDRcode=$row['header_ref_code']; $regCat=$row['category_id']; $vendorID = $row['award_to_vendor_id']; $vendorName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id`='$vendorID'"),0); $regCatName =mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='$regCat'"),0); $reqByID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$regHDRcode'"),0); $reqCompID=$row['comp_id']; $dateNeeded = mysql_result(mysql_query("SELECT `date_needed` FROM `prf_request_hdr` WHERE `reference_code`='$regHDRcode'"),0); $reqCompName = mysql_result(mysql_query("SELECT `comp_name` FROM vts_company WHERE comp_id='$reqCompID'"),0); $reqByFName = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$reqByID'"),0); $reqByLName = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$reqByID'"),0); $fileCode = mysql_result(mysql_query("SELECT `file_code` FROM `prf_uploadedcanvass` WHERE `ref_code`='".$row['approved_proposal_code']."'"),0); ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
".$row['header_ref_code']."".$reqCompName."".$vendorName."".$row['item_description']."".$row['approved_qty']."".$row['approved_amount']."📋
🪧 CONFIRM POST ACTION
✕
Are you sure you want to POST this Purchase Order?
🪧 NEW PURCHASE ORDER
✕
PO NUMBER
Select Company:
Select Vendor:
Terms:
Instructions:
📖 Active Items (Filtered base on selected company and vendor) Delivery Date:
REC.# PRF # COMPANY VENDOR ITEM DESCRIPTION QTY AMOUNT VIEW
🪧 Create Purchase Order
✕

The system will create an open PO once you add/insert an item. After adding an items, click POST PO to proceed with the PO approval.
ITEM DESCRIPTION:

adfas

🪧 Update Purchase Order
✕

Selected Item will be removed from the PO.

Selected Item:
adfas

📃 Selected Item/s:
REC.# PRF # COMPANY VENDOR ITEM DESCRIPTION QTY AMOUNT VIEW