To enhance reports in Dutchie POS some column names have been changed to provide more consistency and clarity across our top sales reports. The table below list all the new column names and what reports they were changed on:
Sales Reports
- Average order value report
- Daily sales breakdown report
- Discount detail report
- End-of-day summary report
- Inventory transaction report by category
- POS hour totals report
- POS transactions by date report
- POS transaction summary
- Sales by category report
- Sales report
Inventory reports
- Inventory Snapshot
- Current Inventory
- Inventory Allocated Report
- Inventory Expiration
Note: Click table, and scroll left and right to see full table. You can also download the attached .csv of the table for easier viewing.
Old vs New Column Name Map
Sales Reports column mapping
| New Field Title | POS Transactions By Date Report | POS Transaction Summary | Average Order Value | POS Hour Totals | Sales By Category | Discount Detail | Inventory Transaction Report By Category | Sales Report | Daily Sales Breakdown | End of Day Summary |
| Location Name | LOCATION NAME | LOCATION | LOCATION NAME | LOCATION NAME | LOCATION | LOCATION | ||||
| Order Date | DATE | SOLD DATE | DATE | DATE | DATE | |||||
| Order Time | DATE | RECEIPT DATE | DATE | |||||||
| Day | DAY | |||||||||
| Order ID | POS ID | POS ID | RECEIPT | TRANSACTION ID | ||||||
| Order Type | ORDER TYPE | |||||||||
| Order Source | ORDER SOURCE | |||||||||
| Customer Name | CUSTOMER | CUSTOMER | PATIENT | CUSTOMER | ||||||
| Patient Medical Card ID | PATIENT ID | STATE ID | ||||||||
| Customer Type | CUSTOMER TYPE | CUSTOMER TYPE | CUSTOMER TYPE | |||||||
| Is New Customer | NEW CUSTOMERS | |||||||||
| Customer Contact | PHONE NO | |||||||||
| Caregiver ID | CARE GIVER ID | |||||||||
| Prescription ID | PRESCRIPTION NO | |||||||||
| Budtender Name | SOLD BY | SALES BY | BUDTENDER | CC | WHO ADDED TO CART | |||||
| Fulfillment Budtender Name | RESPONSIBLE FOR SALE | RESPONSIBLE FOR SALE | RESPONSIBLE FOR SALE | |||||||
| Total Orders | TRANSACTIONS | AVG TRANSACTION COUNT | TRANSACTION COUNT | |||||||
| Total Inventory Sold | TOTAL ITEMS SOLD | ITEMS | AVG ITEMS SOLD | QTY SOLD | QTY | Item Count | ||||
| Cannabis Inventory Sold | TOTAL ITEMS SOLD CANNABIS | CANNABIS COUNT | ||||||||
| Non-Cannabis Inventory Sold | TOTAL ITEMS SOLD NON CANNABIS | NON CANNABIS COUNT | ||||||||
| Total Weight Sold | GRAMS | GRAMS SOLD | GRAMS | INV CNT | ||||||
| Unit Weight Sold | UNIT GRAMS | |||||||||
| Gross AOV | GROSS AOV | |||||||||
| Net AOV | NET AOV | AVG PER CART | ||||||||
| Gross Sales | GROSS PRICE |
GROSS SALES UNIT PRICE |
GROSS SALES | AVG SALES | SALES | PRICE | PRICE | REVENUE | TOTAL SALES | TOTAL SALES |
| Discounted Amount | DISCOUNT AMT | DISCOUNT AMT | DISCOUNT | DISCOUNT AMT | DISCOUNTS | DISCOUNTS | DISCOUNTS | DISCOUNTS | ||
| Loyalty as Discount | Added | Added | Added | Added | Added | PRE TAX LOYALTY SPENT | Added | |||
| Net Sales | SOLD PRICE | NET SALES | NET SALES | NET SALES | TotalAfterDiscount | NET AMT | NET | NET SALES | NET SALES | |
| Tax Amount | POS TAX | TOTAL TAX | TAX | TAX | ||||||
| Rounded Amount | ROUNDING | |||||||||
| Loyalty as Payment | Added | POST TAX LOYALTY SPENT | Added | |||||||
| Tip Amount | TIP AMOUNT | |||||||||
| Revenue Fees / Donations | REVENUE FEES DONATIONS | |||||||||
| Non-revenue Fees / Donations | NON REVENUE FEES DONATIONS | |||||||||
| Invoice Total | TOTAL INCOME WITH ROUNDING | INVOICE TOTAL | INVOICE TOTAL | |||||||
| Loyalty Earned | LOYALTY EARNED | |||||||||
| Net Sales w/ Tax | NET SALES W TAX | |||||||||
| Net AOV w/ Tax | NET AOV W TAX | |||||||||
| Net Cash | NET CASH | |||||||||
| Master Category | MASTER CATEGORY | MASTER CATEGORY | MASTER CATEGORY | |||||||
| Category | CATEGORY | CATEGORY | CATEGORY | |||||||
| Is Category Cannabis | CANNABIS | |||||||||
| Product Name | DESCRIPTION | PRODUCT DESCRIPTION | PRODUCT | |||||||
| Product SKU | PRODUCT SKU | |||||||||
| Package ID | SERIAL NO | PACKAGE NO | ||||||||
| External Package ID | EXTERNAL PACKAGE ID | |||||||||
| Batch ID | BATCH | |||||||||
| Provincial SKU (Canada) | PROVINCIAL SKU | |||||||||
| UPC GTIN (Canada) | UPC GTIN | |||||||||
| Vendor Name | VENDOR NAME | VENDOR | ||||||||
| Inventory Cost | COST | POS PRODUCT COST | COST | COST | COST | COST | COST | |||
| Inventory Profit | PROFIT | POS NET PROFIT | PROFIT | NET PROFIT | ||||||
| Return Date | RETURN DATE | RETURN DATE | ||||||||
| Is Return Order | IS TRANSACTION | |||||||||
| Returned Amount | RETURN TOTAL | RETURN TOTAL | RETURN TOTAL | |||||||
| Void Date | VOID DATE | |||||||||
| is Delivery Order | IS DELIVERY | |||||||||
| Amount Paid in Cash | CASH PAID | CASH PAID | TOTAL CASH PAID | |||||||
| Amount Paid in Debit | DEBIT PAID | DEBIT PAID | TOTAL DEBIT PAID | |||||||
| Amount Paid in Electronic | E PAID | ELECTRONIC PAID | TOTAL ELECTRONIC PAID | |||||||
| Amount Paid in Gift Cards | GIFT PAID | GIFT PAID | TOTAL GIFT PAID | |||||||
| Amount Paid in MMAP | MMAP PAID | MMAP PAID | TOTAL MMAP PAID | |||||||
| Amount Paid in Dutchie Pay | PRE PAID | PRE PAID | TOTAL PRE PAID | |||||||
| Amount Paid in Check | CHECK PAID | TOTAL CHECK PAID | ||||||||
| Amount Paid in Credit | CREDIT PAID | CREDIT PAID | TOTAL CREDIT PAID | |||||||
| Cannabis Gross Sales | CANNABIS SALES | |||||||||
| Cannabis Net Sales | CANNABIS SALES | NET CANNABIS SALES | ||||||||
| Non-Cannabis Gross Sales | NON CANNABIS SALES | |||||||||
| Non-Cannabis Net Sales | NON CANNABIS SALES | NET NON CANNABIS SALES | ||||||||
| Register | REGISTER | |||||||||
| Coupon Amount | POS COUPON AMT | COUPONS | ||||||||
| Account Name | COMPANY | |||||||||
| Cash Returned to Customer | DUE CUSTOMER | DEBIT CASH BACK | CASH GIVEN BACK | |||||||
| Starting Hour | HOUR STARTING | |||||||||
| Total Delivery Orders | DELIVERY COUNT | DELIVERY COUNT | ||||||||
| Discount Name | DISCOUNT NAME | |||||||||
| Discount Description | DESCRIPTION | |||||||||
| Discount Code | DISCOUNT CODE | |||||||||
| Discount Approved By | APPROVING MANAGER | |||||||||
| Discount Applied Consumer Group 1 | DISCOUNT GROUP 1 | |||||||||
| Discount Applied Consumer Group 2 | DISCOUNT GROUP 2 | |||||||||
| Discount Applied Consumer Group 3 | DISCOUNT GROUP 3 | |||||||||
| Discount Applied Consumer Group 4 | DISCOUNT GROUP 4 | |||||||||
| Discount Applied Consumer Group 5 | DISCOUNT GROUP 5 | |||||||||
| Cannabis Discount Amount | CANNABIS SALES DISCOUNT | |||||||||
| Non-cannabis Discount Amount | NON CANNABIS SALES DISCOUNT | |||||||||