Need help with deciphering error when importing iif

Posted on 2009-12-21
Last Modified: 2012-05-08
I'm getting an error when importing my iif file into QB. I've attached some data that is similar to what I'm importing in hopes that someone can help me understand why I'm getting the error, see below.

I'm guessing that it has to do with the !VEND in the iif but not sure so any help would be appreciated.


Question by:nike_golf
    LVL 11

    Expert Comment

    Totally not the way I would set up the IIF, but it works. The msg means just what it says, it thinks you're trying to change a name or add the same name  to a second list.

    What is line 78 in your iif? If it's a VEND linem then the vendor you are trying to create is already in the file. Maybe as a Customer or Other Name, but it's in the file so you can't add it again.  If line 78 is an ENDTRNS line, the name you're using in the transaction is already in the file as something other than a vendor, assuming you're just importing bills.

    Attached is my version of your iif. As you'll see, you need only enter the Vendor and Item one time. You also only need the transaction headers once. (As I said at the begining, yours works, just giving you a different way to look at it. Maybe it will help make it clearer as to the problem for you.) Without the actual lines that the error is refering to, that's about all I can offer.

    If you want to upload the section in question, please include from line 78 up to the first header line in that section.

    LVL 13

    Author Comment

    Thanks for the input, stlinae.

    An additional question or two before I digest and try to fix my problem.

    From the VEND perspective, "if the vendor already exists in the file", do you do mean the iif file and not in QB, in other words,  only 1 unique vendor/VEND per iif file?

    Since my data comes from a sql query how do I determine if the vendor already exists in QB to avoid duplicate vendors since these are bills?

    Also, does it make sense to have an INVITEM in a BILL? Does it matter, I need to be able to bill the same items that we inventory, does that make sense? The ACCNT for INVITEM is "Service" will using that try to create some type of recievable?

    I see that your file makes more sense than mine without the repeating header records.


    LVL 11

    Expert Comment

    "If the vendor alread exists in the file" I meant if the name already exists in the QB file. A name can only exist in the QB file one time. So, if you have a Customer Joe Black and and Vendor Joe Black, QB will not allow it. (It's smart enought to know Black, Joe is the same name too.) You would have to chang one of the names to enter it in the QB file. Joe Black - C or Joe Black - V is a common work around. This applies to all 4 names lists, Customer, Vendors, Employees and Other Names. A name can only be on one list, and once it's on one of the first three I listed, you cannot change what list its on.

    As for determinig if the name already exists in the QB file, how good are you at writing code? You'd have to use a back end application to run a check of all the names to see if it's there or not. You can look into the Intuit SDK, or what I use, ODBC. QB Enterprise Solutions comes with a read only version ODBC driver. (Can also be purchased for Pro/Premier) You can use something as simple as MS Access to query the QB file for a name first.

    Yes it makes sense to have an Inventory Item on a bill. Not sure what about the rest of that one. "will using that try to create some type of recievable?" ???
    LVL 13

    Author Comment

    Yeah, sorry about the last part I'm having a problem describing what I am trying to say.

    Take for instance the following:

    INVITEM      Additional Photographs - $2.50      PART                  Service Invoice:Photographs
    INVITEM      Service Fee - $0 - $2,499      PART                  Service Invoice:975
    !TRNS      TRNSID      TRNSTYPE      DATE      ACCNT      NAME
    !SPL      SPLID      TRNSTYPE      DATE      ACCNT      NAME
    TRNS            BILL      7/16/2009      Accounts Payable      Cal Utilities
    SPL            BILL      7/16/2009      Service Invoice:975      
    SPL            BILL      7/16/2009      Service Invoice:Photographs      

    I'm entering a BILL as can be seen by the TRNS/SPL lines but I'm using an INVITEM that has ACCNT "Service", would that create some type of receivable or is "Service" only a category and it will have no impact on the data that is entered?

    I think I understand about the VEND, if the Vendor already exists in QB I can not use the VEND line in my iff with that Vendor, I can only identify the Vendor on the TRNS line in the NAME column. I can only use the VEND for new Vendors, correct?

    LVL 13

    Author Comment

    Sorry I meant to also ask if VEND is used for the creation of Vendors only?

    LVL 11

    Accepted Solution

    Actually, "Service" (Service Invoice:Photographs) is only the name of the Account the Inventory Item is going to. The account type, by default, should be an Income account. The account name has no impact on the data and the account type will  have little to no impact. (Certain account types cannot be used in certain transaction, but that doesn't seem to be the case here.)

    The only way to have a receivable in the QB data, is to create one. Entering a Bill will only create a transaction in your Account Payables. To get a Receivable, you will have to create an Invoice transaction (INVOICE under the TRANSTYPE in the iif format) You would select the same item you received the bill for to have a receivable show for the item.   -Make Sense???

    VEND will onlky create Vendors. CUST is used for Customers, EMP for Employees. This should take you to the Intuit IIF tool kit. I wrote most of it back in the day, but haven't looked at it since I left so don't know if they've kept it up to date. It should expalin things better for you.

    "I think I understand about the VEND, if the Vendor already exists in QB I can not use the VEND line in my iff with that Vendor, I can only identify the Vendor on the TRNS line in the NAME column. I can only use the VEND for new Vendors, correct?"  Nope. ;-)  The VEND! (Header row) and VEND (vendor data row) can be used even if a vendor already exsists in the file but do not NEED to be used. I suggest not using the VEND! iif for a vendor already in the file as if can create issues, but that's only my suggestion.

    If "John Black" is in you QB file as a customer for example, you cannot create VEND John Black. (With an iif or directly in the QB file.) It also holds true, that if "Jane White" is already a vendor in your QB file, you cannot use an iif to create CUST! Jane White.
     Once created, a name TYPE cannot be changed.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    By Linda Saltz Customized item descriptions from bills DO import into a customer invoice!   This is a wonderful tip for companies that want to use generic items like Hardware, Software, Mileage, Travel in their item list which helps keep the i…
    You may need to view past transactions from previous QuickBooks files or other QuickBooks company files when:       1. you are working in another QuickBooks file       2. QuickBooks is closed QuickBooks users who would benefit from this artic…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now