| Report | Description |
|---|---|
| Adjustment | Displays a single account or interest adjustment for a customer. |
| Adjustment Receipts Batch | Displays all account and interest adjustments for specified customers. |
| Aged Receivables | Displays a detailed list of customer account balances, outstanding payments, and payment amounts. Shows the amount of days payments are overdue. Select the number and days of aging buckets. |
| Applied Credits | Shows the transactions that credits were applied to for a specific customer during a specified date range. |
| AR Invoice Activity | Displays what has been invoiced for particular dates, locations, customers, and products. |
| AR Release Numbers | Lists the AR release numbers for selected date ranges and products. Often used to provide a snapshot of what is happening per scheduled day (to allow for planning).
Tip: Ordered From is the WO line location; Shipped From is the LOT or INV line location.
|
| AR Taxes | Shows all the applicable AR sales taxes, including tax exceptions and override rates. |
| Bill & Hold | Shows bill and hold information grouped by customer or by product. |
| Cash Out | Displays the AR Activity of Payments and Invoices by location. Includes optional Cash Worksheet to assist with bank deposits. |
| Comparative Customer Sales | Displays a comparison of sales between sales per product and per customer. |
| Credit Info | Displays customer current balances, prepayments, warning limits, interest rates, current credit limits, and optionally bank information. |
| CRS Transfer | AR Invoice created when transferring items to another association. |
| Customer Account Activity | Displays a selected customer’s current balances and all of the account activities that affect the current balances. |
| Customer Balances | Displays a selected customer’s charge, credit, prepayment, and net balances. |
| Customer List | Displays all selected customers and their contact information. (defaults to Active - Yes click More Options to change) |
| Customer Position | Displays the position of prepaid committed products to be shipped to customers. |
| Customer Prepayment | Displays a selected customer’s prepayment deposits, plans, and activities. Paid - refers to status of Work Order Paid In Full checkbox |
| Customer Prepayment Position | Shows customers’ total prepayment amounts remaining and compares them to their prepayment plans. |
| CRM Activity Summary | Lists CRM activities by Customer. |
| Customer Sales | Lists all the invoices and invoice details for selected customers. Sales Reps - Sales Rep under Select Customers is sales rep on customer account; - Sales Rep next to Location of Sale is sales rep on Invoice (which may have been changed from default sales rep on customer account). Manufacturers - Manufacturer under Select Products is manufacturer on product now; - Manufacturer of Sale is manufacturer on product at time of sale. Group by Supplier - from Supplier Product Code Mappings (if multiple, looks at top row only). Tip 1: Use the Product List data export to identify products flagged as Omit from Sales Reports.
Tip 2: To display Permit information, Group Sales By: Customer and Product and check the Show Permits box. |
| Customer Sales - Single Customer | Run from the Customer Account, lists all the invoices and invoice details for that customer. |
| Customer Statement | Displays a selected customer’s account activity, debits, credits, and balances during a specified date range. Used to send to customers for billing. Can include a dynamic "special comment" text line that will display on each statement in this run only, or a more permanent comment for each location that will appear on every statement run until it is changed or removed. |
| Customer Summary Statement | Displays a summary of Purchases, Returns, Adjustments, Interest, Payments, Prepay Deposits, Prepay Purchases, Prepay Transfers, and details of purchases and Taxes. |
| Discount Groups | Displays all discount groups and their details. |
| Interest Charges Applied | Displays a selected customer’s interest charges and interest adjustments. |
| Invoice | Displays purchase date and due date, purchased products, and prices. |
| Invoice Activity | Provides an overview of invoices in the system. Shows what has been invoiced: for particular invoice dates, entry dates, locations, customers, and/or products. |
| Invoice Batch | Displays all invoices for specified customers to be printed and sent to customers for billing. Payment Type refers to Immediate Payments only. Note: When backdating, the batch report may display permit details differently than the non-menu version if the customer has multiple permits (with different expiry dates) for the same product.
|
| Loadout Ticket | Displays products/services on Loadout Ticket; provided to customer on receipt of goods (customers may refer to it as a bill of lading or delivery slip). |
| Loadout Ticket Activity | Displays all loadout tickets and their details, including products, dates, and locations. |
| Loadout Ticket Batch | Displays all loadout tickets for specified customers to be printed and sent to customers. |
| Payment Activity | Displays payments received from customers of various payment types. Used for reconciliation and to assist with bank deposits. Show Undeposited Funds Only - transactions that will not display: - funds that have been deposited - funds received/paid out when payment type is flagged to not show on Bank Deposits |
| Payment Receipt | Displays receipt for payments and prepayments received to be printed. |
| Payment Receipts Batch | Displays all payment receipts for payments and prepayments received. |
| Suggested Interest Charges | Displays the suggested interest charges on or before a certain date.
Note: Calculation Method defaults to Balance Forward; remember to change to Daily if that is the method your company is using, then save as a Report Favourite.
|
| Suggested Receipts | Shows the outstanding receivables as of a given date. Useful for predicting the dollar value of expected payments (based on invoice due dates).
Tip: Sort by Date, then when viewing the results think of the Due Date column (on the far left) as the "future date". If you want to know how much you can expect in customer payments by August 31, scan down the Due Date column until you get to August 31. If you want to know how much to expect by the end of the year, scan a few more pages until you get to December 31.
|
| Transport of Dangerous Goods | Displays a list of dangerous goods and all information required by Transport Canada. Applicable to LOTs, Invoices. There are layouts that can display all products, not just the dangerous ones. |
| Work Order | Displays products and pricing details of a given work order/quote; intended for the customer. |
| Work Order Activity | Displays all work orders and their details, including dates, prices, and any committed, ordered, prepaid, and/or taken products. Sort By: Sales Rep is sales rep on work order. If Show Totals is checked, average unit price (per product, weighted by Quantity Ordered) is displayed in totals section. |
| Work Order Batch | Displays all work orders for specified customers. |
| WO and PO Activity Combined | displays Purchase Orders and the Work Orders that created them (PO quantities converted to work order units; PO prices converted to home currency) |