با توجه به اینکه قبض انبار با جداول زیادی در ارتباط است ، باید ابتدا دیتیل این جدول حذف شود
سپس جداول وابسته حذف شوند
و در نهایت هدر قبض ها حذف شود
خانومی
--حذف قبض ها و جداول وابسته delete from wm.DeliveryDetails delete from WM.InventoryFirstStockDetails delete from WM.InventoryFirstStock delete from Sale.OnLineSaleDetails delete from Sale.OnLineSale delete from WM.AdjustInventoryDetails delete from WM.AdjustInventory delete from WM.ASNDetails delete from WM.ASNPDATemp delete from WM.ASN delete from WM.StockDraftDetails delete from WM.StockDraftRecPDATemp delete from WM.StockDraft delete from wm.MojodiReview delete from wm.MojodiReviewIdentification delete from wm.MojodiReviewPDATemp delete from wm.MojodiReviewSetting delete from wm.MojodiReviewShelfs delete from wm.MojodiReviewInfo delete from wm.Delivery exec wm.PrepareStock --برای بازسازی موجودی