Creating Order Form (1 Viewer)

[Rania01]

Dear All,

I hope you can help me to make a form so that I can see all the orders I made.
If I click the order number ( hyperlink) to the form Creat order en invoice will be opened and then I can fix the order en save again


I made all these orders with the form Name Creat order en invoice


Thank you

Rania

 

[arnelgp]

is this what you want?

 

[Uncle Gizmo]

see all the orders I made.

The Northwind database, which I have blogged about on my website here:-

Northwind Problem and Solution - Nifty Access

Northwind Problem and Solution If you use the Northwind database as a basis for your business application then there is a problem that you should be aware of. The sample Northwind database supplied by Microsoft provides some excellent insights in how you should program an MS Access application...

www.niftyaccess.com

has a nice invoicing system which you might wish to examine. It does have a couple of problems. It's a demo from provided by Microsoft , and not really intended for production use. I explain the issues it has and how to solve them in my blog.

 

[Rania01]

Dear arnelgp,

Yes thats what i want!

could you please check on the Query =Qfactuur

I dont see the amount from the invoice, what am i doing wrong here? see photos

Greetings,

​

 

[Gasman]

Crossposted https://www.accessforums.net/showthread.php?t=84539

 

[arnelgp]

what is the negative (-) amount on the invoice?
see query QFactuur also see query Q_verkooporder_regel_total.

 

[Rania01]

(-) amount is for, if customer return the product !
if you have advice for this please lets me know?

Thanks in advance for your help

 

[arnelgp]

so Total invoice amount is:

Total invoice amount - total return amount?

 

[Rania01]

When a costumer brings back 1 item, we make a credit invoice for the costumer.
Question:
Do you know how to add on Report :
1. If total invoice with (-) example -1000 must be credit note en if invoice total (+) example 1000 is invoice ( on Head of the report)
2. it's possible the invoice number starting with RA2021+001 example first number invoice wil be RA2021001

Thank you in advance

Rania

 

[Uncle Gizmo]

I reckon you'd be better off putting the "credit notes" in a separate table...