Dynamics Community Forum Thread Details

Report Writer Conditions - multiple conditions/repeated

Running Dynamics GP 18.4.

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 )

Categories:

Reporting and BI

Quick Links

Leaderboard