Pets Corner occasionally require a one off PO created . This is for an existing store not a new store (see new store docs for this). The following should be run against the Head Office database, not the branch database.
-- Get transactor guid: SELECT * FROM transactor WHERE company_name like '%Vital%' and is_supplier = 1 Get the branch number: DECLARE @branch_no INT; SELECT [branch_no] FROM branch WHERE branch_name LIKE '%pulbor%'; -- Find po_creation_schedule: SELECT * FROM dbo.po_creation_schedule WHERE guid_supp = 'E64AE3B0-7FF2-4C0F-B6B3-DF986759860D' AND branch_no = 135 -- Update special flag for special orders UPDATE dbo.po_creation_schedule SET special_order = 1 WHERE row_id = 1051 -- setting special_order = 1 for one or more rows means that only these branches\suppliers are -- evaluated and other scheduled stuff is ignored. The special_order flag is automatically reset --after use. --Then run: EXEC traxs_PO_Suggested_PopulateFromGenerateRequirement @branch_no = 135 -- and then: EXEC [dbo].[traxs_PO_Suggested_Create_PO_WrapSpecial2] @guid_supp = 'E64AE3B0-7FF2-4C0F-B6B3-DF986759860D', @branch_no = 135 SELECt * FROM purchaseorder_hdr WHERE date_time > '2014-01-08 16:00' select subject from email_queue WHERE date_time > '2017-08-24 10:20' SELECt * FROM warehouse WHERE whse_no = 181 SELECt * FROM job_queue WHERE date_time > '2014-01-08 16:00'