Custom Reporting Template Help-Discrepancy

I have a report that I built but have a discrepancy that I do not understand how to correct.

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.

image

[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}

Now there are no unpaid tickets on this report or tickets on hold that are not settled. Where in the formula do I have to correct this discrepancy?

Here is a copy of the Report file, please advise me on how to correct this issue.

Payments not shown in report, hard to say without more info exactly what your doing.

Please look at Custom Reporting Template-Discrepancy part2

Sorry on this post. It is on Custom Reporting Template-Discrepancy part 2.

@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.

I have a report that I built but have a discrepancy that I do not understand how to correct.

[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.

Now there are no unpaid tickets on this report or tickets on hold that are not settled. Where in the formula do I have to correct this discrepancy?

Here is a copy of the Report file, please advise me on how to correct this issue.

I thought it would be a little more clearer redoing the post instead of listing it again.

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…

Thank you for the help.