01 Transaction Pro Importer 5.0 - Check for Program Updates

We could not determine your current version of the program.

A newer version of the software is available. You can download it here Download Version TPI5019.zip
After downloading unzip the file and run the setup.exe to update your program.


Version Notes Transaction Pro Importer 5.0 Release Notes

QUICKBOOKS MUST BE INSTALLED ON THIS MACHINE OR THE PROGRAM WILL NOT RUN !!!

You must be using QuickBooks Financial Software, Pro or Premier Editions (2003 -

2015), or Enterprise Solutions (2.0 - 15.0), or Simple Start 2006-2015.

 

Version 5.019 6/7/15

When importing a credit card statement, the payee was not showing in the register for a credit card credit.

Fix issue with UOM where abbreviation was not being accepted for Default Units. User should specify full name and not abbrev. for these cases.

Fix issue on item receipt where using item assemblies were not setting the site.

When importing a credit card statement, setting the Billable Entity caused an error - Object variable or With block variable not set.

When importing a credit memo with the ecommerce options set, the last transaction was not having the ecommerce fields added to the transaction.

Journal entries are now prevalidated for missing accounts.

Price Levels Custom Price changed to string datatype within DLL due to extra decimals occuring.

Payee alias feature changes so that any accounts that are filled in are not overwritten when loading the payee alias file.

Add support for Shipping address on Estimates. QuickBooks 2008 or later required.

Added Tax Code Purchase to item list import for non US versions.

 

Version 5.018 6/12/14

Fixed that TPI was not including OtherIncome and OtherExpense account types when loading. This was causing the false error "Could not load chart of accounts" if no accounts of Income or Expense existed in the QB file.

Credit Card Statement Import. Billable and Billable Entity fields were not being set on credit card charge.

Added command line /NO_COA for bypassing loading chart of accounts on files with massive chart of accounts > 5000.

Added field Amounts In Home Currency for multi-currency Journal entry.

Fixed issue in setting do not add employees option

Fixed option Bill Column Row not saving

Fixed vendor prefill first account being cleared on purchase transaction

Bill Payment Payment Method can be set to Credit. Previously you needed the words "Credit Card" to do a bill payment via a credit card or an error would result.

 

Version 5.017     1/9/2014

Fixed bug in Check import when enabling /USE_AMOUNT - invalid property array index.

Added Sales Tax Code to Item Receipt for non US versions.

Fixed bug where employee earning types were not being returned for employee list updates.

 

Version 5.016     7/26/2013

Fixed bug in UK versions caused by adding new fields in 5.013. Program was generating error WriteVendor - invalid procedure call or argument Error #5 when attempting to create vendors.

Fixed issue where Price level list import was returning this key is associated with an element of this collection for some QuickBooks files.

Fixed issue GetAccountFieldFromArray, subscript out of range occurs when attempting to import a sales transaction when the Account Cross Reference advanced option is checked.

Fixed bug in Employee List where SSN could not be set.

Fixed bug where in multi-currency installs of QuickBooks and both the customer and job was not created the newly created customer and job was being created in the home currency and the currency field was being ignored.

Vendor Credit - changed logic to group by both Vendor and RefNumber. A change in either value starts a new transaction.

Added Transfer import type (QuickBooks 2013 or later)

Added Transfer Inventory import type (QuickBooks Enterprise 11 or later)

Added custom fields to Invoice Link Sales Order import type.

Added COGS Accounts to Item Settings Account dropdown list.

 

Version 5.015     6/20/2013

Vendor List Import - QuickBooks 2008 and earlier users were getting 'Object variable or With block variable not set' error message.

Bank Statement - Added Billable and Billable Entity fields

Added Credit Card Statement Import Type

 

Version 5.014     6/7/2013

On employee list import, SSN number field is now updated.

On Receive Payment using the /RECPAY_AUTOAPPLY, the Auto Apply field was not working properly.

Added Addr Line5 to Customer list import when command line /ADDR_LINE5 is set

Disable checkbox for auto assigning transactions that do not support that feature. Example, bills, credit card charges.

Fixed log file which was not handling Bill and Check transaction correctly when the user data contained the same RefNumber for each row but different Vendor/Payee.

 

Version 5.013     4/15/2013

Allow zero dollar invoices to be imported

Added cross reference functionality to vendor list and customer list imports

Added new fields to vendor list for non US versions: Is Tax Tracked on Purchases, Is Tax Tracked on Sales, Is Sales Tax Agency, Tax On Purchases Account, Tax On Sales Account, Tax Registration Number.

With 2012/2013 QB installations the due date was calculating based on the system date, not the transaction date.

 

Version 5.012     3/21/2013

Added Vendor List Account Prefill field

Added Vendor List Billing Rate field

Fix Estimate error when setting Subtotal item

Fix date driven terms calculation issue on sales transactions

Command line /ADDR_LINE5 - adds Address Line 5 to most transactions with Bill To Note and Ship to Note or Address Note.

Fix Bank Statement error handler. Returning incorrect invalid property array index instead of the error message back from QBSDK.

 

Version 5.011     1/15/2013

Fix issue where creating an estimate with a discount item was causing an error

Disable Customer and Vendor Cross reference option when importing customer or vendor list

Added Inventory Site and Serial/Lot Number support to Invoice Link Sales Order import type

Fix Bank Statement import where non existing class was not being added

