Index: AX/Uitgaand/PM/BehoeftePlanning/impl/BehoeftePlanningIterator.cls.xml =================================================================== diff -u -r42310 -r42321 --- AX/Uitgaand/PM/BehoeftePlanning/impl/BehoeftePlanningIterator.cls.xml (.../BehoeftePlanningIterator.cls.xml) (revision 42310) +++ AX/Uitgaand/PM/BehoeftePlanning/impl/BehoeftePlanningIterator.cls.xml (.../BehoeftePlanningIterator.cls.xml) (revision 42321) @@ -48,17 +48,13 @@ Set SqlStatement = "SELECT ID FROM Prod.Product WHERE isnull(Gentype,'')='' AND KortTekst NOT LIKE 'GEN%' AND StockNietStock = '1'" _" AND LinkType NOT LIKE 'S' AND LeverancierNummer NOT LIKE '6051'" // Indien nodig is hieronder een filter voorzien om het resultaat te beperken tot overzichtelijk, voor debugging: - _" AND ID IN (1175,1988,2865,161441,161442,254245,254258,268026,353741,353743,353744,383880,665626,668615,682391," - _"709825,830257,830507,878186,878220,906194,924268,1038806,1039173,1039208,1067709,1067714,1124771,1155640,1168369,1168689," - _"1168696,1169509,1194443,1247980,1259381,1359867,1425095,1425096,1432225,1572233)" + _" AND ID IN (34716,100434,200582,254237,353739,371127,379316,446650,534374,568105,568123,670483,683737,683793,701496,701513,754875)" } Else { If ..Vestiging = ##class(AXimpl.InterneFirmaInitialen).HaluxNv() { Set SqlStatement = "SELECT ID FROM Prod.Product WHERE isnull(Gentype,'')='' AND KortTekst NOT LIKE 'GEN%' AND StockNietStock = '1'" _" AND LeverancierNummer NOT LIKE '6332'" // Indien nodig is hieronder een filter voorzien om het resultaat te beperken tot overzichtelijk, voor debugging: - _" AND ID IN (1175,1988,2865,161441,161442,254245,254258,268026,353741,353743,353744,383880,665626,668615,682391," - _"709825,830257,830507,878186,878220,906194,924268,1038806,1039173,1039208,1067709,1067714,1124771,1155640,1168369,1168689," - _"1168696,1169509,1194443,1247980,1259381,1359867,1425095,1425096,1432225,1572233)" + _" AND ID IN (34716,100434,200582,254237,353739,371127,379316,446650,534374,568105,568123,670483,683737,683793,701496,701513,754875)" } Else { Do ##class(TECH.ExceptionHandler).Throw(##class(TECH.Exceptions.IllegalArgumentException).%New("Geef als parameter ofwel VHBE, ofwel HLX mee! Huidige parameter = '"_..Vestiging_"' <"))