ARW Report Library – DDI System

The following pre-built report templates are available in Advanced Report Writer. Click a link in the Name column to download the report. When the download is complete, Import ARW report templates.

Tip: Click a column heading to sort by Name or Category or Primary File.

Name	Category	Primary File	Sample	Comments
AP Entered After Period Close	Accounts Payable	AP		Identify invoices entered into a previous period after it was closed.
Cash Disbursements	Accounts Payable	CHECKS		A cash disbursements journal listing all checks produced in a given date range.
Vendor Contacts	Accounts Payable	CONTACTS		A listing of Contacts assigned to Vendors.
Vendor Freight	Accounts Payable	AP		Lists all AP Invoices that contain freight charges, by Vendor.
Vendor Payments by Bank	Accounts Payable	CHECKS		Exports the total amount paid to vendors by Bank Account, useful for 1099 tax forms.
AR Aging by Ship To	Accounts Receivable	OPEN-ITEMS		A detailed aging report by Ship To location.
AR Aging Collections Summary	Accounts Receivable	OPEN-ITEMS		A collections report for salespeople.
Billing Price Overrides	Accounts Receivable	BILLING		Identifies prices overridden below the original price. Applies only to orders 'In Billing' to help catch low margins prior to invoice posting.
Daily Fast Receipts	Accounts Receivable	CUST.PAYRCPTS		A daily journal of all Fast Receipts entered, grouped by Branch or Payment.
Daily POS Batch Postings	Accounts Receivable	INVOICE		A daily journal of posted Point of Sale orders, sub-totaled by Payment & Branch.
Detailed Sales Journal	Accounts Receivable	INVOICE		An invoice sales journal, grouped by Branch, Salesperson, or Writer.
Finance Charge Payment History	Accounts Receivable	PAID.OI		Lists all paid, discounted, and adjusted finance charges by customer. Note that open (unpaid) charges are not included.
Miscellaneous Charges	Accounts Receivable	INVOICE		The total amount of invoiced Misc Charges.
New Customers Entered	Accounts Receivable	CUSTOMER		A listing of all new customer accounts created for a given date range.
New Customers by Salesperson	Accounts Receivable	CUSTOMER		A listing of all new customer accounts created for each salesperson.
Open Order Deposits	Accounts Receivable	OH		Orders containing open deposits. This applies to AR Deposits only, does not include POS.
Overdue AR Analysis	Accounts Receivable	CUSTOMER		Lists past due accounts by highest balance and includes recent AR Notes.
Ship To Listing	Accounts Receivable	SHIPTO		A listing of all Customer Ship To locations.
Tax Matrix Report	Accounts Receivable	CUST.TAX.MATRIX		Lists all tax matrices set in the Tax Matrix tab of Customer Master.
Consolidated Invoice	Document Template	INVOICE		Combines multiple invoices for a customer into one. Intended to be scheduled for monthly delivery.
Consolidated Invoice (Single Order)	Document Template	INVOICE		Combines multiple shipments from the same order number into one.
Price Quote with Images	Document Template	OH		A price quote form that displays product images (local and URL). Also includes web descriptions with support for HTML formatting.
Shopping Cart	eCommerce	CONTACTS		Exports all users saved Shopping Carts.
Web Published with No Web Category	eCommerce	PRODUCT		Identifies all products published to the web that are not assigned to a Web Category, by Vendor or Product Line.
Web User Permissions	eCommerce	CONTACTS		Exports all eCommerce users along with their permissions as set in the Contact setup screen.
Auto Inventory GL Posting	GL Accounting	INV.ADJ		A listing off automated system postings caused by specific inventory transactions, such as changing the C2 Average Cost of a product.
GL Cost by Invoice	GL Accounting	INVOICE		Breaks down each line items extended GL Cost for a specific invoice, to help identify discrepancies.
GL Monthly Balances	GL Accounting	GLB		Exports monthly opening balances for an entire year for all accounts. This should be run before and after a G/L re-index to help identify changes to account balances.
Price Matrix Export	Pricing	PRICE.MATRIX		Exports the price matrix and contracts, formatted for easy use with the Price Matrix Import.
Price Overrides	Pricing	INVOICE		Identifies invoiced products with overridden prices, grouped by salesperson.
SO Product Price Overrides	Pricing	OH		Displays any products where the selling price was overridden.
24M Product Demand	Purchasing/ Inventory	INVENTORY		Displays last 24 months of product demand and forecast data by Vendor or Product Line.
Diminishing Demand	Purchasing/ Inventory	PRODUCT	NA	Products not sold in X number of days, that have been sold at least once in last three years, by Vendor or Product Line.
Fill It Now	Purchasing/ Inventory	PRODUCT		Lists X ranked inventory with on hands, designed for upload to Fill It Now, a dead stock service for members of OMNI & Blue Hawk.
New Products Entered	Purchasing/ Inventory	PRODUCT		A listing of all new products created or fast products created for a given date range.
Open Purchase Orders	Purchasing/ Inventory	PO		Open purchase orders by branch.
Open Stock Transfers	Purchasing/Inventory	STO		Open stock transfers by warehouse.
Over-Received PO	Purchasing/Inventory	PO		Identifies vendor over shipments by displaying products where the received is greater than what was ordered.
Past Due PO	Purchasing/Inventory	PO		Open purchase orders that have passed their Confirmed or Requested dates.
Product Audit	Purchasing/ Inventory	AUDITS_PRODUCT		Changes made to products as seen in the Audit tab of the Product Master.
Product Catalog	Purchasing/Inventory	PRODUCT		Visual product catalog with product images, descriptions, and sale prices.
PO Counts	Purchasing/Inventory	PO		Counts the number of PO's created by each user.
PO Export	Purchasing/Inventory	PO		Exports a single purchase order or quote.
Received Products	Purchasing/Inventory	DAILY.REC.REP		Listing of all products received in a given date range.
Repair History	Purchasing/Inventory	INVOICE		Enter in a serial number for a complete breakdown of history and the total amount spent in repairs.
Serial Number Audit	Purchasing/Inventory	INVENTORY		Serial discrepancies where the on hand value doesn't match the number of serials in inventory.
Stock Receipts	Purchasing/ Inventory	DAILY.REC.REP		This report mimics Inform's Stock Receipt Report.
Vendor Purchases	Purchasing/ Inventory	DAILY.REC.REP		Provides vendor totals for all received products.
QuickOrder QR Labels	QuickOrder	CPSH & CUST.PROD.MINS		Scannable product labels generated from Ship To Stock Levels or from Customer Order Pad. Formatted to print to Avery Label paper (sizes 6577 & 6571).
CRM Activity Report	Sales/ CRM	USER.EVENT		Displays calendar activities for a single user.
Customer Contacts	Sales/ CRM	CONTACTS		A listing of Contacts assigned to Customers.
Customer Rank	Sales/ CRM	CUSTOMER		Sorts customers by highest ranking, grouped by salesperson.
Customer Referrals	Sales/ CRM	CUSTOMER		Using the 'Referred By' field in the Customer/Prospect Master, you can easily track the sales for new customers that were generated from customer referrals.
Customer Sales by Month	Sales/ CRM	CUSTOMER		Monthly sales for each customer, grouped by salesperson.
Customer Scorecard	Sales/ CRM	INVOICE		Compares product line sales over a rolling 24 month period and includes a month-by-month year sales comparison to last year.
Lost Sales	Sales/ CRM	OD	NA	Tracks sales lost due to lack of inventory.
Low Gross Profit	Sales/ CRM	OH		Identifies products on orders with low GP%, grouped by salesperson.
Open Sales Orders	Sales/ CRM	OH		Open sales orders by branch.
Orders by Order Type	Sales/ CRM	OH		Tracks sales by order type.
Orders Written by Hour	Sales/CRM	OH		The number of sales orders entered each hour of the day, by User or Branch.
Profitability by Product	Sales/ CRM	INVOICE		Identifies invoiced products cost and revenue.
Sales by ShipTo Location	Sales/ CRM	INVOICE		Products sold by customer/shipto, similar to a Who Bought What Report.
Sales by Source	Sales/ CRM	CUSTOMER		Tracks sales by source codes, to see which marketing campaigns generate the most sales.
Sales by Writer & Branch	Sales/ CRM	INVOICE		A summary of the total merchandise, cost, GP, and number of invoices, by writer and branch.
SO Counts by Writer	Sales/ CRM	OH		Counts the number of orders, lines items, and merchandise amount for each order writer.
SO Export	Sales/ CRM	OH		Exports a single purchase order or quote.
Bin Hits	WMS	RF.KPI		Track which bins see the most picking activity.
Bin Locations	WMS	BINS		Exports all bin locations including WMS fields.
Bin Location Labels (4x3)	WMS	BINS		A 4x3" bin label that prints to standard sheets of paper.
Cycle Count Variance	WMS	INV.ADJ		Track cycle counts with this listing of inventory adjustments.
Picked Orders	Warehouse	OH		Track picker performance with this listing of all picked products.
Products Missing UPC Codes	WMS	PRODUCT		Lists all products missing UPC data, for setup of WMS.
Truck Pick Report (Single Truck)	WMS	OH		Consolidates pick sheets by displaying all orders and products assigned to a delivery truc

Note: Reports from the ARW Report Library may not be compatible with your specific configuration or workflows. Training, assistance, and technical support for Advanced Report Writer is provided on a time-charge basis. To request help with this feature, please submit a case.

Menu

Related articles