1. Wholesales Pick and Pack List vs. D/O Entry
Compare the pick and pack list prepared by Buyer against the D/O data list pack and scanned by Warehouse.
i. Check the total quantity, D/O quantity should match the pick and pack list.
ii. In the Excel file, run a Duplicate Finder function to check for any duplicate items (check for item no, colour and size). There should be no item being duplicated for each file.
iii. Run a match function of both files to make sure both has the same items. (Check for item colour and size).
iv. Run a Vlookup function to ensure both files are having the same item (colour & size) and the same item and total quantity