Creating Order Form (1 Viewer)

Rania01

Member
Local time
Today, 09:21
Joined
Oct 9, 2021
Messages
34
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
 

Attachments

  • Order en invoice.zip
    110.2 KB · Views: 269

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 15:21
Joined
May 7, 2009
Messages
16,125
is this what you want?
 

Attachments

  • Order en invoice.zip
    195.4 KB · Views: 197

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 08:21
Joined
Jul 9, 2003
Messages
14,462
see all the orders I made.

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


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

Member
Local time
Today, 09:21
Joined
Oct 9, 2021
Messages
34
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,


 

Attachments

  • Photos ws1.jpg
    Photos ws1.jpg
    72.6 KB · Views: 222

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 15:21
Joined
May 7, 2009
Messages
16,125
what is the negative (-) amount on the invoice?
see query QFactuur also see query Q_verkooporder_regel_total.
 

Attachments

  • Order en invoice.zip
    185.7 KB · Views: 267

Rania01

Member
Local time
Today, 09:21
Joined
Oct 9, 2021
Messages
34
(-) 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

..forever waiting... waiting for jellybean!
Local time
Today, 15:21
Joined
May 7, 2009
Messages
16,125
so Total invoice amount is:

Total invoice amount - total return amount?
 

Rania01

Member
Local time
Today, 09:21
Joined
Oct 9, 2021
Messages
34
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

Nifty Access Guy
Staff member
Local time
Today, 08:21
Joined
Jul 9, 2003
Messages
14,462
I reckon you'd be better off putting the "credit notes" in a separate table...
 

Users who are viewing this thread

Top Bottom