Share
ReportIs there a way to make inventory items inactive so they not only can't be used anymore but also don't show up on reports?
*This post is locked for comments
I have the same question (0)
You’re offline. This is a read only version of the page.
25
Is there a way to make inventory items inactive so they not only can't be used anymore but also don't show up on reports?
*This post is locked for comments
I have the same question (0)
As you're probably already aware, you can set the Transaction status code to "Inactive" (inventory.transtatuscode = 'IN') but of course that doesn't remove it from reports.
The only way to do that is to make sure that the report links back to the inventory table, and use a template or select statement to include records where the inventory.transtatuscode not equal IN.
Unfortunately, many reports that reference an inventory ID don't necessarily link back to the inventory table so that would need to be customized to include that link.
We feel your pain. 60% of the inventory ID's in my inventory master are inactive!
Best regards,
Gail J-N
All responses (
Answers (
