Hi, We're currently using QuickBooks 2007 Enterprise. Each month we have appx. 300 agents that we need to pay commissions. These commissions 'bills' need to be entered into QuickBooks (one transaction per agent per month). QuickBooks has an import function using .iif files that will allow us to automatically import the agent commissions but the .iif file must be in a certain format. In our Access db I've setup a make table query that will create all the agent commission information needed for the import into QuickBooks but I'm hoping for some help on how to write a vba Access function that will take the table information and generate a properly formatted .iif file for me with the 300+ agent commission information. I've attached a workboot that will hopefully make it a little clearer. One sheet in the workbook (Sample Quickbooks Import File) shows the format of the import file (this is the file I'm trying to create with VBA). The only fields that will be pulled from the table are Date, Accnt, and Amount. However each row must be formatted exactly for QuickBooks to use it. The second spreadsheet is a sample of the tblAgentCommissions2QuickB
ooks table. Any help is much appreciated. Thanks in advance.
Start Free Trial
