一、创建视图
CREATE OR ALTER view [dbo].[v_WMSTaskBillMaterial]
as
select tbm.Id,'Production_TaskBillMaterial' TableName,
tbm.Id TableId,
tbm.MaterialId,
tbm.TaskBillId,
tbm.TaskBillId TaskId,
tbm.SortNo,
tbm.CalCount Qty,
tbm.AlreadyQty BillEntryPushedQty,
tb.TaskBillNo BillNo,
tb.TaskBillNo CusBillNo,
tb.Id BillId,
m.Code MaterialCode,
m.Name MaterialName,
m.Model MaterialModel,
m.Specification MaterialSpecification,
m.DrawingNum MaterialDrawingNum,
tbm.EntityId,0 QCNGQty,
tbm.SubWarehouseId WarehouseId,
wh.Name WarehouseName,
wh.Code WarehouseCode,
tbm.SubWareareaId WareareaId,
wa.Name WareareaName,
wa.Code WareareaCode
from
Production_TaskBillMaterial tbm
left join Production_TaskBill tb on tbm.TaskBillId=tb.Id
left join Basic_Material m on tbm.MaterialId=m.Id
left join Basic_WareArea wa on tbm.SubWareareaId=wa.Id
left join Basic_WareHouse wh on tbm.SubWarehouseId=wh.Id
where tbm.Status<2
GO
二、单据建模修改配置
将新建的源单添加到源单视图中,并且允许新建单据。
至此,生产领料可以按照视图内容进行源单的添加。生产领料单审核后会影响对应任务单的物料需求已领料数量信息。
如果生产领料用于其他逻辑不方便修改配置,“返工领料”的单据类型也可以实现类似功能。