Fix Advanced Option Journal Entry Offset not setting on load

Fix Item Fixed Asset. Setting a Sales Description without a Sales Date was causing XML parser error. Now Sales Description is ignored unless a Sales Date is provided.

Fix /USE_AMOUNT. Cost is now recalculated before saving sales transaction line.

 

Version 5.010     12/6/2012

Handled QB 2013 bug “customer is duplicated” when setting Do not add new customers or using customer xref

Added Receive Payment Discount Class field (QuickBooks 2012 or later)

 

Version 5.009     12/1/2012

Fix When specifying a bill with a group item, TPI was returning the following error: The field "Desc" is not supported by this implementation.

Fix BillPayment - specifying a Discount account of type COGS was causing a message indicating an invalid account type. This has been fixed.

Fix Price Levels change level per item to double data to prevent rounding

Fix preferred vendor not updating on item list when item type was inventory

Bank Statements - Added Class field

Bills - change logic to look at both the vendor name and the refnumber when determining when to start new bills

Item Receipt - Add expense fields

Journal Entry - Add IsAdjustment field for QuickBooks 2008 and later

Vendor Credit - added support for /USE_AMOUNT command line

Sales Order - added support for /ITEMACCT command line

Ability to check/uncheck Auto Assign transaction numbers. /AUTO_ASSIGN=1 to check the box /AUTO_ASSIGN=0 to uncheck the box

New Import type - Item Sales Tax

 

Version 5.008     9/16/2012

Receive Payment - specifying a Discount account of type COGS was causing a message indicating an invalid account type. This has been fixed.

Added new command line parameter /EXPENSES_CUSTOMER_NO_ADD. When set TPI will not add a new customer when mapping to the Expenses Customer field on Accounts Payable transactions.

Added support for Sales Tax Item on Journal Entries for Canada 2008 or later.

Added Parent field reference for Item Assembly import

Skip duplicates was not functioning properly on Item Receipt w/Bill import type.

Added Is Tax Included field to Bank Statement import to support non US versions of QuickBooks (Amounts Incl. Tax checkbox)

Added Is Pending to Sales Receipts

Fix ability to Set Tax Code on Item List import

Modified fields.tpi to include Bank Statement Chk. No. field

 

Version 5.007 6/21/2012

Fix issue caused by adding Date Released field. Was setting to None and causing error when using /TIME_RATE command line.

Revisit and fix a rounding issue that was occurring on some other transactions

Item List - Fix issue where updating a non-inventory part that has sales and purchase info was causing a Object variable or with block variable not set

Added field Terms to Estimate

Item Receipts – UOM  Serial/Lot Numbers added

Inventory Adjustment - fix issue where unable to set value to zero

Added field Sales Tax Country to support UK 2012 where this field was required when creating a customer.

Check and Credit Card Charge - change logic when either RefNumber or Payee changes a new transaction is started.

Activation button now has to be clicked when attempting to activate.

 

Version 5.006 3/26/2012

Fix trouble connecting via ODBC to mySQL using 3.51 driver.

Employee List - Added Date Hired and Date Released fields (insert only)

Receive Payment - added support for applying a payment to a statement charge.

Item Group - Added field Print Items in Group.

Sales Order - adding a group item with a Qty of one was not displaying 1 in QuickBooks

Bank Statement - Remove Undeposited Funds from account list. QB doesn't allow using this account

Bank Statement - Accounts and Names with ascii value less than < were being added before <Add New> and causing issues.

Fix - vendor list import was not displaying error message when updating vendors. Fixed error handler to parse out notes bug in sdk.

Fix - UK 2012 R6/R7 - handle bug when starting TPI (invalid procedure call or argument) followed by error retrieving accounts. Caused by unhandled new account type suspense.

 

Version 5.005 2/6/2012

Fixed rounding issue that was occurring on some transactions

Changed Exchange Rate to support 6 decimal precision.

When importing credit card charges and credits and creating a new item, the cost instead of the price is populated.

Added ability for users with internet proxy servers to activate the software

Added support for specifying serial and lot numbers (Enterprise 12 required)

 

Version 5.004 12/23/2011

Removed unsupported service date field on estimates

Added Other1_Header and Other2_Header to Purchase Orders

Added Adj Value field to inventory adjustments to support SDK 10+

Fix do not add new accounts to also include account numbers

Add skip and replace options feature to /RECPAY2

Fix issue with item assembly import validation error with UOM enabled

 

Version 5.003 11/15/2011

Fixed issue where a bill item was defaulting to the item price when zero was specified.

Fixed issue where an inventory adjustment item was defaulting to the item price when zero was specified.

Fixed issue where in some cases price was not rounding up when using the -USE_AMOUNT command line.

Fixed issue where custom fields were not saving to purchase order.

Added Template Name field to Purchase Order.

 

Version 5.002 10/13/2011

Corrected issue with Enterprise 12 creating/editing vendors (the customers object was saved

successfully, but its corresponding notes record could not be saved) when the option "Do not

update addresses" is unchecked.

 

Version 5.001 10/10/2011

Added Site to Inventory Adjustment

Log file not displaying when auto-increment option checked

Alias feature not bringing in Expenses Account field

Changed Fields.tpi for Bank Statement.Payee from 999 to 31.

Added cross reference feature to Customer List and Vendor List imports

 

Version 5.000 9/15/2011

Initial Release