• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Usage/History Reports

 10 Replies
 2 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Joanne Bloom
Basic Member Send Private Message
Posts: 7
Basic Member
2/16/2015 1:46 PM
I need to pull together PO history reports for ECRI and Premier Ascend that include our item #, vendor item #, manufacturer #, quantity on PO, pricing, contract information, etc.  I am a novice at this and don't have any report writing program to help me (no Crystal).  I'm running MM280's, PO213, PO254, and doing addin's to pull information out of the IC11, IC14, and PO25's.  Then I'm going to have to do vlookups to pull all this data together.  Seems like there should be an easier way.  Can anyone share their knowledge with me.  Thank you!!!
The Alchemist
Advanced Member Send Private Message
Posts: 34
Advanced Member
2/16/2015 2:01 PM

Hello,

Do you have access to Add-Ins? I have a query that I use to send our data to ECRI that I could share with you.

Joanne Bloom
Basic Member Send Private Message
Posts: 7
Basic Member
2/16/2015 2:04 PM
Yes, I do have add-ins.  I would greatly appreciate anything you can share with me. 
The Alchemist
Advanced Member Send Private Message
Posts: 34
Advanced Member
2/16/2015 2:12 PM
Hi,
I sent you a private message.
Thanks
Joanne Bloom
Basic Member Send Private Message
Posts: 7
Basic Member
2/16/2015 2:44 PM
Sorry, but I'm not getting anything in my messages.  It just keeps churning like it's trying to load something, but nothing happens.  Could you please send to my email joanne.bloom2@evanhospital.com
JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
2/23/2015 2:43 PM
I have that same problem with my private messages in IE. Not sure if it's an IE issue of java issue or what so I use Google Chrome for this site. Works a lot better.
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
John Henley
Send Private Message
Posts: 3351
2/23/2015 3:13 PM
jon, what version of IE are you using?
I have tested with IE11 and with LawsonGuru.com as a trusted site, and that is working.
Thanks for using the LawsonGuru.com forums!
John
tsouthall
New Member Send Private Message
Posts: 1
New Member
9/1/2015 11:52 AM
I am having the same problem as Joanne trying to get all the Usage and History information without Crystal Reporting. I do have lawson Add-ins. Could I use your query template?
SCMaster-jk2
Veteran Member Send Private Message
Posts: 100
Veteran Member
9/2/2015 5:24 PM

Hey - I've uploaded my add-ins query for PO history. Maybe it's something that could get you started?

Attachments
Carolina
New Member Send Private Message
Posts: 2
New Member
5/20/2016 1:24 PM

I am running our PO history monthly by pulling the date to in PO254. I have MS add in and I was wondering you are willing to share with me how to run in querry. thank you.

Mike Bernhard
Veteran Member Send Private Message
Posts: 101
Veteran Member
5/21/2016 12:06 AM
There is a query file (dme) attached to the previous post. If you dont know how to use it, it is not hard to learn but you need to get some training- its a bit too complex to teach using this forum. That said have you tried using mm280?