Sales Summary Report Fields

From FloristWiki

(Difference between revisions)
Jump to: navigation, search
(New page: {| style="border:1px black solid; border-collapse:collapse; text-align:left;" cellpadding="6" |- !style="width:100pt; background:#2B90DC; color:white; border-spacing:0px;" | '''Column'''...)
Current revision (08:42, 18 April 2008) (edit) (undo)
 
(6 intermediate revisions not shown.)
Line 4: Line 4:
!style="width:400pt; background:#2B90DC; color:white" | '''Description'''
!style="width:400pt; background:#2B90DC; color:white" | '''Description'''
|-valign="top"
|-valign="top"
-
! Customer No.
+
! Units
-
| The account number of the customer with aged balance(s).
+
| Number of sales of a given type.
|- valign="top"
|- valign="top"
-
! Customer Name
+
! Merch Amount
-
|Name of the customer with aged balance(s).
+
|Value of the statement category Product Amount for the sales of a given type.
|-valign="top"
|-valign="top"
-
! Phone Number
+
! Delivery Charges
-
| Phone number of the customer with aged balance(s).
+
| Value of the statement category Delivery Charge for the sales of a given type.
|-valign="top"
|-valign="top"
-
! Days Late
+
! Relay Charges
-
| Aging bucket or days late of the customer’s oldest transaction. If the oldest transaction is less than 120 days old, Days Late will show the aging bucket of the transaction (30 = ransactions 30-60 days old; 60 = transactions 61-90 days old; or 90 = transactions 91-120 days old). For transactions 121 days and older, Days Late shows the actual days late.
+
| Value of the statement category Relay Charge for the sales of a given type.
|-valign="top"
|-valign="top"
-
! Last Payment Date
+
! Service Charges
-
| Date on which the last payment was entered for the customer account.
+
| Value of the statement category Service Charge for the sales of a given type.
|-valign="top"
|-valign="top"
-
! Accounting Type
+
! Coupons
-
| Indicates whether the customer’s account is set up as a balance forward or open item account.
+
| Value of the statement category Coupon for the sales of a given type.
|-valign="top"
|-valign="top"
-
! Ticket #
+
! Discount Amount
-
| Number associated with an order.
+
| Value of the statement category Discounts for the sales of a given type.
|-valign="top"
|-valign="top"
-
! Sale Date
+
! Total Without Tax
-
| Date of the ticket.
+
| Sum of the sales’ merchant amount, delivery charge, relay charge, and service charges less discount and coupon amounts.
|-valign="top"
|-valign="top"
-
! Del Date
+
! Sales Tax
-
| Scheduled delivery date.
+
| Value of sales tax for the sales of a given type.
|-valign="top"
|-valign="top"
-
! Transaction Date
+
! Total
-
| Type of transaction. Transactions with balances prior to the Balance Forward date appear with transaction type of Balance Forward. If you generate the Aged Analysis report after running statements you may see Transaction Type of Finance Charge.
+
| Sum of Total without Tax and Sales Tax for the sales of a given type.
|-valign="top"
|-valign="top"
-
! Product Code
+
! Percentage
-
| Code for the product.
+
| Percent of total sales that the row represents.
|-valign="top"
|-valign="top"
-
! Product Description
+
! Total Sales Summary
-
| Product name.
+
| Summarizes total sales by payment method.
|-valign="top"
|-valign="top"
-
! Tax Code
+
! Gift Certificate/Card Summary
-
| Tax code associated with the transaction.
+
| Summary of sales in which gift cards and gift certificates were purchased and redeemed.
 +
|-valign="top"
 +
! Total Outgoing Sales
 +
|Summary of outgoing sales.
 +
|-valign="top"
 +
! Total Pending Outgoing Sales
 +
|Summary of outgoing sales that are waiting to be transmitted.
 +
|-valign="top"
 +
! Total Local Sales
 +
|Summary of local sales.
 +
|-valign="top"
 +
! Incoming Sales Summary
 +
|Summarizes incoming wire sales by wire service, including phoned in orders.
 +
|-valign="top"
 +
! Outgoing Wire Summary
 +
|Summarizes outgoing wire sales by wire service. Includes statement category types of product and delivery.
 +
|-valign="top"
 +
! Payments Received
 +
|Amounts received for house account payments.
|-valign="top"
|-valign="top"
-
! Total Amount
 
-
|Total amount for the transaction.
 
|-
|-
|}
|}
-
Back to [[Business Reports]]
+
[[Store Transfer Fields]]
 +
 
 +
Back to [[Sales Summary Reports]]

Current revision

Column Description
Units Number of sales of a given type.
Merch Amount Value of the statement category Product Amount for the sales of a given type.
Delivery Charges Value of the statement category Delivery Charge for the sales of a given type.
Relay Charges Value of the statement category Relay Charge for the sales of a given type.
Service Charges Value of the statement category Service Charge for the sales of a given type.
Coupons Value of the statement category Coupon for the sales of a given type.
Discount Amount Value of the statement category Discounts for the sales of a given type.
Total Without Tax Sum of the sales’ merchant amount, delivery charge, relay charge, and service charges less discount and coupon amounts.
Sales Tax Value of sales tax for the sales of a given type.
Total Sum of Total without Tax and Sales Tax for the sales of a given type.
Percentage Percent of total sales that the row represents.
Total Sales Summary Summarizes total sales by payment method.
Gift Certificate/Card Summary Summary of sales in which gift cards and gift certificates were purchased and redeemed.
Total Outgoing Sales Summary of outgoing sales.
Total Pending Outgoing Sales Summary of outgoing sales that are waiting to be transmitted.
Total Local Sales Summary of local sales.
Incoming Sales Summary Summarizes incoming wire sales by wire service, including phoned in orders.
Outgoing Wire Summary Summarizes outgoing wire sales by wire service. Includes statement category types of product and delivery.
Payments Received Amounts received for house account payments.

Store Transfer Fields

Back to Sales Summary Reports

Retrieved from "http://floristwiki.ftdi.com/index.php/Sales_Summary_Report_Fields"
Personal tools
Navigation