Home » Documentation » Utilities » Edit IDs

Documentation

Edit IDs

This menu performs two important, but dangerous functions.

First, it allows you to change and consolidate various ID fields that cannot otherwise be edited in Simple Accounting. Normally an ID field cannot be edited since this would compromise the relationship of various data files. However the Clean Up menu allows you to make these changes safely.

You may wish to change a Product ID from ‘ENVR10’ to ‘ENV-10-REGULAR-SMITH’

You have a customer whose business was purchased by another customer of yours. It is now necessary to combine (consolidate) the customer and all order history in with the purchasing customer.

Secondly, you may use Clean Up to delete a record and all related records.

When first running Simple Accounting, you entered a product incorrectly and accidentally billed a practice order using the incorrect Product. You now wish to delete the Product and the incorrect order. Normally, you cannot delete any Product for which an order has been invoiced.

You have a customer who has gone out of business several years ago. You wish to delete the customer and all their order history and products.

IMPORTANT IMPLICATIONS TO YOUR DATA WHEN USING THIS FUNCTION!

  1. This procedure is irreversible Once a record’s ID field has been changed, or deleted, it may not be recovered except by restoring from a backup (you do have one don’t you?)
  2. If you change a record, you are changing every reference to that record in Simple Accounting. This means that once you change a record (a Customer ID for example), every other reference in Simple Accounting which used the old Customer ID, now must be referred to by the new Customer ID. This includes, Sales Orders, linked products, F/M counts, etc. Normally this is what you want, but confusion can result if there are users who are not informed that a field has been changed.
  3. Changing a field name to a field name which is already in use will consolidate (combine) records together As in the above example, if you change a customer’s Customer ID to a Customer ID already in use by another customer, you are in effect, combining the two customers.
  4. Deleting a record’s ID field deletes all references to that record This means that once you delete a record (a Product ID for example), every reference to that Product in Simple Accounting is removed, including sales orders, counts, P.O.s. etc. If you then re-printed an invoice which used this product it would no longer contain the line item with that Product ID. And, if the invoice was only for that one line, the invoice would itself be voided (since an invoice may not contain 0 line items in Simple Accounting).

You will not be able to perform any Clean Up functions while other users are logged into Simple Accounting.

Procedure

  1. Select type of field to change:

    • Product ID
    • Product Type
    • Employee ID
    • Terms ID
    • Ship To Address
    • Contact ID
    • Customer ID
    • Vendor ID
    • Sales Tax ID
    • Unit of Measure
  2. Enter the Current Value
  3. Enter the New Value
  4. Select the action to be performed
  5. Press [Proceed]
Last Revision: 10.11.2012
x

Contact

How Can We Help?

Other Ways To Reach Us

Sending your message. Please wait...

Thanks for sending your message! We'll get back to you shortly.

There was a problem sending your message. Please try again.

Please complete all the fields in the form before sending.

x

Add this topic to your list of favorites?