材料出庫單補料選生産加工單選不到(dào)産品

問題現象：

材料出庫單業務類型為生産補料，藍理選擇生産加工單時(shí)，産品明細選不到(能微dào)某個産品，過(guò)濾條件中也勾選了包含已執行完領料。

見下圖，生産加工單産品明細有22行，笑唱材料出庫單選擇生産加工單時(shí)産品明細隻有21行，

經(jīng)過(guò)查看缺少的産品明細是00020013

問題分析：

1、用事(shì)件探查跟蹤器跟蹤完後子技(hòu)複制下面(miàn)跟蹤過(guò)後(h明算òu)的腳本到(dào)數據庫中間和執行。

select TOP 10000 [ManufactureOrderDe議習tail].isManualFinish, [Manufact請機ureOrderDetail.ManufactureOrder].歌跳code AS

ManufactureOrderDetail_Man紙但ufactureOrder_Code,[M算上anufactureOrder吧多Detail.Inventory].光視code AS

ManufactureOrderDetail_Inve科來ntory_Code,[ManufactureOrderDetail.Inve動新ntory].name AS M喝畫anufactureOrderDetail時化_Inventory_Name,[Ma我老nufactureOrderDetail].free拍女Item0 AS Manufactur金刀eOrderDetail_freeItem0,[一銀ManufactureOrderDetail].f也影reeItem1 AS Manufactur遠短eOrderDetail_freeItem1,[Manuf能木actureOrderDetail].fr河這eeItem2 AS ManufactureOrderDetail_f花道reeItem2,[Inventory].code AS I我文nventory_Code,[Inventory].name AS購媽 Inventory_Name,[Inventory].也業specification AS Inventor嗎少y_Specification,[SubstituteMainI快話nventory].code AS SubstituteMainInvento用呢ry_Code,[SubstituteMainInve媽話ntory].name AS S喝姐ubstituteMainInventory_Name,[Manufac火到tureOrderMaterialDet錯民ailDTO].freeItem0 AS freeIte看河m0,[ManufactureOrderMaterialD林森etailDTO].freeItem1 AS freeItem就師1,[ManufactureOrderMaterialDe道愛tailDTO].freeItem2 AS freeItem2,[Proces的林s].name AS Process_Name,[U的電nit].name AS Unit_Name,[Manufactur玩開eOrderMaterialDetailDTO].quan是行tity AS Quantity,[M綠明anufactureOrderMaterialDetailD弟雜TO].totalRequisitionedQuantity 數物AS TotalRequisitionedQuantity,地村[ManufactureOrderMaterialDetail業知DTO].totalAdditionalMa術腦terialQuantity AS但姐 TotalAdditionalMaterialQuantity月店,case when [Manuf日費actureOrderMate人金rialDetailDTO].quantity-IsNull([Manuf草土actureOrderMaterialDetailDTO]身坐.totalRequisitionedQuantity,0)<0 t志國hen 0 else [Manufactur吃亮eOrderMaterialDetailDTO].quantity-書暗IsNull([ManufactureOrderMateri飛和alDetailDTO].totalRequisitionedQuan那窗tity,0)end AS Have年朋PickingQuantity,[Manufacture呢農OrderMaterialDetailDTO].id AS I木你D,[ManufactureOrderMa科從terialDetailDTO].idManufactur好窗eOrderDetailDTO AS

IdmanufactureOrde光志rDetailDTO,[ManufactureOr討湖derMaterialDetailDTO].voucherId AS 筆遠VoucherId,[ManufactureOrderDetail].cod喝電e AS ManufactureOrderDetai老章l_Code,[ManufactureO錯湖rderMaterialDetailDTO].code AS Co那多de,[Inventory].i刀綠d as Inventory_id,[Un媽體it].id as Unit_司靜id,[ManufactureOrde老章rDetail].id as ManufactureOrderDetail_i黑報d,[ManufactureOrderDetail.Inventor月劇y].id as ManufactureOrder舊內Detail_Inventory_id,[Manu嗎化factureOrderDetail.ManufactureOrde中弟r].id as Manufactur日坐eOrderDetail_ManufactureOrder_id,[Pr坐錢ocess].id as Process_id,[Substitute制店MainInventory].id as Substi煙國tuteMainInventory_id

