Hello, newbie question here.
I have an inventory report where I want to compare the sum of inventory counted for each material with a single record from book value to display an overage or shortage
There are two tables, LQUA and M52 LQUA contains the material, storage bin and total stock shown above. Book value comes from a single record for each material in the MB52 table. I need the empty red outline to show the sum of total stock (874) minus the book value (1047) For this material the answer would be -173 representing a shortage of 173 items.
Thanks in advance for the assistance.