|
There is a group # 1 :
{INVENTORY.WHSE} in {?BV99IN01FromWarehouse} to {?BV99IN02ToWarehouse} and
{INVENTORY.CODE} in {?BV99IN03FromPartNumber} to {?BV99IN04ToPartNumber} and
{UNIT_OF_MEASURE.SELL_UOM} = 1 and
(if instr({?BV99PC01FromProductCode},"?") = 0 // when there are no wildcards
then {INVENTORY.PROD} in {?BV99PC01FromProductCode} to {?BV99PC02ToProductCode}
else lookslike({INVENTORY.PROD},{?BV99PC01FromProductCode})) and
(if not({?BV99IN23IncludeHeldItems})
then {INVENTORY.HOLD} = 0
else
{INVENTORY.HOLD} < 2) and
{INVENTORY.INV_DESCRIPTION} in ["GOLDEN STARTENA (layers - extra small crumble) 25k", "GOLDEN LAYENA TEX 25kg", "GOLDEN LAYENA L 25kg", "GOLDEN GROWENA 25kg", "HORSE BLOCK 25KG", "HORSE PLUS 25 KG", "BMZ 3KG", "ATHLETE HORSE 20kg", "Apple chunks 10Kg", "APPLE CHUNKS - 1 kg Package", "EQUILIBRIUM OPTIMAL 25kg", "EQUILIBRIUM EQUILIZER 25kg", "EQUILIBRIUM INTEGRI-T 25kg", "EQUILIBRIUM FIBRA CLASSIC 25kg", "EQUILIBRIUM FIBRA PLUS 25kg", "EQUILIBRIUM PRO PLUS 25kg", "EQUILIBRIUM TRIMAX 20kg", "EQUILIBRIUM SPORT XT 20kg", "EQUILIBRIUM MATERNITY XT 20kg", "VELOCI-T MAX 20kg", "VELOCI-T TRADITION 20kg", "OMOLENE SENIOR ACTION 20kg", "OMOLENE SPORT PLUS 20kg", "OMOLENE SPORT 200 20kg", "OMOLENE MATERNITY 300 20kg", "EVOLUTION SENIOR 20kg", "EVOLUTION SPORT ELITE 20kg", "EVOLUTION JUVENILE 20kg", "EVOLUTION MATERNITY 20kg", "SIMPLICI-T NATURE 25kg", "SIMPLICI-T PRO GRAIN 25kg", "SIMPLIC-T PRO 25kg", "SIMPLICI-T ORIGINAL 25kg", "SIMPLIC-T FIBRA 25kg"] and
(if {?BV99IN27IncludeItemsOfType} = 1
then {INVENTORY.TYPE_KEY} <> "V"
else if {?BV99IN27IncludeItemsOfType} = 2
then {INVENTORY.TYPE_KEY} = "V"
else {INVENTORY.TYPE_KEY} >= "" )
and a Group # 2 :shows the same formula in select expert.
I do not know how to check other information about these groups. The only group I made was # 2, # 1 was already in the report ( I am editing a report that is prebuilt into the software business vision by sage)
So how do I fix this then or proceed?
|
IP Logged
