Creating Order Form (1 Viewer)

Rania01

New member
Local time
Today, 23:56
Joined
Oct 9, 2021
Messages
23
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: 66

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:56
Joined
May 7, 2009
Messages
14,555
is this what you want?
 

Attachments

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

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 22:56
Joined
Jul 9, 2003
Messages
13,544
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

New member
Local time
Today, 23:56
Joined
Oct 9, 2021
Messages
23
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: 50

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:56
Joined
May 7, 2009
Messages
14,555
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: 69

Rania01

New member
Local time
Today, 23:56
Joined
Oct 9, 2021
Messages
23
(-) 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
Tomorrow, 06:56
Joined
May 7, 2009
Messages
14,555
so Total invoice amount is:

Total invoice amount - total return amount?
 

Rania01

New member
Local time
Today, 23:56
Joined
Oct 9, 2021
Messages
23
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, 22:56
Joined
Jul 9, 2003
Messages
13,544
I reckon you'd be better off putting the "credit notes" in a separate table...
 

Users who are viewing this thread

Top Bottom