I'm modifying the "IV Stock Count Forms by Item ID" report. A consultant had adjusted this previously to only show items with captured_quantity > 0. I need to add conditions that use wildcard matching on the item number to only apply that captured_qty > 0 condition to certain item classes. In our part numbering scheme, items in a class share the same first four letters in the item number. However, when I try to add more than one WILDCARD function expression with item number to a restriction, I get a "Symbol already defined" error when I try to run the report.
Example Restriction that errors:
( ivStockCountLine.CapturedQty > 0 AND ( WILDCARD( "HSMS*" ) = ivStockCountLine.ItemNumber OR WILDCARD( "TUNS*" ) = ivStockCountLine.ItemNumber ) ) OR ( WILDCARD( "HSMS*" ) <> ivStockCountLine.ItemNumber AND WILDCARD( "TUNS*" ) <> ivStockCountLine.ItemNumber )
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
8
Share
Report
All responses (
Answers (
