We have hundreds of items on sale with different beginning and end dates. I need to create a report to show all items that have an active sale date. The report would have a column for the checkbox, "this item is on sale." I can't find the field name on the item table for the checkbox "this item is on sale," in order to create the report.
*This post is locked for comments
Thank you. That works. I was able to edit another report to include a column to display the Sale Type checkbox indicating which items are actively on sale.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,336 Most Valuable Professional
nmaenpaa 101,156