Need help in custom report

V5 Question
#40

No, Like this
Group : Food

Category : Breakfast
item Qty Amount
Toasted Bagel Jam 3 6.00
Toasted Bagel Cheese 10 20.00
…
Breakfast 13 26.00

Category : Soup
Soup and Cracker 5 15,00
Soup 5 15,00

Group Food 41,00

Group Drink
Category : Beverages
Tea 3 6.00
Iced tea 2 4.00
Beverages 10.00

Category : Juice
Orange Juice 3 9.00
Apple Juice 2 8.00
Beverages 17.00

Group Drink 27.00

Total 68.00

#41

Category your referring to I presume is your menu allocation for the product.
What are your product group settings? This is what that report is returning.

#42

Group is Product Tag
Product tag is Food and Drink
this is Item Sales Report

#43

You can use pivot grids for multi level nested reporting needs.

[!Sale Groups:1,1,1,1,1:0]
>Group|Group Code|Menu Item Name|[N]Quantity|[C]Total
{REPORT ORDER DETAILS:MT.Group,M.GroupCode,O.MenuItemName,O.Quantity,O.ExactTotal}

000245.jpg2196×1473 180 KB

You can read more about it here.
http://sambapos.com/wiki/doku.php/custom_report_pivot_table_views

2 Likes
Warehouses and stock control
#44

is it work at 5.1.50?

#45

Yes that was available in v4

1 Like
#46

How to Make report Ticket Tag like this
[Card Detail :1, 1]
{TICKET TAG LIST: CCtype} … Total Amount

Card Detail
Master Card 100.00
Visa Card 50.00
…
Card Total 150.00

#47

With version 5 you do not need to store that information in ticket tags anymore. Look here for an improved way to store payments.

The report tag for it would be {REPORT PAYMENT DETAILS:X} the field would be P.Description

#48

But i still can’t get total each type Credit Card,
like
Credit Card
Master card 100 (Total Amount depend the day)
Visa 100
Amex 50
Total Credit Card 250

#49

To be able to get total for each Credit Card type you need to store only credit card type as description. Not date, CC number or any other info.

Alternatively you can create specific payment buttons (payment types) and related accounts for each credit card type instead of having single Credit Card button on Payment Screen.

1 Like
#50

here is the modified script for storing only Credit Card type minus all the other stuff.

function UpdateDescription() {
  var paymenttype = Data.Get("paymentTypeName");
  if (paymenttype=='Credit Card') {
    var cctype = dlg.AskQuestion("Choose Credit Card type","Amex=AMEX,Master Card=MAST,Visa=VISA,Discover=DISC,Other=OTHR,CANCEL=CANCEL");
    if (cctype=="CANCEL") {
      Data.Set("canContinue",false);
      dlg.ShowMessage("Payment Cancelled");
      return 1;
    }
    var ccdigits = dlg.EditValue("Last 4 CC Digits;.{4};;ON","");
    var paymentinfo = cctype;
  }
  Data.Set("description", paymentinfo);
  dlg.ShowMessage("Payment Processed\r"+paymentinfo);
  return 0;
}
1 Like
#51

@emre @Jesse
i didn’t want to create new topic for this one i found one before but no screen shot

i want to link 2 entity type together to change ticket’s between em same as change table , i want to change table to another entity

#52

I don’t understand how that relates to this topic. Go ahead and make new topic and explain your need thoroughly. What type of entity and why do you want to swap tickets between them?

#53

[Payment Detail:1, 1, 1]
{REPORT PAYMENT DETAILS:P.Description,P.Amount.sum:P.Type=Credit Card}

How to make report filter P.Description by payment Type Credit Card,

#54

[Payment Detail:1, 1, 1]
{REPORT PAYMENT DETAILS:P.Description,P.Amount.sum:(PT=Credit Card) and P.Description == “AMEX”}

1 Like
#56

Hi - the following link does not seem to work anymore - please can you help?

https://sambapos.com/wiki/doku.php?id=custom_reporting_tags

Thank you

#57

look here for good explanation on reports;

#58

Thank you :slight_smile:

#59

https://v4.sambapos.com/wiki/doku.php?id=custom_reporting_tags

@mehmet you may want to see this.

#60

OK
This problem has been solved.
The problem is related to WP theme update.

1 Like