Prev
Next
Forums Lawson Add-Ins for Microsoft Office

AR addins wont return all the rows

Sort:
You are not authorized to post a reply.
Author
Messages


David Hersh











New Member



Posts: 1




New Member



3/17/2010 4:50 PM

    Hello,

    I'm using the Excel Addins to query a form (AR90.1) and while I do receive data, I only return 11 rows.  I know the data query should return a few hundred rows.  I've set the number of rows limit to 9999 and still not difference.  Any ideas?



    Brad Schauer











    Veteran Member



    Posts: 76




    Veteran Member



    3/17/2010 5:43 PM
      What is your "data retrieval timout preference" set to? The green and yellow arrow button at the top of the screen, second button from the right.

      Brad


      JonA











      Veteran Member



      Posts: 1162




      Veteran Member



      2/2/2011 5:16 PM
        If the query times out there would be no data return. This is an older post so I'm guessing that you figured out the problem. But I would take a look at the criteria tab and make sure the selections are correct. One mistake I've made in the past is use the same >= for two criteria so I might say PURCHORDER-PO-DATE >= 20110101 AND PURHCORDER-PO-DATE >= 20110131 which would return PO data for Jan 31st up to today when I really wanted just Jan data. Just seems when I'm not getting the data I expect more times than not it comes down to the criteria selected.
        Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
        You are not authorized to post a reply.