- EBMS Knowledge Base
- EBMS Main Documentation
- Automotive | Keystone Interface
-
Client Resources
-
EBMS Main Documentation
- Introduction
- Getting Started
- Getting Started | Initial Installation
- Getting Started | Company Setup
- Quick User Guide | Financial Staff | Accountant
- Quick User Guide | Financial Staff | Accountant | Accountants Journal
- Quick User Guide | Sales Staff
- Quick User Guide | General Staff
- Features
- Reports
- Reports | Excel Add-In
- Reports | Excel Add-In | Troubleshooting
- Security
- Server Manager
- Technical
- Technical | Data Import and Export Utility
- Technical | SQL Mirror
- Automotive
- Automotive | Parts Catalog
- Automotive | Pricing
- Automotive | Point of Sale
- Automotive | Product Application
- Automotive | Keystone Interface
- Metal Supply
- Fuel Sales
- Horticulture
- Horticulture | Farm Setup
- Horticulture | Processing Payroll
- Horticulture | Managing the Farm
-
Sales
- Introduction
- Customers
- Customers | Miscellaneous Customers
- Proposals
- Proposals | Processing Proposals
- Proposals | Sets and Templates
- MyProposals
- MyOrders
- Sales Orders
- Invoices
- Materials Lists
- Sales and Use Tax
- Sales and Use Tax | TaxJar
- CRM
- CRM | Auto Send
- Recurring Billing
- Credits
- Customer Payments
- Payment Card Processing
- Payment Card Processing | Gift Cards
- Payment Card Processing | Loyalty Cards
- Payment Card Processing | Verifone Gateway
- Freight and Shipping Tools
- General Ledger Transactions
- Point of Sale
- Point of Sale | Point of Sale Hardware
- Point of Sale | Xpress POS System
- Point of Sale | Advanced Tools
- Signature Capture
- Salesperson Commissions
-
Inventory
- Product Catalog
- Product Catalog | Using Product Codes for No Count Items
- Product Pricing
- Product Pricing | Special Pricing
- Tracking Counts
- Unit of Measure
- Purchasing
- Special Orders and Drop Shipped Items
- Receiving Product
- Barcodes
- MyInventory and Scanner
- Components (BOM) and Accessories
- Components (BOM) and Accessories | Component Formula Tool
- Made-to-Order Kitting
- Configure-to-Order Kitting
- Multiple Inventory Locations
- Multiple Inventory Locations | Creating Locations
- Multiple Inventory Locations | Using Multiple Locations
- Multiple Inventory Locations | Product Catalog Sync
- Multi-Vendor Catalog
- Serialized Items
- Serialized Items | Purchasing or Manufacturing an Item
- Serialized Items | Selling and/or Associating an item with a customer
- Lots
- Product Attributes
- Product Attributes | Selling and Purchasing Items with Attributes
- Product Attributes | Custom Attributes
- Mobile Scanner (Legacy)
-
Labor
- Getting Started
- Workers
- Taxes and Deductions
- Work Codes
- Time and Attendance
- Time and Attendance | Time Track App
- Processing Payroll
- Closing the Payroll Year
- Processing Payroll - Advanced
- Salaried Pay
- Piecework Pay
- Direct Deposit
- 3rd Party Payroll Service
- Subcontract Workers
- Flag Pay
- Prevailing Wages
- MyDispatch
- MyTasks
- MyTime
- MyTime | Communications
- MyTime | Setup
- Tasks
- Tasks | Getting Started
- Tasks | Creating Tasks
- Tasks | Scheduling Tasks
- Tasks | Customizing Task Views
- Tasks | Managing Tasks
-
Financials
- Introduction
- Fiscal Year
- Chart of Accounts
- Budget
- Financial Reporting
- Transactions and Journals
- Transactions and Journals | Journals
- Account Reconciliation
- 1099
- Departments and Profit Centers
- Fund Accounts
- Bank Accounts
- Bank Feed
- Vendors
- Vendors | Miscellaneous Vendors
- Purchase Orders
- Expense Invoices
- Vendor Payments
- AP Transactions
- Landed Cost
- Fixed Assets and Depreciation
- Fixed Assets and Depreciation | Fixed Assets
- Fixed Assets and Depreciation | Fixed Assets | Adding Assets
- Fixed Assets and Depreciation | Processing Depreciation
- Fixed Assets and Depreciation | Disposing Assets
- MyJobs
-
E-commerce
-
Rental
-
Job Costing
-
Manufacturing
Inactive Keystone Items
EBMS contains a Discontinued by Keystone Automotive option found within each inventory item. This switch is updated each time the Keystone inventory update utility is launched. Review the Inventory Updates section for more details on the update utility. Open an inventory item and click on the Automotive tab to view the Discontinued by Keystone Automotive switch as shown below:
-
The Discontinued by Keystone Automotive switch is a flag that the item has been discontinued by Keystone and can only by set by Keystone through inventory updates.
-
The Superseding Item ID is the inventory item that is replacing the superseded item. Keystone inventory updates populate this field, but the EBMS user can change this if desired.
-
Lists can be viewed or printed based on the following query settings.
Inventory List
Complete the following steps to show the inventory items based on the Discontinued by Keystone Automotive switch:
-
Open the inventory list by selecting Inventory > Product Catalog from the main EBMS menu.
-
Click on the Find button on the lower side of the inventory list to open the following dialog:
-
Click on the Advanced button to open the following query option.
-
Select the KA_DISCON Database Field as shown above.
-
Select the is true Operator to list only the items that have the Discontinued by Keystone Automotive option enabled. Use the is False operator to list all items with the Discontinued by Keystone Automotive option disabled.
-
Click on the OK button to save the advanced query. Review Technical > Advanced Query Options for more information on this powerful query tool.
-
Click OK on the find dialog.
Notice that the items will be displayed on the inventory list based on the status of the Discontinued by Keystone Automotive option found within the Keystone tab of each item.
Review the Standard Features > Advanced Query Options section of the main manual for more details on advanced query options.
Inventory Report
A similar query can be used for any inventory report. Complete the following steps to print a list based on the Discontinued by Keystone Automotive option:
-
Open the report menu by selecting File > Reports from the main EBMS menu.
-
Select the Inventory Item List report within the Inventory > Lists report group as shown below:
-
Click on the Print button to open the print dialog.
-
Click on the Set Query button to open the following query dialog.
-
Select the KA_DISCON Database Field as shown above.
-
Select the is true Operator to print only the items that have the Discontinued by Keystone Automotive option enabled. Use the is False operator to print all items with the Discontinued by Keystone Automotive option disabled.
-
Click on the OK button to save the advanced query.
-
Click Print or Print Preview to print the report.
-
Notice that the items will be printed based on the status of the Discontinued by Keystone Automotive option found within the Keystone tab of each item.