@@shahabislam4912 Sir I m working in Labratory. We purchase from suplier in bulk qty. Example.. We buy kit 5 boxes. one box has 40 kit.. Now we use only one kit whenever its needed. How to maintain such stock box as well as loose item.....???
Sir aik video banaen jese daily sale report me jo credit pe laity hen or phr paid karty hen unke alag naam se entry hoti hai ab unko aik sheet me tranfer karna hai jo credit and paid credit amount krty hen wo alag sheet me show hoon wo naam sab daily sale report se utha k dusri sheet me ane chahiyen jo credit pe saman laity hen or jo credit paid krty hen thnk you
Sir what if i want to maintain Brand wise Model wise stock details. For Example in Apple Brand i want to maintain model wise i14 i 15 . Then what formula should i apply in sales
what if there are 2 entries of same product in purchase item list ? lets say, there are two entries of Samsung with qty "15 "+"25" each and in stock list also 2 entries of Samsung . than sumif condition shows duplicate data in the list, so my question is how to stop replicate data in table
डियर सर इसमें जो आपने वेलीडेशन सीट बनाई है वो केवल लिमिटिड आईटम के लिए हैं यदि हमारे पास हर डेट में अलग अलग आइटम aa rha है तो फिर हर डेट में वैलीडेशन सीट चेंज करनी पड़ेगी यदि आपके पास कोई formula ho to batao मुझको up to 2000 item ki inventory maintain करनी है
If purchase is in box.. and sale in pices ... Then?? Like purchase 1 box having 50 pices.. and sale only 30 pices.. now closing stock is only 20 pcs not in box.. so how to show that..?
apne jo sheet 1 ki list define ki h usko sheet second me data wale option m jakar f3 press karne par nhi aa raha he. isliye please batyiye sheet 1 m list wale option par konsi key press karna he
AOA sir thanks for sharing with us such a piece of useful information, If over 200 products and over 150 invoices of sales and purchases and also packed and its losing quantity such as kg pcs etc. Now the requirement is that opening stock of the 1st date of the month and purchases, sales of whole month and closing transfer to next month as an opening. Thanks for that kind if it is possible. Muhammad akram ansari
Sir Require the details to maintain stock in FiFO system rate wise, Means X product purchased at 100 and sold at 110, again same product purchased at 105 and now sold at 111 So how to maintain as we may have closing stock of 100 and 105 also.....
Sir mashallha zabardast
Badhiyan
Alhamdulillah...Thanks....
Assalamoalykum, thank you so much for sharing very useful information it's really very helpful. Allah bless you 🤲
So nice of you
@@shahabislam4912 Sir I m working in Labratory. We purchase from suplier in bulk qty. Example.. We buy kit 5 boxes. one box has 40 kit.. Now we use only one kit whenever its needed. How to maintain such stock box as well as loose item.....???
Sir aik video banaen jese daily sale report me jo credit pe laity hen or phr paid karty hen unke alag naam se entry hoti hai ab unko aik sheet me tranfer karna hai jo credit and paid credit amount krty hen wo alag sheet me show hoon wo naam sab daily sale report se utha k dusri sheet me ane chahiyen jo credit pe saman laity hen or jo credit paid krty hen thnk you
thanks for sharing sir
Most welcome
Bhai rate input ka b btadoo or current quantity or current rate pa kese stock banega amount k sath
Sir pls make vido on trolly no tracking or box no. Tracking
Shukriya
GREAT VIDEO
Thanks!
❤good job
thanks sir
Hello how will you capture the changes in price for one product ? For example if you receive the same item with more than three different prices??
Appreciate.. kindly explain about sales forcasting and Stock on hand & show the Excel format report.. regards
Sir what if i want to maintain Brand wise Model wise stock details. For Example in Apple Brand i want to maintain model wise i14 i 15 . Then what formula should i apply in sales
Wow that's great video. God bless you with his love that makes every day a joy to live. Go ahead.
what if there are 2 entries of same product in purchase item list ? lets say, there are two entries of Samsung with qty "15 "+"25" each and in stock list also 2 entries of Samsung . than sumif condition shows duplicate data in the list, so my question is how to stop replicate data in table
डियर सर इसमें जो आपने वेलीडेशन सीट बनाई है वो केवल लिमिटिड आईटम के लिए हैं यदि हमारे पास हर डेट में अलग अलग आइटम aa rha है तो फिर हर डेट में वैलीडेशन सीट चेंज करनी पड़ेगी यदि आपके पास कोई formula ho to batao मुझको up to 2000 item ki inventory maintain करनी है
Jese Karachi stocks exchange ki daily sheet maintain karni ho
If purchase is in box.. and sale in pices ... Then?? Like purchase 1 box having 50 pices.. and sale only 30 pices.. now closing stock is only 20 pcs not in box.. so how to show that..?
If different different date ka purchase ho to kaise kare
apne jo sheet 1 ki list define ki h usko sheet second me data wale option m jakar f3 press karne par nhi aa raha he. isliye please batyiye sheet 1 m list wale option par konsi key press karna he
mera bhi nhi ho rha
AOA sir thanks for sharing with us such a piece of useful information, If over 200 products and over 150 invoices of sales and purchases and also packed and its losing quantity such as kg pcs etc. Now the requirement is that opening stock of the 1st date of the month and purchases, sales of whole month and closing transfer to next month as an opening. Thanks for that kind if it is possible. Muhammad akram ansari
Sir
Require the details to maintain stock in FiFO system rate wise,
Means
X product purchased at 100 and sold at 110, again same product purchased at 105 and now sold at 111
So how to maintain as we may have closing stock of 100 and 105 also.....
Please do a video on this. I also need guidance FIFO model.
Drop down me agar 200 item ho ya or jyada ho to find kaise karen
ua-cam.com/video/lM0siYZcuyM/v-deo.html
Sir f3 press karne par kuch bhi nahi ho raha
f4 cannot work, when i try to freeze .:(
सर, कृपया इस एक्सेल शिट का डाउनलोड लिंक दिजीए प्लिज
getinto pc site se Download karlen.
bhai sahi se dikhao na
validation jake f3 press karu karna kya he
Jai shree Ram 🙏🏻🙏🏻🚩🚩
Tamil transalation
dikhana he tho prper dikhao
Pruchase 😂
Kya gandi sanson ki awazen a rahi bhai kuch khyal karo
bakwas
Phli sabd bole ke dimag kharb kar diya har jagh dharm 🤮🐷
To tu nikal tujhe kisne bola yaha jhuk marane k liye... Bhadwe