Troubleshooting: Can SELECT but get errors when INSERT/UPDATE/DELETE records

Problem Description

      Can successfully run the SELECT query to get records but get errors when trying to edit, create or delete records.

Solutions

Check Rights

      First, make sure your user rights are set up and not restricted to read-only in QuickBooks or your network software.

Restriction for DELETE

      You can delete records from QuickBooks, but you must be in a single-user mode using the QuickBooks company file. Also, QuickBooks must allow you to delete records - see our Schema document for details on each file to see if it is possible to delete records from it.

      In addition, certain tables have child records that must be saved at the same time as the parent or header record.

      The child tables are listed below following the name of the parent table:

      Bill: BillExpenseLine, BillItemLine, BillLinkedTxn
      Invoice: InvoiceLine, InvoiceLinkedTxn
      Check: CheckExpenseLine, CheckItemLine
      CreditCardCharge: CreditCardChargeExpenseLine, CreditCardChargeItemLine
      CreditCardCredit: CreditCardCreditExpenseLine, CreditCardCreditItemLine
      CreditMemo: CreditMemoLinkedTxn, CreditMemoLine
      Host: HostSupportedVersions
      Estimate: EstimateLine
      ItemGroup: ItemGroupLine
      ItemSalesTaxGroup: ItemSalesTaxGroupLine
      JournalEntry: JournalEntryDebitLine, JournalEntryCreditLine
      PurchaseOrder: PurchaseOrderLine
      ReceivePayment: ReceivePaymentLine
      SalesReceipt: SalesReceiptLine
      VendorCredit: VendorCreditExpenseLine, VendorCreditItemLine, VendorCreditPaymentLin