Thanks a lot!! Just struggling client analysis supplier provides two companies diff prices - by item levels what % difference between those two companies by categories or monthly when price changes etc… t
Weldone sir, ❤️ from Nigeria, I've been following your channel for many years now! But pls help do a complete video project on a complete inventory management system point of sales, that can print receipt, Show notification for product that is about to expire, manage all, invoices, records tracking, sales, purchases, backups e.t.c The problem, I don't know how to join all this short project you've been doing to become one. Thank you sir And also a complete school management system! ❤️
wonderful, great job I have tried to add features like profit column from the sales invoice but it gives me type mismatch error 13. but every other thing works fine can you help me on how to add this while saving the sales transaction to the sales table
Thank you Master.Great video I was used Concatenate function for 2 cell and I want use countif() in data verification .I want only one record for Concatenate cell .But not working .I was succesfully single cell but for double cell not working (with concatenate ) is it possiiable that? Could you make a short video for this Master thank you.
Excellent work sir, as already file has invoice generate....can you please help us by extending this file with purchase with supplier details, return and sales invoice with customer details as we'll. Appreciate for your knowledge sharing, support 🙏
My Invoice format has one merged cell so when I am trying to copy data from sales worksheet and paste special into Invoice format I am getting error. Any solution plz ? Rest is working perfectly.
Dear sir Thanks regarding this वीडियो Search invoice को update करना है और alphabet के लिए string है to numeric के लिए क्या word लिखे, please बताएं धन्यवाद 🙏
Dear please note that my experience with this and sort out two problems 1) if the product name be digits only then vlookup not return values. 2)the pdf generate with the same name so we can't save for consecutive invoice in pdf format. Jus
sir, how to get invoice number series starts from 1 for every fresh accounting year. because example when i save invoice number start with 1,2,3...etc in 2023 year.when ever start fresh invoice number with 1 in 2024 ..i think i will overwrite inv no.1 of 2024 with inv no.1 of 2023..is there any code do not merge invoice numbers ..plz do for that sir...thanks
Pk thank you for this video , I have tried this and adopt to other form but im having problem when im about to have a print preview the automated form is still on the screen.
सर सर आइटम सर्च करने के लिए हमेशा सर्चेबल ड्रॉप डाउन लिस्ट से आइटम सर्च करने की सुविधा होनी चाहिए ताकि हम बहुत सारे आइटम होने पर कीवर्ड से उस आइटम को सर्च कर सेलेक्ट कर सके
Invoice search is bad, if you have 1000 invoices and do not remember which one, you stuck. Invoice data could be saved not in the same file but in access. I have created many excel files which use same data base and if your excel file by some reason will be corupted you all the time have your data.
Hi, Is there a way i can contact you? i need to create a system for my business using excel. I am looking to hire excel expert. Please tell me?Thank you
God of excel and vba has come to provide the people with his great feast. Sir, I touch your feet and convey my thanks sir.
Thanks for your valuable feedback🙏
Everything you offer is so amazing. Greetings from Egypt
Thanks for your valuable feedback🙏
Your work and knowledge is excellent 👍
Thanks for your valuable feedback🙏
An excellent tutorial. Well done.
Many thanks!
Great job. Your videos and files has really helped to improve my productivity at work place. Always on point. Thank you and keep up the good work
Great to hear!
I will highly appreciate that sir
Seriously Most Useful Videos Sir❤❤❤
Thanks for your valuable feedback🙏
@@PKAnExcelExpert Can you make a Receipt Entry Management System and share it on UA-cam sir?
@@PKAnExcelExpert Waiting for your video...
Thanks, PK for creating and uploading yet another great nugget of Excel
Thanks
NICE WORK
CONGRATULATIONS.
Thanks
Great work
Thank you so much 😀
Hi sir good job but I have suggestion please add customer info box in the form and a button to save the invoice in image format.
Thanks
Sure, will try to incorporate in next version
Awaiting for next version which include customer information sir.
great iam very thankfull to u for giving us such good projects
Most welcome🙏
@@PKAnExcelExpert can u make inventory and invoice in 1sheet sir
Thanks for creating PK! Hope one day I wish to learn how to create dashboard comparing two supplier pricing
Will upload soon
Thanks a lot!! Just struggling client analysis supplier provides two companies diff prices - by item levels what % difference between those two companies by categories or monthly when price changes etc… t
Thanks for this amazing video.
Our pleasure!
Very very good
Thanks🙏
Very nice sir
Thanks
Good 👍
Thanks🙏
Weldone sir, ❤️ from Nigeria, I've been following your channel for many years now! But pls help do a complete video project on a complete inventory management system point of sales, that can print receipt, Show notification for product that is about to expire, manage all, invoices, records tracking, sales, purchases, backups e.t.c
The problem, I don't know how to join all this short project you've been doing to become one.
Thank you sir
And also a complete school management system! ❤️
Excellent.It would be great if the database is access. I hope you will use the microsoft access database in the next tutorial
I will try to incorporate in next version
can u merge the invoice and inventory together so when we bill it will deduct the stock from ur inventroy project
الله ينور ياهندسة
استاذنك ياهندسة كنت محتاج كود vba لمنع تكرار صف باكمله في الليست بوكس
wonderful, great job
I have tried to add features like profit column from the sales invoice but it gives me type mismatch error 13.
but every other thing works fine
can you help me on how to add this while saving the sales transaction to the sales table
Hello, I am facing difficulty in pasting the data from Data sheet to Sales sheet. only for the invoice number? Can you suggest?
Can u show how to create new format excel sheet from excel format we set? Ex: Sample formate invoice the can create new invoice in another sheet
Sir, please advise to Search in Combo box randomly with any word
Hi, great & awesome job man. Can u plz add customer/ client name as a drop down list. It will be veryhelpful . I will wait for ur video. Thanks
will try to add in next version.
Sir plz add customer name gst no address of customer and itemwise gst calculation like 5,12,18 percent and also calculate igst also 🙏🙏🙏
I will add these thing in the next version
Very good but the only code missing is MSG "Are you sure you want to delete" Also an Undo would be nice.
Thank you Master.Great video
I was used Concatenate function for 2 cell and I want use countif() in data verification .I want only one record for Concatenate cell .But not working .I was succesfully single cell but for double cell not working (with concatenate ) is it possiiable that?
Could you make a short video for this Master thank you.
Is it possible to put an item which is promotional package that will auto populate the content of the promo package?
hoping for next video presetantion, in module discussing functions, should be step how to start, not in a shortcut way, thanks
Excellent work sir, as already file has invoice generate....can you please help us by extending this file with purchase with supplier details, return and sales invoice with customer details as we'll. Appreciate for your knowledge sharing, support 🙏
I will try to incorporate in next version
@@PKAnExcelExpert Noted and Thanks sir
Tebrikler
Emeğinize sağlık.
Değerli geri bildiriminiz için teşekkürler
please ask how must cost of this excel vba based software for leave management
My Invoice format has one merged cell so when I am trying to copy data from sales worksheet and paste special into Invoice format I am getting error. Any solution plz ? Rest is working perfectly.
Invoice update button require please guide the same
ممنون
خیلی خوش آمدید
@@PKAnExcelExpert باعث خوشحالیه که فارسی خوب صحبت میکنید ... نسخه 2 رو کی منتشر میکنید؟
Dear sir
Thanks regarding this वीडियो
Search invoice को update करना है और alphabet के लिए string है to numeric के लिए क्या word लिखे, please बताएं
धन्यवाद 🙏
Hi . Piece of art job. But my items have 2 perimeters , kgs and pcs. How can i integrate that
We can add another drop-down list for Unit of Measurement. I will add this in next version
@@PKAnExcelExpert you are the best . Many thanks . When will your next version be out
Also required customer Name ( Bill to ) with Gst no of company, Delivery location (if any ) , discount on total button ,
Dear please note that my experience with this and sort out two problems
1) if the product name be digits only then vlookup not return values.
2)the pdf generate with the same name so we can't save for consecutive invoice in pdf format.
Jus
In item list it's showing only first letter match only
Can u help me with searchable drop down list so that I can narrow down my search
sir, how to get invoice number series starts from 1 for every fresh accounting year. because example when i save invoice number start with 1,2,3...etc in 2023 year.when ever start fresh invoice number with 1 in 2024 ..i think i will overwrite inv no.1 of 2024 with inv no.1 of 2023..is there any code do not merge invoice numbers ..plz do for that sir...thanks
Hello. Thank you very much for your effort.
Can you make a Dashboard for the S&OP process (Sales and Operations Process).
Thanks
Great suggestion! I will try to create a video on this topic.
Sir I want to learn VBA where to learn sir can u guide plz
Sir
How to extract Tabular data in excel by vba, please help sir
Wht abt party name?
Is me id not search F-1. Only number
Good work but mostly invoice now and days based on gst invoice, kindly make a video like gst invoice with supplier database.
I will add it in the next version
Pk thank you for this video , I have tried this and adopt to other form but im having problem when im about to have a print preview the automated form is still on the screen.
How to add nd calculate GST .... In this invoice
will try to add in next version
सर सर आइटम सर्च करने के लिए हमेशा सर्चेबल ड्रॉप डाउन लिस्ट से आइटम सर्च करने की सुविधा होनी चाहिए ताकि हम बहुत सारे आइटम होने पर कीवर्ड से उस आइटम को सर्च कर सेलेक्ट कर सके
Sir, windows 11, textbox date is computer date plz show the code
Sir plz add customer name and GST tax in this form
I will do it in next version
Your work is great
But unfortunately can't download
You can download it from below URL:
www.pk-anexcelexpert.com/invoice-management-system-v1-0/
@@PKAnExcelExpert
Excellent
but gst!
I will add in next version
Invoice search is bad, if you have 1000 invoices and do not remember which one, you stuck. Invoice data could be saved not in the same file but in access. I have created many excel files which use same data base and if your excel file by some reason will be corupted you all the time have your data.
Customer and address ?
will add in the next version.. coming soon
@@PKAnExcelExpert
Ok
my god thought i was the only one
Hello
So sorry, to much mistakes in your Tools. Listbox (settings) konflikt.
1
Thanks
Hi, Is there a way i can contact you? i need to create a system for my business using excel. I am looking to hire excel expert. Please tell me?Thank you