Required excel formula for physical scanned stock vs system stock in excel
Budget: ₹600 – ₹750 INR
physical scanned stock vs system stock in excel
first formula split qty w.r.t barcode
Sheet 1 contain stock on hand
Sheet 2 will be scanned barcode
Sheet 3 contains result of match sheet 1 with 2
Show plus ,minus,extra or barcode not belong to store.
first formula split qty w.r.t barcode
Sheet 1 contain stock on hand
Sheet 2 will be scanned barcode
Sheet 3 contains result of match sheet 1 with 2
Show plus ,minus,extra or barcode not belong to store.