Invoice Management System V1.0 | Step by Step tutorial

Hello

please ask how must cost of this excel vba based software for leave management

Hello, I am facing difficulty in pasting the data from Data sheet to Sales sheet. only for the invoice number? Can you suggest?

Awaiting for next version which include customer information sir.

Seriously Most Useful Videos Sir❤❤❤

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

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

How to add nd calculate GST .... In this invoice

I will highly appreciate that sir

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

can u merge the invoice and inventory together so when we bill it will deduct the stock from ur inventroy project

great iam very thankfull to u for giving us such good projects

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

hoping for next video presetantion, in module discussing functions, should be step how to start, not in a shortcut way, thanks

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

Invoice update button require please guide the same

Is me id not search F-1. Only number

Dear sir
Thanks regarding this वीडियो
Search invoice को update करना है और alphabet के लिए string है to numeric के लिए क्या word लिखे, please बताएं

धन्यवाद 🙏

الله ينور ياهندسة
استاذنك ياهندسة كنت محتاج كود vba لمنع تكرار صف باكمله في الليست بوكس

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

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.

Sir plz add customer name gst no address of customer and itemwise gst calculation like 5,12,18 percent and also calculate igst also 🙏🙏🙏

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

Great work

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.

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
but gst!

Is it possible to put an item which is promotional package that will auto populate the content of the promo package?

Your work and knowledge is excellent 👍

Customer and address ?

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

Sir plz add customer name and GST tax in this form

Wht abt party name?

Good 👍

my god thought i was the only one

Hi . Piece of art job. But my items have 2 perimeters , kgs and pcs. How can i integrate that

So sorry, to much mistakes in your Tools. Listbox (settings) konflikt.

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! ❤️

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
How to extract Tabular data in excel by vba, please help sir

Thanks for creating PK! Hope one day I wish to learn how to create dashboard comparing two supplier pricing

Very very good

ممنون

Sir I want to learn VBA where to learn sir can u guide plz

Hello. Thank you very much for your effort.
Can you make a Dashboard for the S&OP process (Sales and Operations Process).
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.

An excellent tutorial. Well done.

Thanks, PK for creating and uploading yet another great nugget of Excel

Sir, windows 11, textbox date is computer date plz show the code

NICE WORK
CONGRATULATIONS.