Sales Order And Create Invoices

[Shamina]

I want to Create a Database For Sales Order And Create Invoices.
Then I take a sample from this "access-templates.com" then this database have to edit as I want

I facing a problem creating ORDER to drop list or Combo box.
I would like order Details section If i click drop down list then show the product name and automatic insert .......................... ListPrice And Balance STOCKs pc's.
And If I enter the OVER quantity then message me. "Your product is over right now, You have balance "10" Or "Any Quantity " ".

Second Question is"
How can I control STOCK products.

If anyone wants to reviews my database I will upload it....

 

[mike60smart]

Yes upload the database

 

[Shamina]

Thanks.... mike60
problem
1. ORDER Subform
2. STOCK

 

[Shamina]

I would like to explain some of our business.
* most of the products come from Bangladesh, India, and China. and little product Items locally in Saudi Arabia.
* Some products Customer have to pay shipping cost, Some products free delivery customer does not like to pay.
* Sometimes customers returning some products. So need record
* Our all payment is Credit Card Or Bank Transfer, Without "DOOR to DOOR" delivery.
* Some products we send to couriers. And Courier delivers DOOR to DOOR and customer will pay product price to Courier. and We take to Courier Weekly.
* Recently we starting this business and We have 6 Employees right now...

if further, you have any questions please talk me.

 

[mike60smart]

Your database needs a lot of work.

Take a look at the attached example of how to record Inventory.

 

[Shamina]

Thanks Mike60smart. It's good. but, I have here two tables One for Purchase and Product...
there is doubt...

 

[Shamina]

@The_Doc_Man I can't comment on my first thread. I don't know why?

 

[Uncle Gizmo]

Have you seen the northwind sample database provided by Microsoft? It demonstrates an invoicing solution.

It is a sample database, not designed for use in production. It does have a few problems which I highlight in my blog, and I also show several solutions of varying complexity.

See here:-

Northwind Problem and Solution – Nifty Access

www.niftyaccess.com

 

[mike60smart]

Thanks Mike60smart. It's good. but, I have here two tables One for Purchase and Product...
there is doubt...

I am off to Bed now

 

[Shamina]

How can I get my product list with Unit Price.

 

[Uncle Gizmo]

How can I get my product list with Unit Price.

The Northwind sample dB I mentioned has this functionality. Have a look!

 

[Uncle Gizmo]

It appears that Shamina and smtazulislam are one in the same person.​

https://www.access-programmers.co.uk/forums/search/606422/

https://www.access-programmers.co.uk/forums/search/606424/

 

[mike60smart]

Take a look at the attached.

I used a query to obtain the list of Product Prices

Look at the after update of the selection of a product .