Transaction Extract

Report Parameters

Field	Description
Report Name	The name of the report.
Start Date	The start date from when the data must be considered for generating the report.
End Date	The end date until when the data must be considered for generating the report.
Combine Extracts	When enabled, all Sale, Void, and Return transactions will be combined and printed in a single sheet named Consolidated Data. By default, the flag will be disabled and all transactions will be printed in the respective sheets (Sale, Void, and Return).

Sample Report

Report Fields

Field	Description
TransactionId	The transaction ID.
TransactionDetailId	The identification number of the transaction.
TransactionDate	The transaction date.
RetailTicketNumber	The ticket number associated with the transaction.
ReturnItemType	The return item type. Indicates whether it is a Return with Ticket or Return without Transaction. This column will be visible only in the ReturnExtracts sheet.
ClientName	The name of the client for whom the transaction was posted.
ItemId	The identification number of the item in the transaction.
ItemNumber	The item number associated with each item in the transaction.
ItemDescription	The description of the item.
PriceBeforeDiscount	The purchase amount of items before applying the discount.
DiscountPercentage	The discount percentage applied to items in the transaction.
DiscountType	The type of discount applied to items in the transaction, for example, Seasonal Discounts.
DiscountAmount	The discount amount of items in the transaction.
PriceAfterDiscount	The purchase amount of items after applying the discount.
ServiceChargeAmount	The service charge associated with the purchased item.
ServiceChargeStaffType	The staff type (user) to which the service charge was applied.
ServiceChargeStaffName	The name of the staff to whom the service charge associated with the transaction was credited.
GratuityAmount	The gratuity associated with the purchased item.
GratuityStaffType	The staff type (user) to which the gratuity was applied.
GratuityStaffName	The name of the staff to whom the gratuity associated with the item was credited.
CommissionAmount	The commission amount applied to items in the transaction.
CommissionPercentage	The percentage of commission applied to items in the transaction.
CommissionStaffType	The staff type (user) to which the commission was applied.
CommissionStaffName	The name of the staff to whom the commission amount associated with the item was applied.