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

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.

Do you know about Ctrl-Shift-O ? That may help when identifying fields from Lawson screens.

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.

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.

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.

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.

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

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

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.

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

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!