Please guyz want to design a simple inventory that can keep records of sales and also print invoice and receipt.

So my question here is which of the ms package will be suitable between Excel and Access. Thankz

Use Excel

For me I will go with Access though it requires some extra "technical know how"

Kehcsc:
For me I will go with Access though it requires some extra "technical know how"

Yess and that's my problem

Yaronkirki:
Please guyz want to design a simple inventory that can keep records of sales and also print invoice and receipt.

So my question here is which of the ms package will be suitable between Excel and Access. Thankz

If it’s really going to be simple, Excel can handle it perfectly.

randomShek:
If it’s really going to be simple, Excel can handle it perfectly.

Ok but how can I put the link for printing

Yaronkirki:


Ok but how can I put the link for printing

You can setup the page to print out only the area of invoice and receipt. Turning off gridlines of those sheets will also help it look professional when printed out.

You can send a pm if you want me to help.

Yaronkirki:

Yess and that's my problem

In that case go with Excel....

randomShek:
You can setup the page to print out only the area of invoice and receipt. Turning off gridlines of those sheets will also help it look professional when printed out.

You can send a pm if you want me to help.

Ok thankx

I had even wish to know how a sales data will look like. Can anyone please help with a template or screenshot?

randomShek:
You can setup the page to print out only the area of invoice and receipt. Turning off gridlines of those sheets will also help it look professional when printed out.

You can send a pm if you want me to help.

But I want each record from the invoice to be saved permanently

Yaronkirki:

But I want each record from the invoice to be saved permanently

I understand, this can be done with ease in Excel. You will save all the necessary records in one workbook for every sale you have and then whenever you want to create an invoice/ receipt for a particular date/ product, all you have to do is extract the required records.

The process can become tasking as your “database” grows larger so consider automation to make it easier to maintain.

Yaronkirki:
Please guyz want to design a simple inventory that can keep records of sales and also print invoice and receipt.

So my question here is which of the ms package will be suitable between Excel and Access. Thankz

Send me a WhatsApp message on 08104203308

randomShek:
I understand, this can be done with ease in Excel. You will save all the necessary records in one workbook for every sale you have and then whenever you want to create an invoice/ receipt for a particular date/ product, all you have to do is extract the required records.

The process can become tasking as your “database” grows larger so consider automation to make it easier to maintain.

Okk let me create the table First

YOU can use excel with a DASHBOARD (in the form of a reciept) that you can call a particular transaction and print.

Why don't you just install a small Sales Management System? There are a few robust ones out there that are completely free and can export data into excel for analysis.

Was this ever resolved?

Yaronkirki:
Please guyz want to design a simple inventory that can keep records of sales and also print invoice and receipt.

So my question here is which of the ms package will be suitable between Excel and Access. Thankz

@op consider this

airsaylongcom:
Why don't you just install a small Sales Management System? There are a few robust ones out there that are completely free and can export data into excel for analysis.