Gross Sales|{REPORT TICKET DETAILS:T.TotalAmount.sum}
Void Total|{REPORT ORDER DETAILS:O.TotalPrice.sum:(OS.GStatus=Void) or (OS.GStatus=Gift)}
Discounts|[=F(TN('{REPORT CALCULATION DETAILS:C.CalculationAmount.sum:(CT=Employee Discount) or (CT=Police & VIP) or (CT=Manager Meal) or (CT=Discount)}')*1)]
Michigan Sales Tax|{REPORT TICKET DETAILS:T.Tax.sum}
>Net Sales|[=F(TN('{REPORT TICKET DETAILS:T.TotalAmount.sum}')-TN('{REPORT TICKET DETAILS:T.Tax.sum}')-TN('{REPORT ORDER DETAILS:O.TotalPrice.sum:(OS.GStatus=Void) or (OS.GStatus=Gift)}')+TN('{REPORT CALCULATION DETAILS:C.CalculationAmount.sum:(CT=Employee Discount) or (CT=Police & VIP) or (CT=Manager Meal) or (CT=Discount)}'))]
>Total Sales|[=F(TN('{REPORT TICKET DETAILS:T.TotalAmount.sum}')-TN('{REPORT TICKET DETAILS:T.Tax.sum}')-TN('{REPORT ORDER DETAILS:O.TotalPrice.sum:(OS.GStatus=Void) or (OS.GStatus=Gift)}')+TN('{REPORT CALCULATION DETAILS:C.CalculationAmount.sum:(CT=Employee Discount) or (CT=Police & VIP) or (CT=Manager Meal) or (CT=Discount)}')+TN('{REPORT TICKET DETAILS:T.Tax.sum}'))]
Total Cash Paid Out|[=F(TN('{REPORT ACCOUNT TRANSACTION DETAILS:T.Amount.sum:(ATT=Paid Out Transaction Type)}')-TN('{REPORT ACCOUNT TRANSACTION DETAILS:T.Amount.sum:(ATT=Paid In Transaction Type)}'))]
>Total Revenue|[=F(TN('{REPORT TICKET DETAILS:T.TotalAmount.sum}')-TN('{REPORT TICKET DETAILS:T.Tax.sum}')-TN('{REPORT ORDER DETAILS:O.TotalPrice.sum:(OS.GStatus=Void) or (OS.GStatus=Gift)}')+TN('{REPORT CALCULATION DETAILS:C.CalculationAmount.sum:(CT=Employee Discount) or (CT=Police & VIP) or (CT=Manager Meal) or (CT=Discount)}')+TN('{REPORT TICKET DETAILS:T.Tax.sum}')-TN('{REPORT CALCULATION DETAILS:C.CalculationAmount.sum:(CT=Employee Discount) or (CT=Police & VIP) or (CT=Manager Meal) or (CT=Discount)}')-TN('{REPORT ACCOUNT TRANSACTION DETAILS:T.Amount.sum:(ATT=Paid Out Transaction Type)}')-TN('{REPORT ACCOUNT TRANSACTION DETAILS:T.Amount.sum:(ATT=Paid In Transaction Type)}'))]`
Here is a portion of the sales summary. Please note the Gross Sales should be all ticket sales + Voided& Gift Sales + Discounts + Sales tax. Total Sales is the Gross Sales minus Voided & Gift Sales minus Discounts plus Sales tax. If you look at the Total Sales the figure does not match with payment received.
@bizman2133 not sure why you created a new topic for the same thing instead of replying here, anyway I have merged that topic into this one. Please continue discussing here and reply on this topic rather than creating new topics about the same thing.
[Sale Summary:2, 1, 1, 1]
>>Ticket Sales
{REPORT TICKET DETAILS:T.TicketType.,'',T.PlainSum.Percent.asc,T.PlainSum.sum}
Ticket Sales Total||{REPORT TICKET DETAILS:T.PlainSum.Percent,T.PlainSum.sum}
Gross Sales|{REPORT TICKET DETAILS:T.TotalAmount.sum}
Void Total|{REPORT ORDER DETAILS:O.TotalPrice.sum:(OS.GStatus=Void) or (OS.GStatus=Gift)}
Discounts|[=F(TN('{REPORT CALCULATION DETAILS:C.CalculationAmount.sum:(CT=Employee Discount) or (CT=Police & VIP) or (CT=Manager Meal) or (CT=Discount)}')*1)]
Michigan Sales Tax|{REPORT TICKET DETAILS:T.Tax.sum}
>Net Sales|[=F(TN('{REPORT TICKET DETAILS:T.TotalAmount.sum}')-TN('{REPORT TICKET DETAILS:T.Tax.sum}')-TN('{REPORT ORDER DETAILS:O.TotalPrice.sum:(OS.GStatus=Void) or (OS.GStatus=Gift)}')+TN('{REPORT CALCULATION DETAILS:C.CalculationAmount.sum:(CT=Employee Discount) or (CT=Police & VIP) or (CT=Manager Meal) or (CT=Discount)}'))]
>Total Sales|[=F(TN('{REPORT TICKET DETAILS:T.TotalAmount.sum}')-TN('{REPORT TICKET DETAILS:T.Tax.sum}')-TN('{REPORT ORDER DETAILS:O.TotalPrice.sum:(OS.GStatus=Void) or (OS.GStatus=Gift)}')+TN('{REPORT CALCULATION DETAILS:C.CalculationAmount.sum:(CT=Employee Discount) or (CT=Police & VIP) or (CT=Manager Meal) or (CT=Discount)}')+TN('{REPORT TICKET DETAILS:T.Tax.sum}'))]
Total Cash Paid Out|[=F(TN('{REPORT ACCOUNT TRANSACTION DETAILS:T.Amount.sum:(ATT=Paid Out Transaction Type)}')-TN('{REPORT ACCOUNT TRANSACTION DETAILS:T.Amount.sum:(ATT=Paid In Transaction Type)}'))]
>Total Revenue|[=F(TN('{REPORT TICKET DETAILS:T.TotalAmount.sum}')-TN('{REPORT TICKET DETAILS:T.Tax.sum}')-TN('{REPORT ORDER DETAILS:O.TotalPrice.sum:(OS.GStatus=Void) or (OS.GStatus=Gift)}')+TN('{REPORT CALCULATION DETAILS:C.CalculationAmount.sum:(CT=Employee Discount) or (CT=Police & VIP) or (CT=Manager Meal) or (CT=Discount)}')+TN('{REPORT TICKET DETAILS:T.Tax.sum}')-TN('{REPORT CALCULATION DETAILS:C.CalculationAmount.sum:(CT=Employee Discount) or (CT=Police & VIP) or (CT=Manager Meal) or (CT=Discount)}')-TN('{REPORT ACCOUNT TRANSACTION DETAILS:T.Amount.sum:(ATT=Paid Out Transaction Type)}')-TN('{REPORT ACCOUNT TRANSACTION DETAILS:T.Amount.sum:(ATT=Paid In Transaction Type)}'))]
[Sales Adjustment Details:2.5, 1, 1, 1]
>>Discount Summary
{REPORT CALCULATION DETAILS:C.Name.asc,C.CalculationAmount.sum}
>Discount Total [=F(TN('{REPORT CALCULATION DETAILS:C.CalculationAmount.sum}')/TN('{REPORT TICKET DETAILS:T.PlainSum.sum}')*-100)]%|[=TN('{REPORT CALCULATION DETAILS:C.CalculationAmount.sum}')*1]
>>Void and Gift Summary
{REPORT ORDER DETAILS:OSV.GStatus,OS.GStatus,O.Quantity.count,O.TotalPrice.sum.desc:(OS.GStatus=Void) or (OS.GStatus=Gift)}
>Void and Gift Total [=F(TN('{REPORT ORDER DETAILS:O.TotalPrice.sum:(OS.GStatus=Void) or (OS.GStatus=Gift)}')/TN('{REPORT TICKET DETAILS:T.PlainSum.sum}')*100)]%|{REPORT ORDER DETAILS:O.TotalPrice.sum:(OS.GStatus=Void) or (OS.GStatus=Gift)}
Voids and Gifts automatically excluded from all Sales amounts.
[Refunds:1, 1]
{REPORT TICKET TYPES:TotalAmount < 0}
Refunds automatically excluded from all Sales amounts.
[Pre Orders:1, 1]
{REPORT TICKET TYPES:PreOrder && TotalAmount >= 0}
[Payments Received:2, 1, 2]
{REPORT PAYMENT DETAILS:P.Name,P.Amount.Percent,P.Amount.Sum:Payment.Amount > 0}
>Total|{REPORT PAYMENT DETAILS:P.Amount.Sum:Payment.Amount > 0}
Here is a portion of the sales summary. Please note the Gross Sales should be all ticket sales + Voided& Gift Sales + Discounts + Sales tax. Total Sales is the Gross Sales minus Voided & Gift Sales minus Discounts plus Sales tax. If you look at the Total Sales the figure does not match with payment received.
May be wrong but gift and void order wouldn’t be included in plain report…
Think you need to work the other way, gross would need the sum, net would already be without void/gift by default…