Consolidation

[reno]

have perpetual inventory of one item in 10 stores. inventory is done daily.
there are 4 headings Beg, Ord, Sls and End. can't figure out to use the
consolidation function. Using Ofc2007.

i have used lookup tables but that getting cumbersome.
thx