infor.com
concierge
infor u
developer portal
Posts
Categories
Groups
Hubs
Developer
Healthcare
Hospitality
Public Sector
CloudSuites
Aerospace & Defense (LN)
Automotive (LN)
Chemicals (M3)
Corporate (FSM/HRT)
Distribution (Sx.e/CSD)
Distribution Enterprise (M3)
Engineering & Construction (LN)
Fashion (M3)
Food & Beverage (M3)
Healthcare (FSM/HRT)
Industrial (Syteline/CSI)
Industrial Enterprise (LN)
Manufacturing (M3)
Public Sector (FSM/HRT)
Solutions
Supply Chain Management (SCM)
Human Capital Management (HCM)
Events
Groups
Your Groups
User Groups
Migrated Forums
FSM/HCM/S3 - Infor Lawson 10.x
HCM/S3 - Learning and Development
HCM/S3 - Global HR
HCM/S3 - Talent Acquisition
HR Service Delivery
Human Capital Management (HCM) - EMEA
Infor Configuration Management for Service Industries
Lawson - Business Intelligence
Lawson - Financials
Lawson - Human Resources
Lawson - Supply Chain
Lawson - Supply Chain Management
Lawson - Technology
MSCM on Landmark
About
Community News
Email Community Support
Home
Groups
Lawson - Supply Chain Management Customer Community [READ ONLY]
Item Master clean up - Last ordered / used report
Legacy Contributor
I hope I am missing an obvious report, but I am trying to find a way to list each item in IC11 and the last used/issued date. We have multiple IC12 locations and I am looking for a report which will give me the last PO date, AND the last issue date from all locations. If someone has one already created would you be willing to share it with me?
Thanks in advance!
CloudSuite Financials & Supply Management Analytics with Birst - G.pdf
Find more posts tagged with
Comments
Legacy Contributor
Jonathan, the IC227 report gives you the last issue date and the last received date. Would that work for you?
Legacy Contributor
The IC227 will give me the answer for the IC12 areas, but it will not tell me items that are orderd by a vendor directly to the department. They are not Inventory Tracked in IC12, so the IC227 will not report on it. Thank you.
kheeter
Jonathan,
Will you be wanting this information on a reoccurring basis or is this a onetime need? In addition, how comfortable are you with Excel, Add-Ins and more specifically, macros? Here’s why I’m asking.
As far as I can tell there isn’t a single report that will provide you with the information you’re looking for. By running several custom Add-Ins reports onto a macro driven spreadsheet, the data could be compiled in a matter of minutes. That’s a very simplistic description of what it will do as there’s a load of formulas that would pull it all together for you built into the macro.
Let me know.
Mark
Legacy Contributor
Mark,
I am wanting it to be able to run every 6 months or so to use to inactivate items in hopes of reducing the number of items that need cleansed.
I am comfortable with Excel and the Add-ins. I have not really worked with the Macros, but why not start learning now.
I have build an Add-in to pull the last issue date for each IC12 Location, and merge them to get that inforamation, but it seems to be the N type items that are haunting me on this journey.
Thanks you for any additional help you can give.
Jonathan.alden@mymlc.com
0811130630195911.xls
Important Links
Community Hubs
Discussion Forums
Groups
Community News
Popular Tags
CPQ: Ask a Colleague
FAQs, How-To, and Best Practices
Idea
Infor OS Portal
UI Design
CPQ: Tips and Tricks
Infor Homepages
Widget Development
Infor EPM Migration
Infor Ming.le
