Create report specific to User and Department


#41

Actually, I found a way to accomplish my goal. Gave each terminal their own department and ticket type. Then mapped tax templates named for the terminal they are being used on. shows in report perfectly. Also easier to track that way. Now all money is tracked perfectly.


#42

I have another question about custom reports. I have a Tobacco Sales Report by User, that I am happy with. However, our accountant is not as happy. If there is a way to sort the report Alphabetically or at least have all Cigarette brands grouped together, that would be perfect. Currently it prints them by order of sale and Qty. I searched the various report Tutorials and forum and didn’t see anything similar to what I am looking for. Maybe I missed it?
@{REPORT ORDER DETAILS:O.User::{0}:,}
[Tobacco Sales for $1:3, 1, 1]
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and (TU=$1) and (MG=Tobacco)}

That’s my Syntax and result is below…

Tobacco%20Report


#43

You have .desc for qty meaning it sorts it descending from biggest to smallest. If you want it sorted by brand take .desc off and add .asc to MenuItemName


#44

Thanks. Don’t know why I didn’t think of that. Knew it had to be something simple.


#45

If you want grouped add whatever you use to set brand, guessing custom product tag to a new column in front of name and sort by that aswell


#46

Ok, slightly different report type but same topic, kind of…

I need to create a report to show Ticket Number and table and user associated with that ticket. I also want it to list the items sold for that ticket and the total amount paid.
Here is what I have so far, it pulls the ticket items but that’s it. What am i missing?

[Ticket Report:2, 1, 1]
@{REPORT TICKET DETAILS:T.TicketNumber,T.User,EN.Tables::|}
{REPORT ORDER DETAILS:O.MenuItemName,O.ItemTag,O.Quantity,O.Price:T.TicketNumber=="$1"}

#47

Because that’s all you told it to do. You don’t have ticket nhmber etc in the report you just have them as a parameter.