IIF
Transaction Creator – Release Notes for recent releases
Build 7.53
- Fix a bug where automatically setting the IIF Creator to work with an example style resulted in an error message.
- Refresh built in examples.
- Extend the list of fields pulled from QuickBooks for examples to most all of the available fields.
Build 7.52
- Now when using the default Customer name from the Other Options dialog, Payment transactions will also use the default name (as well as all sales transactions.)
Build 7.51
- Add support for GoDaddy Quick Shopping Cart (QSC) data. Now you can import the QSC file into Excel as a worksheet that is ready to be exported to an IIF file.
Build 7.48
- Fix to behavior of the right-click Insert Account, Item, Name, and Class dialogs. These dialogs should now appear near the cell you right click on, and should not appear to stop responding.
- Fix to the single-row multi-amount mode export: Now do not export the transaction name as the job unless it is actually specified in the job column or is required (such as for a transfer to AR or AP.)
Build 7.47
- Added support for auto-calculation of the sales tax rates for sales tax group items. As for sales tax items, use a “?” in the Amount field of a sales tax line to enable the auto-calculation.
Build 7.46
- Revamped and simplified the IIF Creator’s menu.
- Added the Quick Start Guide option.
- Mapping dialogs in the text import wizard now sort the pick list and mapped items.
Build 7.39
- Added new option when creating examples to automatically configure the IIF Creator to work with that example.
Build 7.38
- Revised documentation to clean up images and reorganize examples section.
- Additional examples from the IIF Creator’s Examples menu.
-
Replaced most references to a “
Build 7.37
- Added Additional options for Ecommerce text file import.
Build 7.36
- No longer auto-fix the sign of the amount on Statement Charges as they can go either way, working like either a charge or a credit.
- Fix a logic error where Customer:Job names on single-row Bills were appended with “{VEND}” even though they would become Customer names.
Build 7.35
- If splitting up a General Journal because it has more than one AR or AP account, not only write a balancing row to close the transaction if the balance is not 0.00.
- Now save the program settings file in the Application Data folder instead of the folder where the addin is installed. Create a BRC folder to hold the settings file.
Build 7.32
- Fix another bug that causes accounts to be incorrectly used on transactions when they should not be, introduced in 7.28 below.
Build 7.31
- Fix a bug that causes accounts to be incorrectly swapped on transactions when they should not be, introduced in 7.28 below.
Build 7.29
- Make sure column with no titles aren’t recognized as valid columns when using the multi-amount-column configuration.
Build 7.28
- Automatically fix the accounting for some transactions if it’s backwards on the source worksheet.
Build 7.27
- Added debugging information to output files to assist support.
Build 7.26
- Now correctly export settings from the Export/Import settings menu when on the Mac using Excel 2011, working around a Microsoft Excel bug.
Build 7.25
- Add Payment transaction examples to the Examples menu for multi-row, multi-row no total, and single row layout methods.
-
Automatically convert “Check” transactions to “Cheque” transactions in the IIF file for
Build 7.24
- Add support for automatic Due Date calculation when integrating lists using the IIF file method (was already supported using direct integration method.)
- Now the right-click insert class feature correctly excludes inactive classes.
- Shortened the right-click insert pick lists’ drop down lists to 30 rows as some customers have display issues with more rows.
- Modified trouble-shooting information that is written to IIF files for support cases.
Build 7.23
-
Fix date format for
Build 7.22
- Updated treatment of date field in Amazon.com text files as Amazon changed their date format.
Build 7.21
- Added functions to the list of public functions you can call from another application, either from within Excel or another application. See updated documentation for details.
- Now if dates or document numbers appear as ##### because the columns are too narrow, their underlying values are used instead of #####.
- Now you can pick Accounts and Items from pick lists based on your QuickBooks data in the multi-amount’s setup, for use where you have a worksheet with amount values in multiple rows.
Build 7.18
- Revamped dialogs received during the import/export process.
Build 7.14
- Remove popup message added for testing (that looked like an error message, but wasn’t.)
Build 7.11
- Rows with an amount, but with no account are not included in the IIF file unless a default account is specified. Rows with a Memo continue to be included.
Build 7.07
- Now automatically split up multi-row Journal entries that use an AP or AR type account more than once into multiple transactions, so that they are importable. This way, you can crate a long/complicated General Journal transaction with multiple rows of AR or AP detail and can then import it.
Build 7.06
- Include the Doc Number on Inventory Adjustments even when the account is a non-balance sheet account.
Build 7.04
- Fix handling of imported names lists when there are no names at all in the destination file (no customers, vendors, other names, or employees) such as when working with a new empty file.
Build 7.02
- Fix the way the total transaction amount is calculated when there is VAT present and multi-row transaction detail lines are selected.
Build 7.01
- Changes to try to solve a warning that transactions are out of balance when they really are not.
Build 6.99
- Clarified the multi-row detail rows only option, to emphasize that selecting it means the IIF Creator will add a total row for the transaction. Customers, especially when importing Journal transactions, were selecting the option when not appropriate.
- Now there is always an account used on transaction accounting records, even if none is specified on the worksheet or in the other options. “Not Specified” is used in this case to make the IIF file importable. Customers can then change the account name after import and beging to specify their own default account to avoid this account being used.
Build 6.98
-
Added VAT support to the Amazon.com sales detail
text file import feature.
- Added an advanced option to force the IIF Creator to guess the worksheet data layout based on the columns that are found on the worksheet.
-
Build 6.97
- Changed the name of an internal settings file to avoid using the “_” character in the filename, which some Windows 7 systems seem to have trouble with.
-
Build 6.96
- Added the concept of a Transaction Memo, as well as the Memo fields. If you are using the single-row layout for transactions, you can now use this new field to specify a different memo for the transaction and for the detail line of the transaction. When the Transaction Memo field is not present, the IIF Creator still includes the Memo on both lines of the transaction.
- Revised the date parsing code for the text file import wizard for the Ecommerce Templates file type to better handle dates on all systems.
Build 6.95
- Changes to better handle cases where transactions like Bills & Checks transfer to AP, AR, or the special Sales Tax account. Now in these cases a vendor or customer name is used even if the original data doesn’t have a name.
Build 6.94
- Changes to right-click pick lists so you can type values with auto-complete or pick the values.
Build 6.91
- Changes to name matching code for single-row multi-amounts mode to better default when name type conflicts exist.
- No longer default to auto-add sales tax when in single-row multi-amounts mode, as tax may be specified as a column.
- When auto-adding sales tax, and no tax can be found, the per-transaction warning that is issued can cancel export.
Build 6.89
- Accommodate updated Amazon.com sales history file headers for correct import of Amazon files.
Build 6.88
- Worked around blank/invalid date issue when using Excel Mac 2011. This issue impacted only some customers.
Build 6.87
- Remove incorrect warning during error checking. Warning warned about duplicate AR or AP accounts where there were no duplicates.
- Add some additional logging when creating IIF files.
- Add warning message when integrating lists if we’re getting the wrong data back from QuickBooks (restarting or Repairing QuickBooks can resolve this.)
Build 6.86
- Update code for Ecommerce Templates shopping item taxability to correctly handle both older and newer QuickBooks versions.
Build 6.85
- When using Multi-row mode with only detail amounts, and so using the “Source Account” column, you can now customize that column name.
- Now make sure that the “Account” and “Source Account” columns are not the same column when customizing columns.
- Add error checking to warn if invoices and other sales forms are marked to send via email, but there is no available email address.
- Improve error checking results to show new list items for Classes (though this is not considered an error.)
Build 6.84
- Added option to find names by job only, instead of the full customer:job name. E.g. if you have a customer job like
Hyatt:Store #12 and you enter Store #12 the full name can now be found for import.
Build 6.83
- Automatically get terms from Customer and Vendor records if not specified on data worksheet
- Automatically calculate Due Dates from terms entered either on the data worksheet or from customer records.
Build 6.82
- Refinements to the Ecommerce Templates shopping cart text import feature.
Build 6.81
- Add support for Ecommerce Templates shopping cart files to the text import wizard.
Build 6.79
- Change code that auto-calculates amounts to round before summing the transaction in all cases (one case was missing.)
Build 6.78
- Error checking now looks for transactions where the amounts are ‘backwards’
- Add option to automatically reverse amount signs on transactions to make them work without changing the worksheet data.
Build 6.77
- Improve error checking results to show new list items for Names, Accounts, and Items (though this is not considered an error.)
- Improve recently introduced performance issue when creating an IIF file with new names.
Build 6.76
- Fix issue where Journal worksheet example didn’t appear from new user interview.
- Eliminate “file already exists” message when opening an internal file.
Build 6.75
- Changes to support Excel 2011.
Build 6.74
- Improvements for the memo field for single row transactions where a memo is not included on the worksheet. Now it is retrieved from the item, if any.
Build 6.73
- Make Qty blank on sales forms for Discounts that are a percentage and when multiple sales tax items used are used.
Build 6.72
- Change Amazon Settlement Reports import wizard to conditionally include some fees that are indirect (offered to customers and not charged by Amazon.)
Build 6.71
- Fix single-row multi-amount purchase transactions that use Items to use the item Inventory account if present, otherwise the COGS account.
Build 6.69
- Change Amazon Settlement Reports import wizard to include more fees columns from the Amazon file.
Build 6.68
- Add support for bi-weekly Amazon Settlement Reports using the text import wizard.
Build 6.67
- Fix the name matching code to find a match when the name is all numeric and starts with leading zeros, e.g. “0012345”.
- Fix the welcome/install dialog so it only appears when a new release is installed.
Build 6.66
- Make sure the new data layout always saves the ‘has titles’ option.
Build 6.65
- Doc Number now always added to General Journal transactions in IIF file regardless of account type.
- Add a new message that prompts for a choice in data layouts.
Build 6.64
- Add help button to Column Definitions dialog on the Layout tab.
- Add a layout dialog & a help file that prompts customers to choose a data layout when none is selected.
Build 6.63 – Minor Fixes.
Build 6.62 – Changes to export logic to handle some additional cases.
Build 6.61
- Change to the text import wizard for Amazon.com files. New options.
- Change to the Integrate lists dialog for clarity.
Older Recent builds:
-
- Use \n in the Memo field for various transactions to create a blank line.
- Doc Numbers for Deposit transaction detail lines now always included in the IIF file.
- Additional debugging information written to IIF file for support.
- Add support for Authorize.net files using the text import wizard.
- Add support for American Express files using the text import wizard.