Default SmartList favorites for Microsoft Dynamics GP

**
**

SmartList favorites in Microsoft Dynamics GP help save you time by allowing you to view the search results or modify the search results to fit your needs.

The following table lists the default SmartList favorites that are available in Microsoft Dynamics GP 10.0. The SmartList favorites named with an asterisk (*) are the default favorites in each category.

Default SmartList favorites by category

CategorySmartList favorite nameDescription

Account Summary

*

Lists grand total debit and credit transaction amounts for the accounts in your chart of accounts for each year.

Account Transactions

*

Lists all debit and credit transaction amounts for the accounts in your chart of accounts.

Currency Financials Journal

Lists all accounting debit and credit transaction amounts for transactions that originated from accounting and banking documents. Transactions are listed for open years.

Current Inventory Journal

Lists all accounting debit and credit transaction amounts for transactions that originated from inventory documents. Transactions are listed for open years.

Current Payroll Journal

Lists all accounting debit and credit transaction amounts for transactions that originated from payroll documents. Transactions are listed for open years.

Current Purchasing Journal

Lists all accounting debit and credit transaction amounts for transactions that originated from purchasing and payables documents. Transactions are listed for open years.

Current Sales Journal

Lists all accounting debit and credit transaction amounts for transactions that originated from sales and receivables documents. Transactions are listed for open years.

History Financials Journal

Lists all accounting debit and credit transaction amounts for transactions that originated from accounting and banking documents. Transactions are listed for historical years.

History Inventory Journal

Lists all accounting debit and credit transaction amounts for transactions that originated from inventory documents. Transactions are listed for historical years.

History Payroll Journal

Lists all accounting debit and credit transaction amounts for transactions that originated from payroll documents. Transactions are listed for historical years.

History Purchasing Journal

Lists all accounting debit and credit transaction amounts for transactions that originated from purchasing and payables documents. Transactions are listed for historical years.

History Sales Journal

Lists all accounting debit and credit transaction amounts for transactions that originated from sales and receivables documents. Transactions are listed for historical years.

Accounts

*

Lists the accounts in your chart of accounts.

Banking Transactions

*

Lists checkbook transactions, including any sales, purchasing, and payroll documents that affect checkbook balances.

Customer Addresses

*

Lists customers and all customer addresses, including customer ID, name, address, and phone numbers.

Customer Items

*

Lists customer items that have been set up.

Customers

*

Lists all customers.

Average Days to Pay

Lists the average days that a customer has taken to pay an invoice this year.

Customer Balance

Lists customers and their current balances.

Customer Contact List

Lists customers and the main contact person for each customer.

Customers on Hold

Lists customer records that have been placed on hold and their current balances.

Customers Over Credit Limit

Lists customers that have current balances greater than their credit limits. The customers’ credit limits also are listed.

Inactive Customers

Lists customer records that have been made inactive.

NSF Customers

Lists customers that have at least one NSF check in the year to date, including the number and amount of NSF checks.

Past Due Customers

Lists customers that have past due balances for any aging period. The customers’ past due amounts also are listed.

Employee Summary

*

Lists employee pay information, including last paycheck number, last paycheck date, and last paycheck amount.

Employees

*

Lists employee information, including name, address, and phone.

Employee List

Lists employees information, including name, address, and phone.

Vacation/Sick Time Available

Lists employees’ names, including the vacation hours and sick time that each of them has remaining for the current year.

Inventory Purchase Receipts

*

Lists items and receipts for the items.

Inventory Transactions

*

Lists transactions that have affected item quantities, including sales and purchasing transactions, item adjustments, and assembly transactions.

Items

*

Lists items and their quantities in inventory.

Back Ordered Items

Lists items and their back-ordered quantities.

Items Below Order Point Quantity

Lists items whose quantities available are less than the reorder point quantity for the items.

Items by Site

Lists items and the location code for the site where the items are stored. Record type, quantity on order, quantity on hand, and quantity allocated also are listed.

Items Due to be Counted

Lists items that are scheduled to be counted in the current week.

Items Overdue for Stock Count

Lists items that were scheduled to be counted prior to the current date.

Negative Quantity Items

Lists items whose Quantity On Hand field value in the Item Maintenance window is less than zero.

Overstocked Items

Lists items whose Quantity On Hand field value is greater than the Order Up To Level field value in the Item Maintenance window.

Items

*

Lists items.

Landed Cost Group ID

*

Lists landed cost group information.

Landed Cost ID

*

Lists landed cost information.

Multidimensional Analysis

*

Lists Multidimensional Analysis transactions.

Payables Transactions

*

Lists vendor transactions, including dates, amounts, and vendors.

Cash Requirements

Lists vendor transactions that haven’t been paid for or voided.

Discounts Expiring this Week

Lists discounts that will expire before the end of the current week.

Invoices by Vendor

Lists payables invoices, sorted by vendor ID.

Past Due Payables

Lists payables that were due prior to the current date.

Payables Documents on Hold

Lists payables documents that have a Hold status.

Payables Due Today

Lists payables that are due today.

Today's Payments

Lists payment documents that have a document date that is equal to the current date.

Today's Purchases

Lists vendor transactions entered on the current date.

Transactions by Vendor

Lists vendor transactions, sorted by vendor.

Payroll Historical Trx

*

Lists historical payroll transactions, including computer check numbers.

Check Information; Curent Year

Lists payroll checks for the current calendar year.

