@Kevin I tried doing that but its the same issue.

findSublistLineWithValue

will only return the line and value if the vendor credit or bill is on the sublist. the problem is its not returning because the sublist only holds 10000 .