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
@farhawayan8862 жыл бұрын
Assalamoalykum, thank you so much for sharing very useful information it's really very helpful. Allah bless you 🤲
@shahabislam49122 жыл бұрын
So nice of you
@siddharthjain9061 Жыл бұрын
@@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.....???
@orip-gb5xc Жыл бұрын
Alhamdulillah...Thanks....
@zeeshikz12902 жыл бұрын
Sir mashallha zabardast
@asimqureshi3625 Жыл бұрын
Bhai rate input ka b btadoo or current quantity or current rate pa kese stock banega amount k sath
@marmyint1813 Жыл бұрын
thanks for sharing sir
@shahabislam4912 Жыл бұрын
Most welcome
@bantikhan83802 жыл бұрын
Shukriya
@impressedvidosstudy81222 жыл бұрын
Sir pls make vido on trolly no tracking or box no. Tracking
@aashishgoel16097 ай бұрын
GREAT VIDEO
@shahabislam49127 ай бұрын
Thanks!
@Avinash-ku8wh4 ай бұрын
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
@Khaled.Perfect Жыл бұрын
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
@brunotvthebrunochannel Жыл бұрын
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??
@asimqureshi3625 Жыл бұрын
Jese Karachi stocks exchange ki daily sheet maintain karni ho
@QuatadahSalman2 ай бұрын
Drop down me agar 200 item ho ya or jyada ho to find kaise karen
@shahabislam4912Ай бұрын
kzbin.info/www/bejne/on6TpJyPj8ior68
@GulpshaPraween Жыл бұрын
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..?
@asifahmed443110 ай бұрын
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
@aechissarАй бұрын
mera bhi nhi ho rha
@fabcoglobalmarketing6881 Жыл бұрын
If different different date ka purchase ho to kaise kare
@TheSainath1979 Жыл бұрын
सर, कृपया इस एक्सेल शिट का डाउनलोड लिंक दिजीए प्लिज
@shahabislam4912 Жыл бұрын
getinto pc site se Download karlen.
@Arunsharma-rr8kt Жыл бұрын
डियर सर इसमें जो आपने वेलीडेशन सीट बनाई है वो केवल लिमिटिड आईटम के लिए हैं यदि हमारे पास हर डेट में अलग अलग आइटम aa rha है तो फिर हर डेट में वैलीडेशन सीट चेंज करनी पड़ेगी यदि आपके पास कोई formula ho to batao मुझको up to 2000 item ki inventory maintain करनी है
@santalitrendingofficial7286 Жыл бұрын
thanks sir
@SHOEBTvpress2 жыл бұрын
Wow that's great video. God bless you with his love that makes every day a joy to live. Go ahead.
@muhammad.zeeshanansari8556 Жыл бұрын
❤good job
@dhanishmehta2 жыл бұрын
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.....
@musabshabbir8592 жыл бұрын
Please do a video on this. I also need guidance FIFO model.
@Sabstar0072 жыл бұрын
Appreciate.. kindly explain about sales forcasting and Stock on hand & show the Excel format report.. regards
@muhammadakram31322 жыл бұрын
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
@atulchauhan6257 Жыл бұрын
Sir f3 press karne par kuch bhi nahi ho raha
@MohammadHossain-cn2ml Жыл бұрын
f4 cannot work, when i try to freeze .:(
@zamrocks90962 жыл бұрын
bhai sahi se dikhao na validation jake f3 press karu karna kya he
@panditgamer1652 Жыл бұрын
Jai shree Ram 🙏🏻🙏🏻🚩🚩
@BOOMIKAISBOOMIKAIS10 ай бұрын
Tamil transalation
@zamrocks90962 жыл бұрын
dikhana he tho prper dikhao
@Dilbarkhan-k1p Жыл бұрын
Pruchase 😂
@aysha3024 ай бұрын
Kya gandi sanson ki awazen a rahi bhai kuch khyal karo
@zamrocks90962 жыл бұрын
bakwas
@abhishekchandravanshi5443 Жыл бұрын
Phli sabd bole ke dimag kharb kar diya har jagh dharm 🤮🐷
@AlimKhan-bl5sh Жыл бұрын
To tu nikal tujhe kisne bola yaha jhuk marane k liye... Bhadwe