Void and gift report v5

V5 Question
3

ty for the code . work perfect but i think something wrong , one of my users can’t void anything and found his user in report

4

Does it say he actually voided anything or does he just show on the reportl

Its probably because the format for that report your telling it to list all users with o.user i think, kendash will be able to verify that

5

It means that user voided something :slight_smile: if he’s not supposed to then you might investigate how he was able to. The data doesn’t lie.

The report should give enough data to find the ticket.

6

:slight_smile: Sorry for the confusion. I’ve named it as O.User but in fact it is CreatingUserName on database side. In other words it is who created the order not who voided. We store voided user id within order state but I think it is not accessible atm. I’ll try to add a field to read state user.

1 Like
7

Ok so that report is not valid then unless users not allowed to open other users tickets.

1 Like
8

I think we already have it. OSU.GStatus will return user last updated GStatus state.

[Voids Detail:1,1,1,1, 1]
>User|Time|Item|Quantity|Total
{REPORT ORDER DETAILS:OSU.GStatus,O.Time,O.MenuItemName,O.Quantity,O.TotalPrice:(OS.GStatus=Void)}

These are all order state related fields.

  OS.<state name>                     Order State
  OSD.<state name>                    Order State Date
  OST.<state name>                    Order State Time
  OSV.<state name>                    Order State Value
  OSU.<state name>                    Order State User
4 Likes
9

How to make report just sold item? not include void and gift.

1 Like
10

Im using a similar report, and i have a special GStatus with value ‘Promotion’

I need to filter them out, but this doesnt seem to be working.

[Items Sold under Promotion: 5, 2, 2,1]
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
{REPORT ORDER DETAILS:O.MenuItemName,OSV.GStatus,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$1" and (OSV.GStatus=Promotion)}

11

how can i added entity name in this report. can you help me?

12

@emre can someone help me :)?

13

@Jesse can you help me?

14

http://www.sambapos.com/wiki/doku.php/custom_reporting_tags

1 Like
15

specifically…

EN.<entity type>                    Entity Name
2 Likes
16

How could I add there ticket tag name?

17

Add ticket tag to what?

18

Hi I managed to group my report by EN.Customer but am not able to add Sub total for every customer, Kindly assist. Below is my template;

[Paid Tickets:2,2,2,2,2,3,2]
>Date|Time|Ticket #|Ordered By|Gifted By|Menu Item|Amount
@{REPORT ORDER DETAILS:EN.Customer:(TS.Status=Paid) and (OS.GStatus=Gift):,} 
>>$1
{REPORT ORDER DETAILS:T.Date.asc,T.Time.asc,T.TicketNumber,O.User,OSU.GStatus,O.MenuItemName,ON.TotalPrice:(TS.Status=Paid) and (OS.GStatus=Gift):(EN.Customer=$1)} 
>Total||||||{REPORT ORDER TOTAL:(TS.Status=Paid) and (OS.GStatus=Gift)}
19

At a guess its because you dont have the (EN.Customer=$1) expression included in your customer subtotal.

1 Like
20

When I add (EN.Customer=$1) total returns blank

21

Please repost the report, perhaps you put in wrong place.
Maybe it should be TEN.Customer
Are you sure it’s Customer and not Customers

22

Thanks so much @JTRTech you were right its customers and TEN.Customers worked like a charm. Sorry I took too long to respond.

[Paid Tickets:2,2,2,2,2,3,2]
>Date|Time|Ticket #|Ordered By|Gifted By|Menu Item|Amount
@{REPORT ORDER DETAILS:EN.Customers:(TS.Status=Paid) and (OS.GStatus=Gift):,} 
>>Gifted To : $1
{REPORT ORDER DETAILS:T.Date.asc,T.Time.asc,T.TicketNumber,O.User,OSU.GStatus,O.MenuItemName,ON.TotalPrice:(TS.Status=Paid) and (OS.GStatus=Gift) and (TEN.Customers=$1)} 
>>Sub Total||||||{REPORT ORDER TOTAL:(TS.Status=Paid) and (OS.GStatus=Gift) and (TEN.Customers=$1)}