alayash03
Member
- Local time
- Today, 16:43
- Joined
- Oct 5, 2022
- Messages
- 45
Hello,
I would like to run query by group Order ID.
You see above Order ID =4, Order Details ID : 1 & 2. And I don't want between Order Details ID LINE
How can display this in the Query and report page ?
I would like to run query by group Order ID.
Order ID | Order Details ID | Invoice Code | Product ID | Cost Price | Quantity | Sales Price | Discount Prct | Discount Amount | VAT Prct | VAT Amount | Total Amount |
---|---|---|---|---|---|---|---|---|---|---|---|
4 | 1 | INV1 | Honor 8x | $10.00 | 1 | $15.00 | 0.00% | $0.00 | 0.00% | $0.00 | £15.00 |
| 2 | INV2 | Honor 9x | $15.00 | 1 | $20.00 | 0.00% | $0.00 | 0.00% | $0.00 | £20.00 |
2 | £35.00 | ||||||||||
Order ID | Order Details ID | Invoice Code | Product ID | Cost Price | Quantity | Sales Price | Discount Prct | Discount Amount | VAT Prct | VAT Amount | Total Amount |
---|---|---|---|---|---|---|---|---|---|---|---|
4 | 1 2 | INV1 INV2 | Honor 8x Honor 9x | $10.00 $15.00 | 1 1 | $15.00 $20.00 | 0.00% 0.00% | $0.00 $0.00 | 0.00% 0.00% | $0.00 $0.00 | £15.00 £20.00 |
35 | 2 | 0 | 0 | 0 | 0 | £35.00 |