Ticket Details & Ticket Calculation Details Report

Hi guys,

Was just doing some simple reports for a client and decided to share it here as it might be useful to new people on the forum. Its been asked a lot of times.

Ticket Details Report - the idea behind this report is to show a line per ticket number and ticket details.

If you have taxes and other stuff that you wish to report you will have to modify this report a bit. This should give you an overall idea how it works.

[Ticket Details:1,1.5,1, 1, 1, 1, 1, 1]
>>Bill No|Date Created|Time Created|Sub Total|Discount|Round|Grand Total|Created By
{REPORT TICKET DETAILS:T.TicketNumber,T.Date,T.Time,=[$7-$6-$5],CA.Discount,CA.Round,T.TotalAmount,T.User}

Ticket Calculation Details - the idea behind this report is to breakdown all calculations added onto the ticket and the users that added the calculations, excluding tickets that don’t have either Discount or Round calculations.

If you have different calculation names, simply change the expressions (CA=Discount) OR (CA=Round) to match what you wish to include.

[Ticket Calculation Details:1,1, 1, 1, 1]
>>Time Modified|Calculation Type|%|Amount|Modified By
@{REPORT TICKET DETAILS:T.TicketNumber:(CA=Discount) OR (CA=Round):{0}:,}
>>Bill No $1
{REPORT CALCULATION DETAILS:C.Time,C.Type,C.Amount,C.CalculationAmount,C.User:Ticket.TicketNumber="$1"}

How it looks in the Report explorer.
image

3 Likes