Purchasing

How to set up supersessions

When a part needs to be superceded we need to make sure the part in question is set up properly. Just go to the item on the PO, actions -> edit and set the part you want it to be superseded by. We have already done this for you so you can see how it looks if you go into the itemSELECT bin_to_UUID(billing_id, 1) FROM rental.rental_contract_billing where invoice_id = ?;SELECT * FROM rental.rental_contract_billing_detail where billing_id = UUID_TO_BIN(?, 1);UPDATE `rental`.`rental_contract_billing_detail` SET `total_fee_cents` = ? WHERE (`master_id` = ?) and (`billing_id` = ?) and (`contract_line_id` = ?);Related Issue: https://flyntlok.com/rc/issues-hq?id=48653

PO is stuck in reversing

When a PO is stuck in reversing UPDATE `prod`.`item_voucher_master` SET `status` = '3', `qb_status` = '0' WHERE (`ID` = '445070') and (`Voucher_id` = '1');Related Issue: https://flyntlok.com/rc/issues-hq?id=49159

Separate Core on PO

When we want to separate a core item from the parent on a PO to receive them separately select * from item_purchases where order_master_id =?;UPDATE `prod`.`item_purchases` SET `master_purchase_id` = NULL WHERE (`ID` = ?);

Related Issue: https://flyntlok.com/rc/issues-hq?id=49160

Adding received machines to split mpo

This has been fixed going forward, but not going to fix older MPOs adding received machines to split mposelect * from machine_purchaseorder_detail where master_uuid = UUID_TO_BIN('MPO ID',1);SELECT * FROM prod.machine_purchaseorder_ordered_machine WHERE machine_id = machineID;update `prod`.`machine_purchaseorder_ordered_machine` set detail_uuid = uuid_to_bin('detail line uuid_text', 1) where machine_id = 'machineID';