0

Union Formula

Hi, 

I would like to understand what is going wrong with my union formula. I would like to pull all items from the item table that have quantity on hand and to link it to the sales lines and match it out against the sales orders. 

Below is the formula: 

`NL("Rows",NP("Union",NL("Filter","Item","Quantity on Hand","Link=","Sales Line","No.","=No.","Posting Date","$C$2,"Document No.","*","Document Type","Order","Type","Item"),NL("Filter","Item","Link=","Item Ledger Entry","Item No.","=No.","Entry Type","Sales","Posting Date","$C$2")

 

Thanks!

1 comment

Please sign in to leave a comment.