# Help with reservation/Preorder workflow

**URL:** <https://forum.sambapos.com/t/help-with-reservation-preorder-workflow/7663>\
**Category:** V5 Question\
**Created:** [October 16, 2015, 1:39pm UTC](https://forum.sambapos.com/t/help-with-reservation-preorder-workflow/7663 "2015-10-16T13:39:05Z")\
**Posts on this page:** 1\
**Showing post:** 39

<div class="post-metadata">

**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\
**Post date:** [October 21, 2015, 11:53am UTC](https://forum.sambapos.com/t/help-with-reservation-preorder-workflow/7663/39 "2015-10-21T11:53:48Z")

</div>

silentbob report tags are useful to create reports without dealing with SQL but you are not limited to report tags. Instead of trying to match it to what reporting tag offers you can use SQL to prepare your reports as exactly you want. I’ve prepared an example about how to filter payments by payment date instead of ticket date.

Create a new script. You can access that script inside reports via **@@Payments** handler.

 ![](https://forum.sambapos.com/uploads/default/original/2X/d/d3e23965aeb3fb2c3c0bfd80736b550401b8fda0.png)

This is the SQL Script.

```auto
Select Payments.Name as PaymentName, 
   Payments.Date as PaymentDate, 
   Tickets.Date as TicketDate, 
   Tickets.TicketNumber as TicketNumer, 
   PaymentTypes.Name as PaymentTypeName,
   Amount,
   TenderedAmount,
   Users.Name as UserName from Payments
inner join Tickets on Payments.TicketId = Tickets.Id
inner join PaymentTypes on Payments.PaymentTypeId = PaymentTypes.Id
inner join Users on Payments.UserId = Users.Id
where Payments.Date > '{Start}' and Payments.Date < '{End}'  

```

Create a new report as follows or you can include it as a report section in WPR.

 ![](https://forum.sambapos.com/uploads/default/original/2X/0/014ec825789a0edeff1b002355387c93845d364a.png)

This is report template.

```auto
[Payments:1,1,1,1,1,1,1,1]
>Payment|Date|Ticket Date|Ticket Number|Type|Amount|Tendered Amount|User Name
@@Payments

```

What I’ve tried to explain to you is how you want SambaPOS to operate may lead to issues. If you know exactly what you need you can implement your own way.

---

_[View the full topic](https://forum.sambapos.com/t/help-with-reservation-preorder-workflow/7663)._