I am working on ware house. We have different code for every material which was on system. Every month I need to take physical stock. I need to compare the system stock and physical stock. In that time i am facing a problem. So can you guide me for this. In both sheet we have 2 column. One is material code and and another is QTY.
We have a different material code for each material. This was download data from 2 different system. I need to compare both system QTY. We can not download the the material number serially. So it will be hard to compare 1 by 1. If by the formula we can compare it will be great.
I want to compare the QTY from the 2 sheet.
https://www.sendspace.com/file/bclq53 Here i had upload the sample excel file. I want compare the QTY from LCS to SAP if there is different in QTY (+ or -) i need to find out this.