How would I add " Informational Only" on a remittance report if the net amount is $0.00 and the check number starts with Remit# ?...and just standard if it doesn't meet the condition
This is what I did and it didn't work.....
Conditional: wildcard("" Remit*"") = PM_Payment_Work.Document Number AND PM_Payment_Apply_Work.Net Check Amount = 0.0000
True Case: "Informationak Only"
Any help will be greatly appreciated.
Thank you
*This post is locked for comments
Hi,
In your conditional expression "Remit*" needs to be UPPER CASE. That is, it should be: "REMIT*"
Thanks,
Justin
Try creating a calculated field. In that field use RW_Left: Function_Script(RW_Left [YOUR FIELD] 4)
Then setup a conditional field that checks if the calculated field = "Remit"
You may have better luck with setting up the separate calculated field and using it in the conditional field instead of trying to wildcard the field in the conditional statement.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (