Can you Paste more than One Lawson # in a Screen?

Sort:
You are not authorized to post a reply.
Author
Messages
David M
Basic Member
Posts: 11
Basic Member
    Hello, I am new to lawson (2 months experience) and need to know if there is any way to past more than one Lawson number in a screen.

    Example: I would like to take say 50 lawson #'s and get pricing for all units of measure in PO28. I have tried create a query as an add in but cannot find the correct fields to use as table, and when I do find all the right fields in the application portion of query, it times out every time before I get the report.

    Does this make any sense?

    I'm glad I found a Lawson forum, I hope to learn lots here, thanks.

    David
    Kat V
    Veteran Member
    Posts: 1020
    Veteran Member
      The table is POVAGRMTLN - no there is no way on PO28 to get to display more than one line.

      You would query the table with Hold Flag = 'N' but I don't know why it is timing out on you - that sounds more like an issue with your query server - are you using add-ins query wizard?  There a green/yellow double arrow next to the open and save icons that will let you lengthen the time out values.

      I run a downtime query that dumps my item master with vendor and pricing information - it takes 3 minutes for a return of over 50,000 lines but never times out.


      Edit: You are using the add-in query.  Just saw it.  Change the time out value to 9999 and it should run.
      Greg Moeller
      Veteran Member
      Posts: 1498
      Veteran Member
        Do you know about Ctrl-Shift-O ? That may help when identifying fields from Lawson screens.
        David M
        Basic Member
        Posts: 11
        Basic Member
          Hi Kat, thanks so much for your response. I tried the table that you suggested and it worked for a couple items that I put in the criteria section. My question now is how would I run this report for all the items in our IC12? I tried adding index and putting our main code in and it comes up with nothing.

          Thanks.
          Kat V
          Veteran Member
          Posts: 1020
          Veteran Member
            If the location is showing in the indexes - it's probably NOT the Item Location from IC12 - it's probably the From Location on the PO25.3 header participants.  Assuming you are like every other organization I've spoken to - you do not restrict your price agreements there.  So the value you are entering does not have any price file lines attached and it is "correctly" yielding no results.


            I do not know of anyway to make a query wizard run against a pivot table or to link back from POVGMTLN to ITEMLOC - you'd need an actual sql to do it.  Crystal, ODBC, Microsoft SQL or some such.

            Greg Moeller
            Veteran Member
            Posts: 1498
            Veteran Member
              If you are looking for a list of Items, why not just run IC210? Or if you'd like HL7, you could run IC526, or IC527 to get all items in a report.
              JonA
              Veteran Member
              Posts: 1162
              Veteran Member
                Having values in the index probably won't help you much in this instance. I would leave that blank and have only "Hold Flag = N" in your criteria and this will return all active agreement items. The query wizard is limited in that it doesn't relate POVAGRMTLN to ITEMLOC. So I would query your ITEMLOC table seperately and run a VLOOKUP function in Excel to match the agreement items to the items in IC12.
                Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
                David M
                Basic Member
                Posts: 11
                Basic Member
                  Thanks so much for all of your help!! I was able to get the DME designed and ran it for PO28. I believe I can select the UOM box and put in each unit of measure, run the report for each UOM and then I will have reports of all active items and specific UOM's that I am looking for. The whole reason for all of this is to eventually make some of my daily tasks easier and faster. I have to take a bunch of Lawson #'s and get pricing for specific UOM. I can now have all these reports in different worksheets and then run a macro to do v-lookup at the touch of a button!

                  Greg--Im going to try some of the screens you have mentioned to see if they will spit out a similar report. I'll let you know if it works.

                  Thanks again everyone!

                  David
                  Red
                  Veteran Member
                  Posts: 87
                  Veteran Member
                    So, I thought I would step in with a few comments and then get back out of the way...

                    1 - I think you would be better off getting a true reporting tool.  As someone alluded to (I believe it was JonA), MS Addins will not allow you to make your own joins, you are limited to the joins it has predefined.  It is definitely good for some quick reviews, and I would be lost without the upload function, but there are very set limits to its functionality.  Many of us use Crystal Reports, some use Cognos, and I am sure there are a handful of other tools that perform much higher-level queries.

                    2 - A quick caveat about the IC527.  The first time you run the report, you will get all of the item locations defined.  Thereafter, it will only bring up any item location that has experienced a change in any of a number of fields.  You can get around this by deleting the underlying workfile (essentially the "was" snapshot that the program is using to compare against), but that seems like an arduous way to gather the information you are looking for (especially in what amounts to small numbers of items).

                    3 - If you are going to use the VLookUp route, I would suggest using the RNGDBDUMP (assuming you have access) to pull the table(s) information.  For larger tables/files it is quicker, but you will have to ftp the file to your workspace.  Depending on the version of Excel/Addins you are using, this also helps work around the 65K line limit of older versions.

                    Bonus - If you have an ODBC connection to your database (or, as I do, a reporting replication of the data), I have a Rube Goldberg process that downlads into Excel via Access.  It sounds odd, but it allows you to create your query in Access, and pull the results into Excel. It is pretty quick and bypasses the 65K line limit as well.

                    Best of luck, and welcome,
                    Red
                    Learn from the Past. Prepare for the Future. Act in the Present.
                    David M
                    Basic Member
                    Posts: 11
                    Basic Member
                      Red, thanks for your insights.

                      I checked all of those screens and I don't have access to them. I sent out an email to see if I can get them from our Lawson guy.

                      As far as the RNGDBDUMP I have no clue what this is.

                      I do know that we use CrystalReports for some of our custom reports. I think I need to map out exactly what I need and then contact my Lawson expert to creat this special report.
                      Terry Wier
                      Basic Member
                      Posts: 13
                      Basic Member
                        David,

                        First, be advised Dashboard Gear is a Lawson Partner who has developed a reporting data warehouse for Lawson. I have about five minutes into creating your report using Excel pivot tables and I think it is close to what you want. If you would like to send me your email address I will reply with the report I have created.

                        Terry Wier
                        Dashboard Gear
                        terry.wier@dashboardgear.com
                        David M
                        Basic Member
                        Posts: 11
                        Basic Member
                          Posted By Terry Wier on 11/09/2012 01:25 PM
                          David,

                          First, be advised Dashboard Gear is a Lawson Partner who has developed a reporting data warehouse for Lawson. I have about five minutes into creating your report using Excel pivot tables and I think it is close to what you want. If you would like to send me your email address I will reply with the report I have created.

                          Terry Wier
                          Dashboard Gear
                          terry.wier@dashboardgear.com


                          Terry, I sent you an email with my personal Yahoo email. I would love to see what you came up with. Thanks!
                          You are not authorized to post a reply.