Welcome, Guest. Please Login.
11/01/24 at 15:38:32
News:
Home Help Search Login


ISTech Support Forum › Evo-ERP and DBA Classic › Suggestions for Updates ‹ Previous topic | Next topic ›
Pages: 1
Send Topic Print
Tracking Obsolete Items in Inventory (Read 1207 times)
Mike_Vader
Ex Member
Tracking Obsolete Items in Inventory
01/20/04 at 15:39:32  
I have noticed that if you slog through the 1000s of error messages in the where-used inquiry you can eventually get a report that tells you where every item is used.
 
An interesting thought came to mind that if we could set the flag differently to select ONLY items for INACTIVE parents we could very easily get a list a of items that require flushing from our inventories...
 
Is this possible? Does anyone else see value in this type of report? Roll Eyes
Back to top
 
 
  IP Logged
John Bierrie
Browser
*




Posts: 41
Re: Tracking Obsolete Items in Inventory
Reply #1 - 01/21/04 at 02:06:35  
Mike,
 
I would give my eye-teeth to have something that would pinpoint this!!
Back to top
 
 
John H. Bierrie
W.I.C.C. Ltd.
Email WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Tracking Obsolete Items in Inventory
Reply #2 - 01/21/04 at 09:29:02  
You both realize this is relatively easy to accomplish using MS Access right?
Back to top
 
 
Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 639
Gender: male
Re: Tracking Obsolete Items in Inventory
Reply #3 - 01/21/04 at 17:20:38  
I have an Excel Report or WINSQL Script that lists out all the item numbers that meet this criteria.   Please contact me if interested.
Back to top
 
 
Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Mike_Vader
Ex Member
Re: Tracking Obsolete Items in Inventory
Reply #4 - 01/26/04 at 10:37:31  
Lorne,
 
I agree with you - it would be easy enough to do in Access - I was asking a question to see if it would be something useful for everyone- if such, it would probably be an easy report to suggest adding.
 
If it wasn't useful to others, of course I would take the time to make it in Access.
 
Mike
Back to top
 
 
  IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Tracking Obsolete Items in Inventory
Reply #5 - 01/26/04 at 18:00:11  
Mike,
 
Okey-dokey.... Grin
Back to top
 
 
Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Tracking Obsolete Items in Inventory
Reply #6 - 02/14/04 at 09:13:13  
I have had several similar requests off the forum as well.  How does this sound?
 
Filter for From/Through Item Number, Class, Category.  Enter type (default to R but allow others).  Also prompt for Include only Active items so anything already marked as Inactive would be excluded.
 
Finally, prompt for Inactive Parents, No Parent or Both (I/N/B).
 
Items would be included on the report if they belong to no BOM and/or if all BOMs they do belong to are for Inactive parents.  After the report prints, you have the option to make them all Inactive and/or transfer them all to a different Item Class so all your unused stock could be assigned to a single class and reported on easily in the future.
 
Comments and suggestions welcome before I send this to programming.
Back to top
 
 
Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
tdsimon
Browser
*




Posts: 4
Re: Tracking Obsolete Items in Inventory
Reply #7 - 02/18/04 at 10:02:28  
Lynn, my engineering folks were just asking for such a report.  We will eagerly await its completion.
 
Thanks, Todd Simon
Back to top
 
 
  IP Logged
John Bierrie
Browser
*




Posts: 41
Re: Tracking Obsolete Items in Inventory
Reply #8 - 02/18/04 at 14:55:37  
Maybe I am missing something (likely I am), but can it also have a "last issued", "last received" date criteria as well?  Then I could look specifically at anything that had NOT been used, or received, or both, since (as an example) last Jan. 1, 2003...
 
Maybe that is part of "Active" or "Inactive" parts, but I have not figured that out either...Sad
 
Thanks...
Back to top
 
 
John H. Bierrie
W.I.C.C. Ltd.
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Tracking Obsolete Items in Inventory
Reply #9 - 02/18/04 at 19:46:44  
That information is already available at UT-A, program BKACT.  It looks at transaction data and returns a list of parts with no transaction activity of the type specified for the date range entered.
 
UT-A, Program BKACT.  Create a report name and for the Primary Filter, if you ONLY wnat items that have had no activity, choose the last one - Active+Changed.  The report will list all active items with no activity of the specified type within the dates entered and suggest changing status to Inactive.  You can make the change of status or just print the report and leave the status alone.
Back to top
 
 
Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Mike_Vader
Ex Member
Re: Tracking Obsolete Items in Inventory
Reply #10 - 02/26/04 at 11:32:44  
Lynn,
 
Your suggested solution sounds great!
 
My team will certainly appreciate this report.
 
Mike    Grin
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Tracking Obsolete Items in Inventory
Reply #11 - 04/21/04 at 15:31:20  
OK, this one is done for the 4/23 update.  Select range of Items, Class, Category, Type.  Choose No Parent, Only Inactive Parent(s) or both.  Report lists items with no Parent or only Inactive Parents, as selected, both description lines, Type, Calss, Category, unit cost and extended value of on-hand stock subtotaled by Class.  After viewing the report, you are given the option to make the parts Inactive and/or change them to a different Item Class.
 
 
Sneak preview available, email me and I will send it to you.
Back to top
 
 
Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print
ISTech Support Forum › Evo-ERP and DBA Classic › Suggestions for Updates ‹ Previous topic | Next topic ›

ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.

Valid XHTML Valid CSS Powered by Perl Source Forge