请问如何把业务初始化录入的期初库存全部清空

已有 1 条回答

Joshua_Jiang

1.删除仓库数据，
若启用了业务系统，删除delete from icbal
若没有启用业务系统，删除delete from ICInvInitial（删除存货初始数据）

2.删除BOM表
delete from ICbomChild
delete from Icbom
delete from ICBomgroup

3.删除物料；
  要删除物料，先删除附属信息表。
select * from t_icitembase where fitemid in (select Fitemid from t_item   where fitemclassid=4)
delete from t_icitembase where fitemid in (select Fitemid from t_item   where fitemclassid=4)
delete from t_icitemcore where fitemid in (select Fitemid from t_item   where fitemclassid=4)
delete from t_icitemcustom where fitemid in (select Fitemid from t_item   where fitemclassid=4)
delete from t_icitemdesign where fitemid in (select Fitemid from t_item   where fitemclassid=4)
delete from t_icitemmaterial where fitemid in (select Fitemid from t_item   where fitemclassid=4)
delete from t_icitemplan where fitemid in (select Fitemid from t_item   where fitemclassid=4)
delete from t_icitemquality where fitemid in (select Fitemid from t_item   where fitemclassid=4)
delete from t_icitemstandard where fitemid in (select Fitemid from t_item   where fitemclassid=4)
--其中Fitemclassid为4，是表示4代表物料类。接下来删除物料；
delete from t_item   where fitemclassid=4 or fitemclassid=2001

相关问答

请问安卓POS如何解决产生负库存的问题？

已有 1 个回答　|　1年前

怎样设置才能给子用户开启“查库存”功能？

已有 1 个回答　|　1年前

拆卸单拆出来的商品成本录多了，导致后面卖拆出来的商品时成本大于售价，出现负库存，怎么可以把成本硬调成正确的

已有 1 个回答　|　1年前

V5怎么查看电商商品库存配货占用量？

已有 1 个回答　|　1年前

库存汇总表中没有辅助数量

已有 1 个回答　|　1年前

最新文章查看更多