# Need Help to Custom the report

**URL:** <https://forum.sambapos.com/t/need-help-to-custom-the-report/10053>\
**Category:** Version 4\
**Created:** [March 27, 2016, 4:29pm UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053 "2016-03-27T16:29:31Z")\
**Posts on this page:** 18\
**Page:** 3

<div class="post-metadata">

**Author:** ![JTRTech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jtrtech/32/21270_2.png) [@JTRTech](https://forum.sambapos.com/u/JTRTech)\
**Post date:** [April 11, 2016, 10:50pm UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053/41 "2016-04-11T22:50:52Z")

</div>

As o said a cash card split EXCLUDING this or tips is I believe near impossible unless you restrict tickets to only use one payment per ticket.

A total breakdown using sales values rather than payments would be posible but not for cash card split.

I might have missed something but if that’s the case you need to seek advise from someone else as I can only see how to achieve this accurately by using sales values rather than payments.

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [April 12, 2016, 1:19am UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053/42 "2016-04-12T01:19:31Z")

</div>

You could just use math and subtract the fee from each one using expressions.

---

<div class="post-metadata">

**Author:** ![JTRTech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jtrtech/32/21270_2.png) [@JTRTech](https://forum.sambapos.com/u/JTRTech)\
**Post date:** [April 12, 2016, 8:26am UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053/43 "2016-04-12T08:26:10Z")

</div>

> [@Jesse](#):
>
> You could just use math and subtract the fee from each one using expressions.

Care to demonstrate 🙂  
What are you going to report to acurately subtract cash tips or delivery payments for card?  
If a ticket only ever had one payment method I can kinda see a solution but cannot see how you can reliably report calculations paid by a specific payment type?

The total line is ok but he wants a cash card split for each ticket type excluding tip calculation and delivery charge calculation… Sorry if I’ve missed something.

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [April 12, 2016, 1:13pm UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053/44 "2016-04-12T13:13:55Z")

</div>

Well it looks like he is using percentages for his calculations. All you do is define what percentage was used then put some math to it.

---

<div class="post-metadata">

**Author:** ![JTRTech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jtrtech/32/21270_2.png) [@JTRTech](https://forum.sambapos.com/u/JTRTech)\
**Post date:** [April 12, 2016, 3:41pm UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053/45 "2016-04-12T15:41:00Z")

</div>

Fair enough if the parameters of the calculations are fixed and constant but personally wouldn’t like to ‘back calculate’ given the option of toggling calculations be it used or not, you wouldn’t be reporting the tips just taking 18% off the payment total.  
If that’s acceptable for his purpose they its no problem, what I was trying to make clear is it would be very difficult to directly report calculations by payment type.

---

<div class="post-metadata">

**Author:** ![Caps](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/c/48db29/32.png) [@Caps](https://forum.sambapos.com/u/Caps)\
**Post date:** [April 13, 2016, 4:31am UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053/46 "2016-04-13T04:31:27Z")

</div>

> [@JTRTech](#):
>
> d constant but personally woul

So it’s doesn’t have any solution for template format right!😭

---

<div class="post-metadata">

**Author:** ![JTRTech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jtrtech/32/21270_2.png) [@JTRTech](https://forum.sambapos.com/u/JTRTech)\
**Post date:** [April 13, 2016, 4:37am UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053/47 "2016-04-13T04:37:45Z")

</div>

Is your tip/gratuity fixed or optional?

---

<div class="post-metadata">

**Author:** ![Caps](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/c/48db29/32.png) [@Caps](https://forum.sambapos.com/u/Caps)\
**Post date:** [April 13, 2016, 4:48am UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053/48 "2016-04-13T04:48:53Z")

</div>

1. Tips issue (Dine in, Pickup)==\> Nope, The tip/gratuity is not fixed. it depend on customer payment. BTW For this issue if you guys don’t have any template format I will choose not record / report.

2. Delivery Services fee ==\> It’s fixed 3$ (Region 1) and 5$ (Region 2) as I have attached the picture to you previously. On this calculated of SAMBA POS system, I think that is not related to payment type (corrected me if I’m wrong)

Thank you.

---

<div class="post-metadata">

**Author:** ![JTRTech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jtrtech/32/21270_2.png) [@JTRTech](https://forum.sambapos.com/u/JTRTech)\
**Post date:** [April 13, 2016, 4:57am UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053/49 "2016-04-13T04:57:54Z")

</div>

> [@Caps](#):
>
> I think that is not related to payment type (corrected me if I’m wrong)

No, you cannot directly report a calculation by payment type…  
You could remove either from the bottom total line by using sales rather than payment report and minus back out the calculation by ticket type but cash and card lines would not be accurately report able.

---

<div class="post-metadata">

**Author:** ![Caps](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/c/48db29/32.png) [@Caps](https://forum.sambapos.com/u/Caps)\
**Post date:** [April 14, 2016, 2:06am UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053/50 "2016-04-14T02:06:20Z")

</div>

Hi @JTRTech

Could you please show me the template format report? Thank you. 😇

---

<div class="post-metadata">

**Author:** ![Caps](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/c/48db29/32.png) [@Caps](https://forum.sambapos.com/u/Caps)\
**Post date:** [April 15, 2016, 11:39am UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053/51 "2016-04-15T11:39:27Z")

</div>

Next week I will implement SAMBA POS system, Just the last final phase about the report anyone have any solution to do the report above please kindly share to me as well. Thank you so much. 😂

---

<div class="post-metadata">

**Author:** ![Caps](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/c/48db29/32.png) [@Caps](https://forum.sambapos.com/u/Caps)\
**Post date:** [April 28, 2016, 4:24pm UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053/52 "2016-04-28T16:24:18Z")

</div>

hi @JTRTech , How to increase font of custom report? 😌

---

<div class="post-metadata">

**Author:** ![JTRTech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jtrtech/32/21270_2.png) [@JTRTech](https://forum.sambapos.com/u/JTRTech)\
**Post date:** [April 28, 2016, 4:27pm UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053/53 "2016-04-28T16:27:29Z")

</div>

Not sure we have control over font on reports…

---

<div class="post-metadata">

**Author:** ![Caps](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/c/48db29/32.png) [@Caps](https://forum.sambapos.com/u/Caps)\
**Post date:** [April 28, 2016, 4:29pm UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053/54 "2016-04-28T16:29:41Z")

</div>

Anyone can help on this issue?

---

<div class="post-metadata">

**Author:** ![Caps](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/c/48db29/32.png) [@Caps](https://forum.sambapos.com/u/Caps)\
**Post date:** [April 29, 2016, 6:48pm UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053/55 "2016-04-29T18:48:27Z")

</div>

okay … no one can help … 😭

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [April 29, 2016, 7:06pm UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053/56 "2016-04-29T19:06:18Z")

</div>

Your out of luck with version 4. Version 5 has document creation options and can support html formatting.

---

<div class="post-metadata">

**Author:** ![Caps](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/c/48db29/32.png) [@Caps](https://forum.sambapos.com/u/Caps)\
**Post date:** [April 29, 2016, 7:11pm UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053/57 "2016-04-29T19:11:40Z")

</div>

… How easy to upgrade version 4 to version 5? Is it complicated? and How about Costing? It need to buy Database Tools, Data backup and Custom Report license again or not?..

---

<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:** [April 30, 2016, 9:53am UTC](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053/58 "2016-04-30T09:53:08Z")

</div>

> [@Welcome to SambaPOS 5](https://forum.sambapos.com/t/welcome-to-sambapos-5/6911/1):
>
> Hello. Today I’m releasing latest V5 version for forum members. Visit [V5 Release Category][1] for latest updates. For more than 4 years we worked hard to create a useful software for you and released SambaPOS for free to be able to share our idea with everyone. Today SambaPOS V4 working at +60K restaurants from more than 160 countries. We successfully kept SambaPOS project alive for a long time and we reached to a new milestone. We’re releasing a Professional version for people who wants to …

> [@How to Upgrade v4 Database to a New V5 Database](https://forum.sambapos.com/t/how-to-upgrade-v4-database-to-a-new-v5-database/6912):
>
> How to migrate V4 Database to a New V5 Database using Database Backup Moduleexclamation : REMINDER Always backup your database to a location you know is safe before attempting anything like what is mentioned below. You can temporarily enable V4 database backup module on trial mode to create V4 backup. Step 1 Navigate to Settings \> Database Backups \> Settings Enable Allow overwriting database files if database names does not match during restore. option Enable Migrate after restoration. …

[Previous page](https://forum.sambapos.com/t/need-help-to-custom-the-report/10053.md?page=2)
