Inventory Management System Part 5 - Creating Inventory Adjustment - Auto Last Cost and Auto Qty

This is the 5th video series of Inventory Management System.
In this video is showing how to create the Inventory Adjustment Table with the VLookup function for Description, Category and also use IF function to create the Time recording for Upload Date and Upload Time. Index, Match and Max function are used to create an auto Last Cost for the Receiving Table. SUMIF function is also used to get an auto Qty updating when items have been received, sold, and adjusted.
The purpose of creating this Inventory Adjustment table is to adjust the inventory when store use, damage, spoil, expire,... along with the time recording.
There are serveral parts of videos will be posted on YouTube and Facebook, so please stay with us.
Welcome any comment and Thanks for watching.

Inventory,Inventory Management,Excel Inventory,Inventory Control,Invoice,How to manage Inventory,How to do Inventory,Barcode,Scan Barcode,