REPORT ORDER DETAILS Tag

V5 Question
1

Does anyone know how to use this Expression:

PA Ticket Contains a Payment

Not quite sure what should go in here?

I might explain myself a bit more. @emre I am trying to get a Report of all FOOD Group Orders paid by Account. Is that possible using Tags?

EDIT:
Umm If I enter something like PA=Cash - it works Emre but every Customer Account is difference such as “123-Finlay” or “456-Cane” therefore how do I nominate all Customer Accounts :confused:

Sample Syntax: Working

[Detailed Sales Product by Customer:6,5, 6, 3, 3, 1, 2]
>CUSTOMER|ITEM GROUP|ITEM|PORTION|QTY|TOTAL
{REPORT ORDER DETAILS:EC.Customer.Full Name.asc,O.ItemGroup,O.MenuItemName,O.PortionName,O.Quantity,O.ExactTotal:(ODI=True) && (TCET=Customers) && (PA=Cash BR1)}
2

Use a parameter and load customer accounts into it.

3

Umm ok I get “Parameter” and I get “Customer Account” but @Jesse I do not get the load thing? So Every Customer Account is unique and can be in the thousands …

4

How do you define food group orders? How you’ll handle partial payments?

5

I think you misunderstand me @emre - separating Food Group Orders is using the MG expression easy. It is the question of:

How do you report on Orders Paid by Customer Account?

I have 1,500 separate Customer Accounts…

I also do not understand your reference to:

?

6

Ok @Jesse - there is no doubt you are very intuitive! It took several reads of your statement before I cottoned on what you were suggesting!

So this almost works BUT feeding in the same Parameter List to get a Total screws up the Report. The Report is a little useless without a Total…

[Detailed Sales Product by Customer CASH:6,5, 6, 3, 3, 1, 2]
>CUSTOMER|ITEM GROUP|ITEM|PORTION|QTY|TOTAL
@{REPORT PAYMENT DETAILS:P.Name,P.Amount.Sum.desc:(PT=House Wallet) && Payment.Amount > 0:{0}:,}
{REPORT ORDER DETAILS:EC.Customer.Full Name.asc,O.ItemGroup,O.MenuItemName,O.PortionName,O.Quantity,O.ExactTotal:(ODI=True) && (MG=BA Food) && (PA=$1)}

FoodOrderSummary.JPG732×208 40.8 KB

I have tried this syntax BUT I get several Total Lines!

TOTAL|||||$[=F(TN('{REPORT ORDER DETAILS:O.ExactTotal.sum:(ODI=True) && (MG=BA Food) && (PA=$1)}'),'#,#0.00')]
7

Convert it to a table view then sum the column.

8

You mean through convert through SQL Script? Or just use JSCRIPT?

9

No put a # in the name like [#report:1,1,1,2]

10

Oh that was the 3rd option - can you shown me how please as never done that before?

11

Im still stuck with my phone so i will have to sshot a report. One min.

12

Look up my old v4 timeclock linked with users tutorial. It has a download that contains sample reports using table views.

Its so hard for me to link or copy stuff from my phone.

13

I was looking at this from another thread:

[#Pax Tickets:1,1]
>[N]Guest|[C]Amount
{REPORT TICKET DETAILS:TT.Guest,TN.TotalAmount:(TT=Guest)}

Is that what you are referring to?

14

Yes that is it. You can customize the column total. I think i showed how to do it in my v4 tutorial for time clock. I mean down in the discussion i showed screenshots etc.

15

Never ever seen that before so [C] means SUM? If its in the Tute I will also check.

16

No C allows currency for that column in table view it formats the column view. N is numeric if i remember right. You have to turn on the grand total view by right clicking in a column. You can sum the column or average it etc.

17

Oh I better go have a read then…
I have this so far so just need to add it up!

SumFoodTable.JPG743×387 35.5 KB

When I work it out how do I join it to the Table above? OR maybe I stuff the Total in the HEADER somewhere?

18

No im saying convert your entire report to it.

19

Does not look that great? Does it print differently, as has not checked that yet…

20

You can right click a column and open the view editor and customize it.

For example click on Options View and enable ShowFixedSummaryTotal then exit the editor and right click the new bar at bottom and format columns to total.

20160726_230157.jpg4032×2268 3.67 MB

14695921839011785015160.jpg2268×4032 3.48 MB