Add In Query

Can anyone advise how I can create an Add Ins Query that will pull ALL distribution lines on an invoice? I am pulling data from AP, my criteria is my company and batch. It is giving me the correct data, however only the first distribution line. Is there a way to get ALL distribution lines from an invoice ? Thank you

Find more posts tagged with

Infor Lawson Financials Group - Discussion

Accepted answers

All comments

unknown

Make sure your OTM box is increased by the number of lines that you think may be returned...default is 1 so you may want to change to 40 if you think that's the highest number lines to be returned on an invoice ... maximum is 999 which I would not recommend using since it will take some time to process.

unknown

OTM (One to many) in the add-ins query under the criteria tab

unknown

Thank you. I changed from 1 to 50 and still getting only the first line. I am on Lawson V10 if that makes a difference

0712131256598360.doc

unknown

Can you attach the query file here? (I can't remember if that's possible)

unknown

I figure it out - I had criteria to only pull specific cost centers (duh). It worked exactly as it should have

Copyright © 2025 Infor. All rights reserved.