Question
Is there a report that shows “Active” vs. “Inactive” inventory items?
Answer
There’s no DirectScale-made report that features such data; however, you can create a custom report.
Admin: Corporate Admin
Page: Reports > Custom
URL: [CLIENTID].corpadmin.directscale.com/Corporate/Reports/Custom
Permission: ManageCustomReports() or ViewCustomReports()
-
Click the Add Report button and select SQL Report Builder.
-
Enter the SQL query in the Query Box.
The INV_OptionItemKeys table shows Active as True or False.
Select * from INV_OptionItemKeys
-
Click Save.
Comments
Please sign in to leave a comment.