0

Multiple Filters

I am attempting to extract inventory case quantities on hand from a non-Nav database using a universal connector using the following formula:

=NL("Sum","Inventory Location File","ON_HAND_IN_UM","ITEM_NUMBER",C5,"LOCATION",D5)

The item number (sku) is one filter; the inventory location code is the second filter. I am successful in getting the correct data when using just one filter, either the item number or the location code by themselves, but am getting 0 when using both filter values when I am 100% certain data exists matching both filter criteria.

Thoughts?

0 comments

Please sign in to leave a comment.