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
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
    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
      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
        Posts: 34
        Advanced Member
        2/16/2015 2:12 PM
          Hi,
          I sent you a private message.
          Thanks
          Joanne Bloom
          Basic Member
          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
            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
              Posts: 3353
              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
                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
                  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
                    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
                      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?