Softpedia >Windows >Office tools >Other Office Tools >Excel Add-In for QuickBooks >  Changelog

Excel Add-In for QuickBooks Changelog

What's new in Excel Add-In for QuickBooks 15.0.5886

Apr 6, 2016
  • Version 4 has a few changes that can break version 3 code. These incompatibilities are mentioned below.
  • Removed Columns:
  • In V3 there were a few columns reported in our tables that were either redundant or were not supported in the underlying QuickBooks SDK and thus never returned data. These columns have been removed and are mentioned below
  • BillPaymentChecks: CreditCardId and CreditCardName have been removed. These are only applicable for BillPaymentCreditCards.
  • BillPaymentChecksAppliedTo: CreditCardId and CreditCardName have been removed. These are only applicable for BillPaymentCreditCardsAppliedTo.
  • BillPaymentCreditCards: BankAccountId and BankAccountName have been removed. These are only applicable for BillPaymentChecks.
  • BillPaymentCreditCardsAppliedTo: BankAccountId and BankAccountName have been removed. These are only applicable for BillPaymentChecksAppliedTo.
  • Employees: Line5 and Note have been removed. These are not available on the Employee Address, despite being available on every other address in QuickBooks.
  • ItemSites: Name has been removed. This column is not available in QuickBooks.
  • PurchaseOrderLineItems: Message has been removed. This was a redundant column, use VendorMessage instead.
  • PurchaseOrders: Message has been removed. This was a redundant column, use VendorMessage instead.
  • Column Type Changes:
  • In V3, there were a few columns in our tables that had incorrect column types. These types have been corrected in V4
  • BillExpenseItems: TxnNumber changed from string to integer.
  • BillLineItems: TxnNumber changed from string to integer.
  • Bills: TxnNumber changed from string to integer.
  • CheckExpenseItems: TxnNumber changed from string to integer.
  • CheckLineItems: TxnNumber changed from string to integer.
  • Checks: TxnNumber changed from string to integer.
  • CreditMemoLineItems: TxnNumber changed from string to integer.
  • CreditMemos: TxnNumber changed from string to integer.
  • Currency: IsActive and IsUserDefinedCurrency changed from string to boolean.
  • Customers: Sublevel, CreditCardExpMonth, and CreditCardExpYear changed from string to integer.
  • DepositLineItems: CashBackAmount changed from string to double. TxnNumber changed from string to integer.
  • Deposits: CashBackAmount changed from string to double. TxnNumber changed from string to integer.
  • EstimateLineItems: TxnNumber changed from string to integer.
  • EstimateLinkedTransactions: TxnNumber changed from string to integer.
  • Estimates: TxnNumber changed from string to integer.
  • InventoryAdjustmentLineItems: ItemNewQuantity, ItemNewValue, ItemQuantityDiff, and ItemValueDiff changed from string to double.
  • InvoiceLineItems: BalanceInHomeCurrency changed from string to double. TxnNumber changed from string to integer.
  • InvoiceLinkedTransactions: TxnNumber changed from string to integer.
  • Invoices: BalanceInHomeCurrency changed from string to double. TxnNumber changed from string to integer.
  • ItemReceiptExpenseItems: TxnNumber changed from string to integer.
  • ItemReceiptLineItems: TxnNumber changed from string to integer.
  • ItemReceiptLinkedTransactions: TxnNumber changed from string to integer.
  • ItemReceipts: TxnNumber changed from string to integer.
  • Items: PurchaseDate and AssetWarrantyExpires changed from string to date. ReorderPoint changed from string to double.
  • ItemSites: ReorderLevel changed from string to double.
  • JournalEntries: TxnNumber changed from string to integer.
  • JournalEntryLines: TxnNumber changed from string to integer.
  • PurchaseOrderLineItems: TxnNumber changed from string to integer.
  • PurchaseOrderLinkedTransactions: TxnNumber changed from string to integer.
  • PurchaseOrders: TxnNumber changed from string to integer.
  • ReceivePayments: TxnNumber changed from string to integer.
  • ReceivePaymentsAppliedTo: TxnNumber changed from string to integer.
  • SalesOrderLineItems: TxnNumber changed from string to integer.
  • SalesOrderLinkedTransactions: TxnNumber changed from string to integer.
  • SalesOrders: TxnNumber changed from string to integer.
  • SalesReceiptLineItems: TxnNumber changed from string to integer.
  • SalesReceipts: TxnNumber changed from string to integer.
  • VendorCreditExpenseItems: IsTaxIncluded changed from string to boolean. TxnNumber changed from string to integer.
  • VendorCreditLineItems: IsTaxIncluded changed from string to boolean. TxnNumber changed from string to integer.
  • VendorCreditLinkedTransactions: TxnNumber changed from string to integer.
  • VendorCredits: IsTaxIncluded changed from string to boolean. TxnNumber changed from string to integer.
  • Column Size Changes:
  • In V3, most string columns were returned with the default column length of 2000. In V4, we have gone through the QuickBooks SDK and added appropriate column lengths for all of the columns where the information is available from Intuit.
  • Other Changes in Desktop Edition:
  • In V3, the EmployeeType, Gender, and PayPeriod columns on the Bills table were prefixed with different characters depending on the column. This has been changed so that the data is reported exactly as it is in the QuickBooks UI.