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!
the storeid is 0 when generate PO
Sep 13, 2006
1 Replies
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
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required