Is there a way to query or report the transaction types and distinguish the department within the transaction?
I need to 1) locate and report on (or query) all credit transactions 2) determine the credit card type. 3) determine the department, and 4) determine the sale amount.
ALL input is appreciated!
You can't really do that. Tenders (the card transaction) are linked to Transactions (the entire sale). There may be multiple tenders on a single transaction (Cash + Credit, or multiple credit). Departments are linked to Items which are linked to TransactionEntries (the line items of a transaction). So, a single card transaction may relate to multiple items on the sale that are from different departments AND those items may be split across multiple tenders.
The only way to determine the card type is to create multiple tenders so that each card uses a different tender type - if you have a single "Credit Card" tender type, RMS doesn't store enough information to distinguish the card type - that is by design...
Glenn Adams Tiber Creek C> Is there a way to query or report the transaction types and distinguish the
Glenn, I do have multiple tender types and each card has it's own tender type. How do I report on this?
Thanks
"Glenn Adams [MVP - Retail Mgmt]" wrote:
The Tender Summary report will show tenders by type, but won't include transaction details.
There is still no direct link between Tender and Department as I tried to explain before.
Glenn Adams Tiber Creek C> Glenn,
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.