Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum

Report Writer Conditions - multiple conditions/repeated

Posted on by 2
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:

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans