Addins Query no pulling all data

 3 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
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
Send Private Message
Posts: 3351
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 Send Private Message
Posts: 477
Veteran Member
Which Index are you using ? Maybe, you have unintentionally selected an index that has a condition associated with it .
JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
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