I have two tables 1. Bin content - columns are location, item no., zone code, bin type , qty eg Ind , 121, Put - pick (shipping, damage etc) , put-pick , 10 .
2 warehouse entry - columns are location, item no., zone code, bin type , qty , lot no.
eg. Like above with lot no. But not mandatory means null value also there .and table content all plus minus ..adjust qty. So I want lot wise item wise ..location wise...qty which equal to qty of bin
Please suggest means sum of warehouse entry is equal to bin but lot wise and lot not equal to blank.