• Tutorials
    • Forms, Navigation
    • Forms, Popup and Context Menus
    • Forms, Color of Fields
    • Forms, Changing the Font
    • Forms, Customizing
    • Forms, Printing Reports
    • Forms, Send Email
    • Forms, Help
    • Grids, Navigation
    • Grids, Scrollbars
    • Grids, Functions
    • Grids, Functions, Refresh
    • Grids, Functions, New Wizard
    • Grids, Incremental Search
    • Grids, Selecting Multiple Records
    • Grids, Find and Find Next
    • Grids, Filters
      • Filters, Creating a New
      • Filters, Getting Fancy
      • Filters, Saving and Reusing
      • Filters, Default Filters
    • Grids, Printing Reports
    • Grids, Customizing
    • Menus, Shortcut Keys
    • Forms, Form Letters
      • How to print a Form Letter, Richtext
      • How to print a Form Letter, PDF
      • How to create your own Form Letter
  • Webinars
  • Training
    • Windows XL Training
    • Mobile Delivery
  • What’s New
  • Follow us on Twitter

TeamDME! XL Help

  • System
    • Company
    • Postal Codes
    • Task
    • User Security
    • Dashboard
    • Report Designer
  • Inventory
    • Item
    • Item Category
    • Item Department
    • Item Manufacturer
    • Item Location
    • Tracked Item
    • Activity
      • Physical Count
      • Item Adjustment Edit
      • Service Transaction Edit
      • Item Transfer Edit
    • Reports
  • Orders
    • Diagnosis Code
    • HCPCS Procedure Code, Edit
    • HCPCS Procedure Modifier
    • HCPCS Coverage Criteria List
    • HCPCS Fee Schedule
    • Physician
    • Payor
    • Therapist
    • Facility
    • Quote
    • Medical Order
    • Point-of-Sale
    • Recurring
    • Claim Pending
    • Claim History
    • Reports
  • Receivable
    • Customer
    • Salesperson
    • Referral
    • Nonallowed Reason
    • Responsible Reason
    • Adjustment Reason
    • Payment Type
    • Payment
    • Reports
      • Aged Receivable Reports
      • Revenue Reports
      • Audit Reports
      • Finance Fee
      • Customer Statement
      • Collection Letter
  • Purchase Orders
    • Purchase Order
    • Purchase History
  • Payables
    • Vendor
    • Unposted Invoice
    • Unpaid Invoice
    • Reports
      • Aged Payable
      • Open Payable
      • Cash Requirements
      • IRS 1099 Forms
  • Ledger
    • Chart of Account
    • Journal Unposted
    • Journal History
    • Bank Register
    • Reports
      • Balance Sheet
      • Income Statement
      • Trial Balance
  • Windows
You are here: Home / Inventory / Table / Item / How to delete an Item
«« Item Edit, HistoryWhat is the best way to enter Item Descriptions »»

How to delete an Item

If you have entered an Item in error and just want to remove it.

Step 1

Open the Item List by choosing from the menu: Inventory, Table and Item.

Step 2

Find the Item you want to remove

Step 3

Delete the Item by choosing from the menu: Edit and Delete

Note: If the Item ID has been used in other areas, such as Orders or Claims, the program will not allow the deletion and will display a message similar to the following:

frmerrordlg.jpg

Error: Remote Server: Exception

(-530) violation of FOREIGN KEY constraint “FieldName” on table “TableName”

In that case, you must remove the reference to the Item from other areas. The “TableName” will point you to are the area which contains a reference to the Item.

Tip: If you cannot delete the references to the other area, you cannot delete the Item, but you could mark the Item inactivate by removing the checkmark from the Active checkbox.

Page Tags: How, Item
«« Item Edit, HistoryWhat is the best way to enter Item Descriptions »»

Tell us what you think. Cancel reply

You must be logged in to post a comment.

RETURN TO TOP

Copyright 2014-2026 · TeamDME!, Inc. · All Rights Reserved · Log in