create invoice form that look like Quickbooks invoices

[ez2012]

Hi everyone,

I would like to create an invoice form that look like QuickBooks invoice. What I mean by that is that I would like to be able to enter several rows of products with price and quantity and generate a report with the information and total price. I try the multiple line form but the problem im facing is my invoice number need to be entered at each row. is it possible or am i asking too much for access?


Thank you.

[moke123]

I try the multiple line form but the problem im facing is my invoice number need to be entered at each row. is it possible or am i asking too much for access?

Not sure I get your question, whether you want the Inv.# to show on each line or only at the top line. If the latter, the is a hide duplicates property in reports.

[madpiet]

Should be a main and subform. InvoiceNo is in the header table and then the relationship makes it get carried to the related table.
Then you can show it in the subform.

[Micron]

I think you mean you want to create an invoice with Access that you can send/give to a client? Then you would use a form where you input the data into tables (that is just database 101 stuff). Then your report would be based on a query that retrieves the line items for the invoice. The report would be designed to have the QB look that you want. The report header would contain the invoice number so that it is just shown once, but your query would, of course, show the invoice number for each invoice line item. The line items would go into the report detail section. You would not put a control for the invoice number into the detail section of the report - just the header of the report. Don't know if you realize, but this is (probably) at least 4 tables: tblInvoice, tblInvLineItems, tblProduct (or services) and tblPrices. When you create an invoice, the current price becomes part of the invoice record. If you link back to the price table and the price changes, existing invoice pricing will reflect the changes and you don't want that.

[Welshgasman]

Perhaps have a look at the Northwind2 databases?

https://www.devhut.net/access-northw...ect-downloads/

[ez2012]

Thank you all. sorry for the confusion, but you guys helped me a lot. the northwind2 database is a great help i can take the idea and implant it on my database. I think it will work the best the order form is really good, and it is what I'm looking for. I just need to make it work on my data. Is there any advantage or disadvantage of calculating the Qty and unit price on the form vs calculating it on table?
northwind database use the following on the form page =[txtQuantity]*[txtUnitPrice] for total of 1 row
I create a calculated field on my table that call total that doing the same thing.
my question is what is the best way to do?

[Welshgasman]

Not an expert, but I would go with the way they did it. I do not know why they did it that way, but there would be a good reason.
I will ask one of the developers.

[Micron]

Is there any advantage or disadvantage of calculating the Qty and unit price on the form vs calculating it on table?

As a general rule, you do not store calculations. Your invoice line items table might have qty and price fields but the line total should be an expression in the unbound line total control. The reason is, if either qty or cost values change in the line item record, you would have to re-calculate the line total in your table and that is prone to failure.

[Welshgasman]

Wouldn't that occur in table calculations?
I have never used them, only just upgraded to a version that supports calculated fields (I think),