Browse
 
Tools
Categories

Which tables do I delete sample records from (just prior to going live)?

Author: Steve Childs Reference Number: AA-01807 Created: 2011-11-11 16:57 Last Updated: 2013-06-03 05:11 0 Rating/ Voters

Just prior to going live you need to delete certain types of Sample Data (like when you were entering test Sales Orders, Purchase Orders, etc.).  To delete this sample data open and delete all records in the following tables (in your Company Data File), generally in this order...

  • Invoice Lineitems
  • Invoice
  • Sales Order Lineitems
  • Sales Order
  • Sales Order Lost Sales
  • Quotation Lineitems
  • Quotation
  • Check Writer Items
  • Check Writer Undeposited Checks
  • Check Writer Deposit Detail
  • Check Writer
  • GL Transactions
  • GL Transactions Archive
  • Payable Payments
  • Payable Items
  • Payables
  • Payments
  • PaymentsDeleted
  • Purchase Order Lineitems
  • Purchase Order
  • tblActivities
  • tblInventoryProductsLog
  • tblJobs_Workflow_JobStatus (if you track jobs)
  • tblJobs (if you track jobs)
  • tblLog