Payroll Transactions

*

Lists payroll transactions, including computer check numbers and pay period dates.

Transaction Information

Lists payroll transactions and information related to those transactions.

Prospects

*

Lists prospects and information related to those prospects.

Purchase Line Items

*

Lists items and quantities entered on purchase orders, including costs and vendors.

Items Past Required Date

Lists items and quantities entered on purchase orders that haven’t been received by the required date.

Overdue Receipts

Lists the receipts that have a promised date that is prior to the current date.

PO Line Items Promised This Week

Lists items and quantities entered on purchase orders that have been promised to be delivered during the current week.

This Month's Late Vendor Shipments

Lists vendor shipments that were late for the current month. A shipment is late when the receipt date is later than the promised date that was entered in the Purchasing Date Entry window.

Today's Expected Receipts

Lists receipts that have a promised date that equals the current date.

Purchase Orders

*

Lists purchase orders, the status of each purchase order, the total value of the items on the purchase order, and the total value of the items on the purchase order that haven’t been received.

Open Purchase Orders by Vendor

Lists open purchase orders, sorted by vendor.

Open Purchase Orders

Lists purchase orders with an Open status, and the total value of the items on the purchase orders that haven’t been received.

Purchase Orders On Hold

Lists purchase orders with a Hold status.

This Week's Purchase Orders

Lists purchase orders that were entered during the current week.

Receivables Transactions

*

Lists receivables transactions.

Cash Receipts Entered Today

Lists cash receipts whose document date, entered in the Cash Receipts Entry window, equals the current date.

Customer Returns

Lists customer return transactions, including dates, amounts, and customers.

Past Due Customer Transactions

Lists customer transactions with past due amounts, including customer, date, and amount information.

Receivables Due Today

Lists receivables whose document date, entered in the Receivables Transaction Entry window, equals the current date.

This Month's Sales

Lists customer invoice transactions that were entered during the current month, including customer, date, and amount information.

Today's Sales

Lists customer invoice transactions that were entered during the current day, including customer, date, and amount information.

Transactions by Customer

Lists customer transactions, sorted by customer.

Unapplied Documents

Lists customer transactions that haven’t been completely paid by customers.

Receivings Line Items

*

Lists items and quantities entered on item receipts, including costs and vendors.

Items to Put Away

Lists items whose receipt date, entered in the Item Vendors Maintenance window, equals the current date.

Shipments Received but not Invoiced

Lists shipments that were received but have not been invoiced.

Receivings Transactions

*

Lists item receipts, including the vendor, date, and subtotal amount.

Sales Line Items

*

Lists items and quantities sold on sales documents, including costs, prices, and customers.

Back Ordered Line Items

Lists items and quantities sold on sales documents that need to be purchased.

Drop-Ship Line Items

Lists items and quantities sold on sales documents that have been drop shipped, or shipped directly from your vendors to your customers.

High Priority Documents Due this Week

Lists sales documents for customers that have been marked as having a priority status between 1 and 3.

Items Overdue to Ship

Lists items whose requested ship date, entered in the Sales Transaction Entry window, is prior to the current date.

Items Past Requested Ship Date

Lists items and quantities from sales documents that haven’t been shipped by the requested shipping date.

Items Shipped Today

Lists items whose actual ship date equals the current date.

Items to Ship Today

Lists items whose requested ship date equals the current date.

Shipping Performance

Lists shipments sorted by the date they were shipped.

Workflow Shipments Due Today

Lists fulfillment orders whose requested ship date equals the current date.

Sales Transactions

*

Lists sales documents, including dates, amounts, and customers.

Fulfillment Orders to Pack

Lists fulfillment orders that have a sales document status that equals 4 or 5.

Fulfillment Orders to Pick

Lists fulfillment orders that have a sales document status that equals 2 or 3.

Fulfillment Orders to Ship

Lists fulfillment orders that have a sales document status that equals 5.

Open Invoices

Lists invoices that have been saved, but not posted.

Open Orders for Customers on Hold

Lists unposted orders for customers on hold.

Open Orders

Lists orders that have been saved.

Posted Invoices

Lists invoices that have been posted.

Quotes Expiring this Week

Lists quotes that have a quote expiration date that occurs during the current week.

Ship Complete Orders

Lists unposted orders that the ship complete document option is marked for in the Customer Maintenance window.

This Week's Back Orders

Lists the back orders for the current week.

This Week's Invoices

Lists invoices, both saved and posted, that were entered during the current week.

This Week's Orders

Lists orders that were entered during the current week.

This Week's Quotes

Lists quotes that were entered during the current week.

This Week's Returns

Lists returns that were entered during the current week.

Tax Detail Transactions

*

Lists tax detail IDs.

Vendor Addresses

*

Lists vendors and all vendor addresses, including vendor ID, name, address, and phone.

Vendor Items

*

Lists vendor items, including the vendor item description.

Vendors

*

Lists vendors, including vendor ID, name, address, and phone numbers.

1099 Vendors

Lists vendors that you must provide 1099s for.

Discounts Lost YTD

Lists discounts lost for the current year, sorted by vendor ID.

Inactive Vendors

Lists vendors that you’ve made inactive.

Vendor Balance

Lists vendors and the balances owed to the vendors.

Vendor Contact List

Lists vendors and the main contact person for each vendor.

Vendors on Hold

Lists vendor records that have been placed on hold.



Was this information useful?