x

Start now

Schedule a demo

  • Date Format: MM slash DD slash YYYY
  • This field is for validation purposes and should be left unchanged.
Which tables do I delete sample records from (just prior to going live)? – OneSource: Inventory for QuickBooks Online Which tables do I delete sample records from (just prior to going live)? – OneSource: Inventory for QuickBooks Online

Have a Question?

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

You are here:
< All Topics

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
Previous What should I double check before going live with OneSource? ( Final GoLive Checklist )
Next Field Mapping–Open Purchase Orders
Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Table of Contents