Dear,
Myself is looking after stores since last fiver years. I used to get done the physical verification of stores every year but I doubt that I am not adopting the correct method.
Therefore, request to please send me the correct method in details of stores physical verfication on my email
regards,
S.P. Singh
From India, Lucknow
Myself is looking after stores since last fiver years. I used to get done the physical verification of stores every year but I doubt that I am not adopting the correct method.
Therefore, request to please send me the correct method in details of stores physical verfication on my email
regards,
S.P. Singh
From India, Lucknow
Hello S.P. SINGH,
Physical Verification on Stores Every year - Year end 31st March.
The following Steps to do the Physical Verification.
1. First stores holiday on 31st March.
2. No Purchase and Issues on that Day.
3. 5 to 6 members takes the physical stock avaliability of ur stock.
4. Count the Stock manually Write down the White paper partno and physical qty
5.on 31st March Run the System stock and stores in Excel Sheet.
6. System Stock Format in Excel Sheet - Partno, Partname , Sysqty
7. Enter data entry physical stock in excel sheet - Partno and Physical Qty
8. Last Compare Two excel sheet - Physical stock vs System stock with help of Vlookup excel formula . Then we take excess and shortage stockage.
All the best.
If there is any clarrification write to me mail id:aruljd2009@gmail.com.
Ur's Friednly
Arul
From India, New Delhi
Physical Verification on Stores Every year - Year end 31st March.
The following Steps to do the Physical Verification.
1. First stores holiday on 31st March.
2. No Purchase and Issues on that Day.
3. 5 to 6 members takes the physical stock avaliability of ur stock.
4. Count the Stock manually Write down the White paper partno and physical qty
5.on 31st March Run the System stock and stores in Excel Sheet.
6. System Stock Format in Excel Sheet - Partno, Partname , Sysqty
7. Enter data entry physical stock in excel sheet - Partno and Physical Qty
8. Last Compare Two excel sheet - Physical stock vs System stock with help of Vlookup excel formula . Then we take excess and shortage stockage.
All the best.
If there is any clarrification write to me mail id:aruljd2009@gmail.com.
Ur's Friednly
Arul
From India, New Delhi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.