When I generate a PO based on re-order or based on sold items, the storeid in that PO is 0, it should not be 0 because the storeid is 3.
why is it?
with my thanks!
- posted
17 years ago
the storeid is 0 when generate PO
Loading thread data ...
- Vote on answer
- posted
17 years ago
Dear All, you can configure the default value for StoreID column to your configured StoreID, ex: as you mentioned you storeid is 3 so the default value must be change to
3 , if your storeid is 4 change the default value to 4 ......etc, ALTER TABLE PurchaseOrder DROP CONSTRAINT DF_PurchaseOrder_StoreIDGO
ALTER TABLE dbo.PurchaseOrder
ADD CONSTRAINT DF_PurchaseOrder_StoreID DEFAULT 3 FOR StoreID
GO