Prev
Next
Forums Lawson Add-Ins for Microsoft Office

Addins Query no pulling all data

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


JonA











Veteran Member



Posts: 1162




Veteran Member



5/4/2011 7:33 PM
    Trying to query POVAGRMTLN and I'm not getting all the lines for a particular agreement. Even when I specify the VEN-AGRMT-REF in the index the query gives me only 227 lines when I can see 371 in PO25.6.  Any ideas why this is happening?
    Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health


    John Henley











    Senior Member



    Posts: 3348




    Senior Member



    5/4/2011 8:21 PM
      What version of LSF and what version of the addins?

      Are the ones not being displayed at the end (i.e. are you seeing first 227?)

      Using the addins you can see the underlying DME/Data query. Try running it from the browser with &OUT=CSV and see if it returns all records. =
      Thanks for using the LawsonGuru.com forums!
      John


      Ragu Raghavan











      Veteran Member



      Posts: 468




      Veteran Member



      5/5/2011 12:56 AM
        Which Index are you using ? Maybe, you have unintentionally selected an index that has a condition associated with it .


        JonA











        Veteran Member



        Posts: 1162




        Veteran Member



        5/5/2011 11:17 AM
          Well this is embarrassing.  It works fine.  The query wizard was pointed at our test box which hasn't been updated since February. Thanks for your suggestions anyway!
          Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
          You are not authorized to post a reply.