|
U9知识库
问题名称: |
安全库存预警 |
问题号: |
ZS20130905001 |
软件版本: |
2.0上市版 |
适用产品: |
|
软件模块: |
|
问题现象: |
当库存的在手量低于安全库存时,系统进行预警。分2种场景:场景1:料品按存储地点设置安全库存,当存储地点的料品在库数量小于安全库存时进行预警。场景2:料品档案上设置安全库存,当料品的在库数量小于安全库存时进行预警。 |
问题原因: |
- |
解决方案: |
问题原因:预警的SQL复杂一些,可参考解决方案中的SQL进行调整。解决办法:场景1:料品按存储地点设置安全库存,当存储地点的料品在库数量小于安全库存时进行预警。预警设置:(1)应用:基础设置(2)预警对象:存储地点料品交叉(3)预警条件:(条件中字母区分大小写)ID in (select ID from (select a.ID as ID ,isnull(c.qty,0) as Qty,c.Wh as Wh,c.Item as Item ,a.SafeInvQty as SafeInvQtyfrom UFIDA::U9::CBO::SCM::Warehouse::WhItem as aleft join ( select b.Wh as Wh ,b.ItemInfo.ItemID as Item,sum(b.StoreQty) as qty from UFIDA::U9::InvTrans::WhQoh::WhQoh as b group by b.Wh,b.ItemInfo.ItemID) as c on a.Wh = c.Whand a.Item=c.Item and a.Wh =c.Wh where a.Org.Code=组织编码 ) as dwhere d.Qty0)场景2:料品档案上设置安全库存,当料品的在库数量小于安全库存时进行预警。预警设置:(1)应用:基础设置(2)预警对象:料品档案(3)预警条件:(条件中字母区分大小写)ID in (select ID from (select a.ID as ID ,isnull(c.qty,0) as Qty,a.InventoryInfo.SafetyStockQty as SafetyStockQty from UFIDA::U9::CBO::SCM::Item::ItemMaster as aleft join ( select b.ItemInfo.ItemID as Item,sum(b.StoreQty) as qty from UFIDA::U9::InvTrans::WhQoh::WhQoh as b group by b.ItemInfo.ItemID) as c on a.ID=c.Item where a.Org.Code=组织编码 ) as dwhere d.Qty 0 )存在的缺陷:预警信息中只能显示预警对象的属性,所以只能显示安全库存,显示不了库存的在手量。 |
录入日期: |
2013-9-6 11:16:15 |
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
当库存的在手量低于安全库存时,系统进行预警。分2种场景:场景1:料品按存储地点设置安全库存,当存储地点的料品在库数量小于安全库存时进行预警。场景2:料品档案上设置安全库存,当料品的在库数量小于安全库存时进行预警。 |
|