Missing Orders

  1. Check in the DBBrowser that the record is missing from ALL of the following tables: Adjustment Database, GL Database, Order Database, Order Details Database, and Order Modifiers Database, and Payments Database
  2. Determine the date the order was created or last edited with a value change.
  3. If created since the last backup, do the following.
    1. Open the DBBrowser twice.
    2. Move the two DBBrowsers to allow you to view them at the same time.
    3. In one DBBrowser, select the Adjustment table.
    4. Filter by OrderID = XXXX
    5. In the second DBBrowser, select the Order table.
    6. Filter by OrderID = XXXX
    7. Enter in the information for the fields, CustomerID, EnteredByID, SalesPersonID, Status, Payments (if any), and any dates (e.g. OrderDate, BuiltDate, PickedUpDate) that you see in the Adjustment table into the Order table.
    8. Also, add Cyrious Tech in the Description in the Order table

**Note:** You may have to recreate the product line items for this order

  1. If created/edited before the last backup, backup_database.
  2. Open the DBBrowser
  3. Check to see if the backup from the last edit date has the missing Order information
  4. Create a folder in the SMS folder called TempData
  5. Copy the Order, Order Details Database, and Order Modifier Database and indexes from the backup to the TempData folder
  6. Open the SQL tab in the Datbase Browser and run SQL 1
  7. Run SQL 2 to ensure that the line times are re-entered
  8. Click the Execute button
  9. Run SQL 3 to ensure that the Modifiers are re-entered
  10. dbrebuild the tables that your queries did insertions

**Note:** You may have to recreate the changes made to product line items for this order to match edits if your backup is from before the last edit date

  1. Navigate to the FTP Site to Cyrious SMS\Queries
  2. Download the InsertMissingInvoices.exe utility to the Utility folder
  3. backup_database before running
  4. Run Utility
  5. It will create a list of all Invoices recreated
  6. Open Cyrious and Edit/Save each recreated Invoice

**Note:** You may have to recreate the product line items for these orders

Note: If the Order table has just the OrderID and the Store Number, but is missing everything else, you will have to delete that line before you can run SQL 1

SQL 1
INSERT INTO "Order Database"
SELECT * FROM "\\ServerName\Cyrious$\SMS\TempData\Order Database"
WHERE OrderID = XXXX

**Note:** ServerName is the name of the computer and use the correct OrderID

SQL 2
INSERT INTO "Order Details Database"
SELECT * FROM "\\ServerName\Cyrious$\SMS\TempData\Order Details Database"
WHERE OrderID = XXXX

**Note:** ServerName is the name of the computer and use the correct OrderID

SQL 3
INSERT INTO "Order Modifiers Database"
SELECT * FROM "\\ServerName\Cyrious$\SMS\TempData\Order Modifiers Database"
WHERE OrderID = XXXX

**Note:** ServerName is the name of the computer and use the correct OrderID

You could leave a comment if you were logged in.