# More Documentation for Account Receipt & Statements

**URL:** <https://forum.sambapos.com/t/more-documentation-for-account-receipt-statements/7918>\
**Category:** V5 Question\
**Created:** [November 1, 2015, 6:46am UTC](https://forum.sambapos.com/t/more-documentation-for-account-receipt-statements/7918 "2015-11-01T06:46:37Z")\
**Posts on this page:** 1\
**Showing post:** 8

<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:** [November 2, 2015, 10:32pm UTC](https://forum.sambapos.com/t/more-documentation-for-account-receipt-statements/7918/8 "2015-11-02T22:32:00Z")

</div>

Start from here.

[http://sambapos.com/wiki/doku.php/creating\_custom\_reports\_with\_sql](http://sambapos.com/wiki/doku.php/creating_custom_reports_with_sql)

Try this

```auto
 Select * from Tickets

```

Learn how SQL Where works to filter records.

> **[SQL WHERE Clause](https://www.w3schools.com/sql/sql_where.asp)**
>
> W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

```auto
Select * from Tickets where IsClosed = 0 

```

Learn how to use field names instead of \*

```auto
Select Id,TicketNumber from Tickets where IsClosed = 0 

```

Check how SQL Like keyword works to make partial searches.

> **[SQL LIKE Operator](https://www.w3schools.com/sql/sql_like.asp)**
>
> W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

Check how SQL Join works to create reports from two tables.

> **[SQL Joins](https://www.w3schools.com/sql/sql_join.asp)**
>
> W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

Check this topic for related discussions and samples.

> [@Help with reservation/Preorder workflow](http://forum.sambapos.com/t/help-with-reservation-preorder-workflow/7663):
>
> I have a system setup where people can pay money off an item and collect the item when paid in full. I followed the simple reservation example. I also created another ticket type for this. I thought I had this ready to go but noticed one problem today. The problem is if I reserve an item and the customer pays €20 off a €100 item everything works fine. If 3 days later they pay another €20 my work period report does not show it. It will show in the original work period. So my accounts are right bu…

---

_[View the full topic](https://forum.sambapos.com/t/more-documentation-for-account-receipt-statements/7918)._