Quanty on hand on date with lot number

I would like to extract the quantity on hand on a date with the lot number. I uses the formula

@NF($D6,"Net Change","Date Filter",NP("DateFilter",,$G$3))

Being D6 is the NL("Rows","Item") and G3 is the date.

But I could not extract the lot number that contain the balance. Any solution?


Please sign in to leave a comment.