User Tools

Site Tools


adding_a_one_one_requested_po_for_a_store

Adding a one one requested PO for a store

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'
adding_a_one_one_requested_po_for_a_store.txt · Last modified: 2018/04/09 06:03 by 212.42.166.188