from [MP_ManufactureOrder_Material]街拍 [ManufactureOrderMaterialDetailD厭高TO]

LEFT OUTER JOIN [V_AA_Inventory] [In員票ventory] on [ManufactureOrderMateri遠睡alDetailDTO].idinventory=[Inventory]事可.id

LEFT OUTER JOIN [AA_Unit] [Unit] on內明 [ManufactureOrderMateria飛大lDetailDTO].idunit=[Unit].id

LEFT OUTER JOIN [MP_Ma了舊nufactureOrder_b] [會影ManufactureOrderDetai船弟l] on [ManufactureOrderMaterialDetailDT房放O].idManufactureOrderDetailDTO=[Manufac工亮tureOrderDetail].id

LEFT OUTER JOIN [V_AA_Invento作有ry] [ManufactureOrderDetail.Inventory] 新公on [ManufactureOrderDetail].idin理農ventory=[ManufactureOrder拿匠Detail.Inventory].id

LEFT OUTER JOIN [MP_M坐愛anufactureOrder] [ManufactureOrde飛頻rDetail.ManufactureOrder] on 訊跳[ManufactureOrderDe報雪tail].idManufactureOrderDTO=[Manufact下數ureOrderDetail.慢就ManufactureOrder].id

LEFT OUTER JOIN [AA_D拿車epartment] [ManufactureOr畫車derDetail.ManufactureOrder綠但.Department] on 紅外[ManufactureOrderDetail.Manufa可問ctureOrder].iddepartment=[Manu吧兒factureOrderDeta雪書il.ManufactureOrder.Department].id

LEFT OUTER JOIN [AA_Process] [Proce土都ss] on [Manufactur服聽eOrderMaterialDetailDTO].idP事慢rocess=[Process].id

LEFT OUTER JOIN [V_AA_Inventory] [村商SubstituteMainInven算藍tory] on [ManufactureO風時rderMaterialDetailDTO].idSubstituteMa件員inInventory=[SubstituteMainIn到時ventory].id

where 1=1 And (([ManufactureOrd來書erDetail.Inventory].年你Code>= N'0002通家0013' AND [ManufactureOrder麗冷Detail.Inventory].行爸Code<= N'00020013'慢服;)

And ([ManufactureOrderDetail.Man習章ufactureOrder].Code>商媽;= N'MO-2022-09-0風拍002' AND [Manufactu很畫reOrderDetail.ManufactureOrder].Code&l關我t;= N'MO-2022-09-0002'廠自)) AND [ManufactureOrde年水rDetail.ManufactureOrder].Vouch用明erState = N'189'

AND [Manufactur話件eOrderDetail.Manufa但銀ctureOrder.Department].Disabl光熱ed = 0 AND [ManufactureOrderDet水離ail.Inventory].Disable廠見d = 0

AND isnull([ManufactureOrderDet哥場ail].isManualFinish,0) <> 1

AND [Inventory].Disabled = 0

AND isnull(ManufactureOrderMat費到erialDetailDTO.TotalDispatch制慢ingCount,0) <= 0 樹厭AND ISNULL(Manu友亮factureOrderMaterialDetailDTO.I市對sClose,0) = 0

AND ISNULL(ManufactureOrderMat綠鄉erialDetailDTO.Subs車嗎tituteGroupID, N&村這#39;') = N'' AND Is照姐Null(ManufactureOrder件得MaterialDetailDTO.I林機sInvertedMaterial,0) = 0

AND 1=1 order by [ManufactureOrderDet關姐ail.ManufactureOrder].Code,[Manufact了視ureOrderDetail].Code,Manu為靜factureOrderMaterial自舊DetailDTO.Code

2、執行發(fā)現是語句isnull([ManufactureOrd樂紙erDetail].isManualFin和個ish,0) <>在畫 1 引起(qǐ)的問題。

3、執行下面(miàn)語句查詢該字段在軟件中代表的身內字段意思，可以發(fā)現該字段表示的是【是否手動完工】長男

select*from eap_DT唱坐OProperty where Name='isManualFinis車車h'

在軟件中生産加工但單産品明細勾選顯示手動完工字段，可以看到(dào)産品000技開20013已手動完工，所以在生産補料時(shí)選不到(dào)。

解決方案：

1、取消生産加工單上該産品手工完工的勾選