Good Morning All,
How can i run a report on materials (excel) for Inactive, No Purchase, Marked for Deletion and No vendor materials.
I am new to this platform still, please intricate detail instructions.
Thank you.
Best answer by Dana Moffat
View original
I want to run a report on all items within my system.
But i want to be able to segregate by these parameter's, Inactive, no purchase, marked for deletion, materials with no registered vendor, obsolete, replacements etcetera…
Hello
If you navigate to Inventory > Reports > Inventory Balance, it’ll take you to a Report Configuration page where you can configure the report parameters. Example below:
If you run the report as-is, you’ll get a list of your Inventory Balance with Unit Cost, On Hand, etc. Example below:
Let me know if this helps answer your question, otherwise you would need to take advantage of the “Additional sort and filters” section of the Inventory Balance screen to narrow down the information you’re looking for. Thanks!
Thank you, How would i choose by ‘ITEM STATUS’ ?
Hi
+2
Hi
You could use the filter on the Stock Items to query on the Statuses that you’re interested in. You could then produce a report, by exporting the result set to Excel.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
